The candidate is expected to be able to develop program specifications and mapping documents. Perform analysis on data to understand transformation requirements, work with ETL/Reporting/Conversion staff to ensure code has been developed that meet the business requirements documented, test the interface/report to ensure requirements are met and work with other team member members.

• Duties and Responsibilities (List all essential duties and responsibilities in order of importance)
o Creates accurate mapping documents according to the mapping process.
o Works toward delivering a first draft solution to ETL/Reporting/Conversion for coding, by rapidly understanding which details about the mapping can be deferred.
o Supports DSD creation and response.
o Presents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design.
o Supports the ETL/Reporting/Conversion developers based on the mappings created.
o Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.
o Refines mapping documents, adding more detail and filling out deferred material as questions are resolved.
o Uses SQL, data models, data element dictionary and schema to perform data and business analysis.
o Creates unit test cases for area of responsibility.
o Validates test plan results that satisfy the detailed design goals.
o Updates technical specifications and mappings.
o Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.

• Knowledge, Skills and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)
o Analytical and data analysis skills within a technical environment preferably SQL
o Healthcare knowledge within a claims processing environment preferably in Medicaid
o Excellent verbal and written communication skills
o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers