Data Analyst - Foundational Community Supports (FCS)

Description

Days Off: Saturday, Sunday

Shift: Office Day

Insurance Benefits: Dental, Life, Long-term Disability, Medical

Other Benefits:  Employee Assistance Program (EAP), Flexible Spending Account (FSA),  ORCA card subsidy, Paid Time Off (34 days per year), Retirement Plan

About DESC:

DESC  (Downtown Emergency Service Center) is a nonprofit  organization working to help people with the complex needs of  homelessness, substance use disorders, and serious mental illness  achieve their highest potential for health and well-being through  comprehensive services, treatment, and housing. Our vision is a  community where no person is abandoned, ignored, or experiencing  homelessness.

As the region's leading provider of services to  multiply disabled adults who have experienced chronic homelessness, DESC  serves almost 3,000 people each day. Our integrated service model is  designed to help people secure and maintain appropriate, safe and  affordable housing. DESC is recognized nationally and regionally as an  innovator in developing solutions to homelessness.

JOB DEFINITION:

The Foundational Community Supports (FCS) Data Analyst is a member of a multi-disciplinary team that will support DESC’s mission by using data queries, creating reports, and providing administrative services for programs leveraging the 1115 Waiver. Considerable attention and skills are needed in the areas of data analytics, presentation, and problem solving. The FCS Data Analyst will work closely with the Senior Manager of Policy and Program Analytics to ensure programs leveraging Medicaid Waiver dollars are complying with all applicable laws, regulations and contract requirements. 

MAJOR DUTIES AND RESPONSIBILITIES:

• Use data sources to perform validation and quality control checks to track performance and compliance in identified areas.  
• Assist with the collection of data and analysis requested by FCS third party administrator, Wellpoint.  
• Use SQL to access data and write reports to query information from databases.  
• Assist staff with client enrollment and communication of benefit status information.  
• Identify and create process improvements and workflow automation to increase program performance.  
• Collaborate with the Housing and Quality and Information Management  Departments and other DESC partners to scope, design, and validate  recurring and ad hoc reports.  
• Document project details and  maintain report specifications that clearly describe how the report  works, and work with end-users to ensure usage and usability.  
• Serves as a subject matter expert for department managers on  documentation standards that comply with regulatory requirements.  
• Research, audit, and investigate proper payment of claims.  
• Assist in various quality assurance activities, including but not limited to fidelity audits.  
• Serve as a liaison between Wellpoint, King County, HCA, and DESC on all administrative matters.  
• Comply with all agency policies and procedures, relevant Washington Administrative Code, RCWs, and HIPAA Privacy Rules.  
• Attend and participate in relevant team meetings, agency sponsored trainings and all-staff meetings.  
• Other duties as assigned.

Requirements

MINIMUM QUALIFICATIONS:

• Bachelor’s or associate degree, or 2 years of highly relevant paid work experience  
• 2 years’ experience in data analytics and financial accounting  
• Strong computer skills, including using word processors, analyzing Excel spreadsheets, and writing SQL queries.  
• Strong oral and written communication skills and ability to work  effectively with staff from various backgrounds and disciplines.  
• Ability to organize and coordinate work efficiently; prioritize  workload, work under pressure with tight timelines and changing  priorities.  
• Ability to work independently with minimum supervision, and act on own initiative, within agency procedural guidelines.  
• Initiative and creativity in problem solving and system development.  
• A willingness to be flexible and work cooperatively with co-workers to accomplish all responsibilities of the team.  
• Subscribe to philosophy of cooperation and continuity across programs, and of consideration and respect for clients.  
• Experience handling confidential and proprietary information, including healthcare information 

PREFERRED QUALIFICATIONS: 

• Experience working in social services with people experiencing  homelessness, mental health conditions, and/or substance use disorders 
• Bachelor's degree in computer science, accounting, data analytics,  healthcare management, analytical science, engineering, or related field  or equivalent experience: advanced degree a plus. 
• 4 years highly relevant paid work experience. 
• Experience working in administration/coordination in a human services, housing or health care setting.  
• Experience with a formal programming language, such as Python, or R, PHP

PHYSICAL DEMANDS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee will be required sit for long periods of time, communicate with other employees by talking and hearing, and to operate computer systems. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

EQUAL OPPORTUNITY EMPLOYER:

DESC is  committed to diversity in the workplace, and promotes equal employment  opportunities for all staff members and applicants. The Agency will not  discriminate against any employee or applicant for employment on  the basis of race, creed, color, sex, gender, sexual orientation,  age, national origin, caste, marital status, or the presence of any  sensory, mental or physical disability in any employment practice,  unless based on a bona fide occupational qualification. Minorities and  veterans are encouraged to apply.