Base SAS 9.4, SAS Macro, SAS BI Suite, Data Integration studio, Oracle, DB2
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 the design and development of the 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 a variety of sources in order to evaluate, define, design, develop, test and implement technical solutions to produce accurate data extracts 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 the data warehouse, Medicaid claims processing system (MMIS - Claims, Eligibility, provider, etc, Encounter Processing system(PHP-Encounters), PBM (RX Claims) 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 are for utilizing secured file transfer protocols/processes compliant with the defined Federal standards.
This position will also be a part of the team to develop Dashboards using Tableau.