IT Lead SAS Programmer

Job Title: IT Lead SAS Programmer (737026)

Location: Dix Campus Raleigh North Carolina REMOTE

Duration: 12 Month Contract with possibility to extension

Job Description:

Client is seeking a Lead SAS Programmer to perform work related to the enhancements of the Transformed Medicaid Statistical Information System as per the Federal mandate to support the Medicaid Reform.

Client is seeking a Lead SAS Programmer to perform work related to the enhancements of data extracts for the Transformed Medicaid Statistical Information System as per the Federal mandate to support the Medicaid Reform Project.

This position is responsible for quality assurance of data and interaction with division/federal staff vendors and stakeholders to resolve data quality issues and manage all data extracts based on the

policies and standards.

This position is also responsible for analyzing and data mapping utilizing data and information from data warehouse Medicaid claims processing system (MMIS Claims Eligibility provider etc Encounter Processing system(PHPEncounters) PBM (RX Claims) .

Future opportunities for this position include the development of Tableau Dashboards Job scheduling building/maintaining parameterized SAS Stored Processes and providing SAS programming training/support to the DHHS staff and staff of other State agencies.

Required:

Experience building ETL process flows in the SAS BI Tool Data Integration Studio (SAS/DI) or a similar ETL tool.

Advanced level programming in SQL SAS Data Step and SAS Macro.

Proficiency with joining tables from an RDBMS such as Oracle.

Proven experience delivering Business Intelligence solutions

Desired:

Knowledge of health insurance data.

Experience with metadatadriven SAS code generation.

Experience with SAS Enterprise Guide and Management Console.

Experience with Tableau dashboard design and development.

Should have the capability to translate business requirements into technical solutions

Required

5

Years

Should have the capability to develop SAS Programs and run the programs in Batch mode to create extract files for CMS.

Desired

Demonstrated proficiency working with databases Oracle (11) MS Sql server etc. DB2

Required

5

Years

Extensive SAS programming knowledge SQL Pl/Sql and other SAS tools (Base SAS 9.2 SAS BI Suite Enterprise guide

Required

5

Years

Strong understanding of healthcare claims processing Claims Provider Eligibility

Highly desired

Understanding of data modeling techniques and experience working with relational data base concepts and data

Required

5

Years

Handson experience in different file transfer methodologies and different file types and layouts

Highly desired

Years

Working knowledge of Medicaid and/or MMIS

Highly desired

Excellent verbal and written communication skills with the ability present to both technical and business audiences.

Desired

Proven experience delivering Business Intelligence solutions

Required

4

Years

Hands on ETL tool experience

Required

5

Years

Experience with Tableau dashboard design and develop