Job ID: NC-634626 (98590827)
Healthcare SAS/ETL Developer with Oracle/DB2, PL/SQL, Base/BI/Enterprise/Miner, data modeling, MMIS/Medicaid, file transfer, Mainframe (must) and Eligibility/Claims/Provider data experience
Location: Raleigh NC (DHHS)
Duration: 12 months
Positions: 1 (1/3)
Skill Required / Desired Amount of Experience
Should have the ability to extract, manipulate and categorize complex healthcare data (Eligibility, Provider and Claims) and produce accurate output. Required 10 Years
Should have the capability to translate business requirements into technical solutions Required 7 Years
Demonstrated proficiency working with databases – Oracle (11) , DB2 Required 10 Years
Extensive SAS programming knowledge, SQL, Pl/Sql and other SAS tools (Base SAS 9.2, SAS BI Suite, Enterprise guide and Enterprise Miner). Required 7 Years
Strong understanding of healthcare claims processing – Claims, Provider, Eligibility Required 10 Years
Understanding of data modeling techniques and experience working with relational data base concepts and data Required 7 Years
Hands-on experience in different file transfer methodologies and different file types and layouts Required 7 Years
Working knowledge of Medicaid and/or MMIS Required 10 Years
Excellent verbal and written communication skills with the ability present to both technical and business audiences. Highly desired
Mainframe Skills required . Required 7 Years
NC Dept of Health and Human Services (DHHS) is seeking Senior Technology Specialist to perform work related to the development /maintenance of data extracts and create reports for the Transformed Medicaid Statisical Information System as per the Federal mandate. This position is responsible for the design and development of the reporting datasets in SAS and other formats which includes creating and validating input files and formats as per the data mapping artifacts, architecting output datasets and validating data based on the requirements; 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 involves the ability to research and analyze complex healthcare data from variety of sources in order to evaluate, define, design, develop, test and implement technical solutions to produce accurate data extracts/reports in the required file layout based on the Federal requirements. 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.) and other division data sources using various SAS Business Intelligence tools. This position will need to work with Division staff and other stakeholders to understand the requirements and providing technical support/guidance. Knowledge and ability for utilizing secured file transfer protocols/process compliant with the defined Federal standards. Excellent technical, SQL and data analysis skills are required. This position is responsible for coordinating the project status and issues with CMS team and division business SMEs as the lead person.
This position will take on an additional responsibility of managing all changes needed for Managed care Transformation for TMSIS. Also lead the enhancements needed for the NC Data warehouse for Managed Care Transformation.
Candidate will also interact with various stakeholders and team members to discuss alternative solutions by actively contributing suggestions and sharing information and should be team player. Ad hoc participation in various work groups/discussions will be required.