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 for data staging and integration, and also to satisfy adhoc and federal reporting requirements.
The SAS data warehouse project has four phases. Phase 1 focuses on establishing the core Medicaid data warehouse using a limited 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 SAS Developer Consultant. The SAS Developer Consultant will be a member of a three person warehouse development team that will work with the DHCF SAS user group to capture and define data warehouse and reporting requirements. The SAS Developer’s primary responsibilities will focus on the full life cycle of software development and maintenance of the SAS applications and reports developed using various components including, but not limited to, SAS Analytics Pro, SAS Office Analytics and SAS Enterprise Guide.
Additionally, the SAS Developer Consultant will be responsible primarily for the following tasks:
• Create SAS datasets from Medicaid claims databases; perform data linkages where needed; 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.
• Prepare documentation (metadata and data dictionaries) 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.
• Conduct training on warehouse related SAS programs and components.
Skills:
Skill
Required / Desired
Amount
of Experience
Expertise Rating
SAS 9 Certification
Required
Bachelors's Degree
Required
SAS applications programming experience
Required
12
Years
3 - Expert
Unix or Windows server experience
Required
5
Years
3 - Expert
SAS Enterprise Guide experience
Required
6
Years
3 - Expert
SAS business intelligence tools experience
Required
5
Years
3 - Expert
Experience processing large data files
Required
3
Years
3 - Expert
Experience with phases of the System Development Life Cycle (SDLC)
Required
10
Years
3 - Expert
Experience documenting SAS processes and macros
Required
8
Years
3 - Expert
Experience with relational databases such as Oracle or MS-SQL
Required
5
Years
3 - Expert
Experience providing support for development issues related to architecture and/or performance
Required
3
Years
3 - Expert