Job ID: VA-0402)
Hybrid/Local System/Data Analyst (15+) with MMIS/Conduent, Data Conversion/Mapping/Validation/Transformation/QA, ETL Design, Teradata, SQL, Reconciliation, Azure DevOps experience
Location: Richmond, VA (DMAS)
Duration: 14 Months
ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for contractors
Skills:
Exp with Large-Scale Claims Processing Software (MMIS or similar): Mgr will give preference to people who have worked on MMIS or Conduent in past Highly desired 5 Years
Experience in Data Analysis (large datasets, trend identification) Required 10 Years
Knowledge of Programming Logic Required 10 Years
Experience in Data Conversion, Mapping Rules, and Validation Required 10 Years
Experience in ETL Design and Data Transformation Required 10 Years
Experience with Evaluating and Presenting Conversion Results Required 10 Years
Experience with Teradata Queries and SQL Required 10 Years
Ability to Document Data Conversion Rules and Validation Results Required 10 Years
Experience in Data Quality Assurance and Reconciliation Required 10 Years
Experience in Collaborating with ETL Developers and Business Teams Required 10 Years
Experience with Azure DevOps or Similar Test Management Tools Required 5 Years
Excellent organizational and communication skills; ability to meet deadlines with professionalism and customer focus. Required 10 Years
Description:
ABOUT THE ROLE
DMAS Systems Analyst 4
We are seeking a highly skilled Systems Analyst with strong technical and analytical expertise in healthcare claims processing and comprehensive knowledge of data across all functional areas of the Medicaid Management Information System (MMIS) or similar large-scale claims processing systems.
Key Responsibilities
Data Analysis & Conversion
Lead endtoend FAS data conversion strategy, including mapping, transformation logic, and reconciliation.
Direct data validation cycles and resolve complex data anomalies to ensure accuracy and completeness of converted Member, Claims, and Finance data.
Manage mock conversion cycles and coordinate with technical and business teams to ensure readiness for migration.
Oversee data quality assessments and ensure converted data meets business, audit, and regulatory standards.
Develop and document conversion crosswalks and migration procedures for transitioning legacy data into FAS.
Partner with technical architects to optimize conversion performance, minimize downtime, and support a smooth cutover.
Provide governance oversight on system design decisions to ensure alignment with architectural standards and operational readiness requirements.
Perform data analysis related to data conversion from legacy systems to new platforms, including validation of mapping rules, data integrity checks, and reconciliation.
Assist in defining and executing data validation strategies to ensure accuracy and completeness during migration efforts.
Analyze large datasets to identify discrepancies, trends, and anomalies during conversion and testing phases.
Develop SQL/Teradata queries for data validation, reconciliation, and reporting.
Document data conversion rules, transformation logic, and validation results to support audit and compliance requirements.
Work closely with ETL developers and business teams to ensure data quality and consistency across systems.
Testing & Quality Assurance
Develop and execute the overall Test Strategy, including System Integration Testing (SIT), User Acceptance Testing (UAT), and EndtoEnd (E2E) testing for MMIS and MES modules.
Test Commercial OfftheShelf (COTS) applications and support data conversion and integration across MES modules and COTS products.
Create and support the development of Business Test Scenarios, Test Cases, and Test Data; assist with test execution activities.
Support ongoing releases, system enhancements, and production defect resolution.
Manage defect triage calls with multiple vendors and ensure accurate tracking and timely closure of defects.
Communicate UAT status, progress metrics, and results to stakeholders; maintain comprehensive historical testing documentation.
Collaborate effectively with technical teams, business users, and crossfunctional groups with minimal supervision.
Required Skills and Experience
Proven Agile Testing experience, with the ability to plan and execute functional, integration, and regression testing within iterative sprint cycles.
Data Analysis: Strong experience in data conversion, mapping rules, validation, ETL design, and programming logic.
*HIGHLY DESIRED: Mgr will give preference to people who have worked on MMIS or for Conduent (Company) in the past. Healthcare Claims Expertise: Indepth knowledge of MMIS or similar largescale claims processing systems.
Technical Skills
Proficiency in Teradata, including query development.
Experience with Mainframe and DB2 testing preferred.
Test Management Tools: Extensive experience with Azure DevOps or similar platforms for planning, tracking, and executing test activities.
Defect Management: Strong experience leading UAT and defect triage across multiple systems/vendors.
ProblemSolving: Strong debugging ability and experience acting as a liaison between developers and business users.
Excellent organizational and communication skills, with the ability to meet deadlines professionally and with strong customer focus.