System/Data Analysis & Conversion (Hybrid)

ADP, Inc.; Richmond (VA); Hybrid; USD 83,000 - 96,000; Full time

Job summary

ADP, Inc. in Richmond, VA seeks a System/Data Analyst to drive data conversion for MMIS-like systems. You will validate data, design ETL processes, and write SQL/Teradata queries to ensure accuracy and regulatory compliance within a complex healthcare claims environment.

The role is hybrid: three days onsite and two days remote, requiring coordination with IT and business teams, development of conversion crosswalks, and governance of data quality during migration and validation efforts.

Qualifications

• Experience in Agile testing within iterative sprint cycles.
• Strong data conversion, mapping rules, validation, ETL design and programming logic.
• Preference for MMIS experience or prior work with Conduent.

Responsibilities

• Direct data validation cycles and resolve data anomalies for converted data.
• Manage mock conversion cycles and coordinate with teams for migration readiness.
• Oversee data quality and ensure regulatory standards.
• Develop conversion crosswalks and migration procedures.
• Partner with architects to optimize performance and cutover readiness.
• Governance of system design decisions for architectural alignment.
• Analyze data conversion from legacy to new platforms with mapping validation.
• Define data validation strategies and validate large datasets during migration.
• Develop SQL/Teradata queries for validation and reporting.
• Document conversion rules, logic, and validation results.
• Collaborate with ETL developers and business teams for data quality.

Skills

Agile testing

Data conversion

ETL design

Programming logic

Healthcare claims expertise

Tools

Azure DevOps

Mainframe testing

DB2 testing

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

System/Data Analysis & Conversion (Hybrid)

3 days ago Requisition ID: 1114

Salary Range: $60.00 To $70.00 Hourly

ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for contractors

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

• 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 End-to-End (E2E) testing for MMIS and MES modules.
• Test Commercial Off-the-Shelf (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 cross-functional 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: In-depth knowledge of MMIS or similar large-scale claims processing systems.

Technical Skills

• 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.
• Problem-Solving: 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.