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 an Emerging Architect 2.  The Emerging Architect 2 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 Emerging Architect’s primary responsibilities will focus on the underlying data infrastructure supports the Medicaid data warehouse.   The Emerging Architect 2 will have the following tasks:

 

• Administer and monitor the overall health of the SAS platform and data warehouse.

• Create and maintain the database schema for SAS data warehouse. 

• Perform performance tuning, capacity and utilization monitoring, backup strategy and disaster recovery planning.

• Apply maintenance releases, upgrades and hot fixes as required. 

• Administer, secure, and back up the metadata, including, the metadata server, SAS metadata objects, metadata repositories.

• Set up data access, including registering libraries and tables in the metadata, updating table metadata, setting up data access, troubleshooting data access.

• Administer  users, groups, and roles - implement different Security methods based on Business Unit or Project related needs.

• Investigate data anomalies and run queries, as needed. 

• Establish best practices and Standards in SAS.

• Analyzing data and create stored processes using SAS Enterprise Guide.

• Executing change control and promotions activities.

• Recommend and Implement analytic strategies or solutions to meet the demands of business requirements.

Relational database experience as an architect (e.g. Oracle or MySQL)

Required

8

Years

3 - Expert

Experience processing large health care data files

Required

3

Years

3 - Expert

Unix or Windows server experience

Required

4

Years

3 - Expert

Experience in SAS applications programming

Required

3

Years

3 - Expert

SAS Enterprise Guide experience

Required

3

Years

3 - Expert

Experience documenting SAS stored procedures and macros

Required

4

Years

3 - Expert

SAS 9 Certified

Required

 

 

 

Master's degree