Lead SAS Programmer Healthcare

Company: Mahantech Corporation
Location: Raleigh
Posted on: September 14, 2020

Job Description:

Role DHHS- IT Lead SAS Programmer (634946) Duration 12 Months Location Dix Campus Raleigh North Carolina Interview Mode Webcam Interview Only Type Contract Start Date Immediate NC Dept of Health and Human Services (DHHS) 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. NC Dept of Health and Human Services (DHHS) 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 divisionfederal 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(PHP-Encounters), PBM (RX Claims) . Future opportunities for this position include the development of Tableau Dashboards, Job scheduling, buildingmaintaining parameterized SAS Stored Processes, and providing SAS programming trainingsupport to the DHHS staff and staff of other State agencies. Required Experience building ETL process flows in the SAS BI Tool Data Integration Studio (SASDI) 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 metadata-driven SAS code generation. Experience with SAS Enterprise Guide and Management Console. Experience with Tableau, dashboard design and development. Required Skills 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, PlSql 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 Hands-on experience in different file transfer methodologies and different file types and layouts Highly desired Working knowledge of Medicaid andor 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 Nice to have

Keywords: Mahantech Corporation, Raleigh , Lead SAS Programmer Healthcare, IT / Software / Systems , Raleigh, North Carolina