Complete Description:
The District of Columbia Department of Healthcare Finance (DHCF) is the agency within the District’s government that administers the Medicaid program – a program responsible for providing healthcare services for more than one-third of the District’s residents. DHCF processes more than one million Medicaid claims a month using its Medicaid Management Information System (MMIS). DHCF is seeking to organically build a Medicaid data warehouse using SAS that will serve as a repository for the aforementioned Medicaid claims. The Medicaid claims in the SAS environment will be used for data mining purposes in an effort to better understand the Medicaid population being served, the services being rendered, and the providers rendering those services. The SAS data warehouse environment will also be used to satisfy adhoc and federal reporting requirements.
The SAS data warehouse project has been four phases. Phase 1 focuses on the establishing the Medicaid data warehouse using a small number of data elements. Phase 2 of the project serves to expand the number of data elements in the data warehouse. The focus of Phase 3 is adhoc and federal reporting. Phase 4 focuses on a specialized federal reporting called T-MSIS.
In order to implement the SAS data warehouse, DHCF needs the assistance of a Business Analyst 5. The Business Analyst 5 will be a member of a three person SAS team that will work with the DHCF SAS user group to capture and define data warehouse and reporting requirements. The Business Analyst’s primary responsibilities will focus on the full life cycle software development and maintenance of the SAS applications and reports developed using SAS Office Analytics and SAS Enterprise Guide.
Additionally, the Business Analyst will be responsible primarily for the following tasks:
• Create SAS datasets of claims data from Medicaid claims databases; create status and efficacy datasets; create project specific macros and formats; load claims-related data from Medicaid claims platforms and other healthcare-related platforms; prepare data to be used by the client.
• Working with the client to develop the most effective SAS data warehouse implementation strategy
• Prepare documentation describing all datasets and variables within, including derived variables, and the project as a whole.
• Perform data checks as needed, to ensure integrity and correctness of data displays. Prepare documentation for programs.
• Formulate program approaches and consult with the internal client or team members to clarify requirements.
• Write, test, implement, and refine SAS code; provide input to progress reports.
• Perform required quality control and assurance activities including benchmarking results.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
Experience in SAS applications programming
Required
12
Years
Unix or Windows server experience
Required
5
Years
SAS Enterprise Guide experience
Required
6
Years
Experience with SAS business intelligence tools
Required
5
Years
Experience processing large data files
Required
3
Years
Experience with phases of the System Development Life Cycle (SDLC)
Required
10
Years
Experience documenting SAS processes and macros
Required
8
Years
Experience with relational databases such as Oracle or MS-SQL
Required
5
Years
SAS 9 Certified
Required
Master's degree
Required
Experience as SAS Senior Consultant
Required
12
Years