SystemData Analysis & Conversion
Richmond, VA - USA
Job Summary
Job Title: System/Data Analysis & Conversion
Location: Richmond VA 23219 (Hybrid - 3 days onsite and 2 days remote)
Duration: 12 months contract
About the Role: 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.
Healthcare Claims Expertise: In-depth knowledge of MMIS or similar large-scale claims processing systems. Preference will be given to candidates who have worked for a company called Conduent in the past. Candidates must clearly reflect this experience on their resume to be considered.
Key Responsibilities:
Data Analysis & Conversion
- Lead end to end 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 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:
- Manager will give preference to people who have worked on MMIS or for Conduent (Company) in the past.
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.
- 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.
Experience Requirements
| Skill/Experience | Requirement | Years |
| Exp with Large-Scale Claims Processing Software (MMIS or similar). Preference for MMIS or Conduent experience | Highly desired | 5 |
| Experience in Data Analysis (large datasets trend identification) | Required | 10 |
| Knowledge of Programming Logic | Required | 10 |
| Experience in Data Conversion Mapping Rules and Validation | Required | 10 |
| Experience in ETL Design and Data Transformation | Required | 10 |
| Experience with Evaluating and Presenting Conversion Results | Required | 10 |
| Experience with Teradata Queries and SQL | Required | 10 |
| Ability to Document Data Conversion Rules and Validation Results | Required | 10 |
| Experience in Data Quality Assurance and Reconciliation | Required | 10 |
| Experience in Collaborating with ETL Developers and Business Teams | Required | 10 |
| Experience with Azure DevOps or Similar Test Management Tools | Required | 5 |
| Excellent organizational and communication skills; ability to meet deadlines with professionalism and customer focus | Required | 10 |