Lead Sas Programmer

Description:

• 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(PHP-Encounters), 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:

• Should have the capability to translate business requirements into technical solutions
• Should have the capability to develop SAS Programs and run the programs in Batch mode to create extract files for CMS.
• Demonstrated proficiency working with databases - Oracle (11) ,MS Sql server etc. DB2
• Extensive SAS programming knowledge, SQL, Pl/Sql and other SAS tools (Base SAS 9.2, SAS BI Suite, Enterprise
• Highly desired Strong understanding of healthcare claims processing - Claims, Provider, Eligibility
• Understanding of data modeling techniques and experience working with relational data base concepts and data
• Highly desired Hands-on experience in different file transfer methodologies and different file types and layouts
• Highly desired Working knowledge of Medicaid and/or MMIS
• Excellent verbal and written communication skills with the ability present to both technical and business audiences.
• Proven experience delivering Business Intelligence solutions
• Hands on ETL tool experience
• Experience with Tableau, dashboard design and develop