Senior Data Conversion and Interface Analyst (MMIS / Healthcare data) - US Cit to pass clearance

We are seeking to hire a Senior Data Conversion and Interface Analyst with expertise in Medicare / Healthcare systems (MMIS), to join our teams working on a new multi-year awards we have within several State Gov’t clients, modernizing their Medicare/Medicaid systems.  This role is 100% remote.

Being a US Cit is required for working on this program.

This position pays a strong salary package with full benefits (including choice of healthcare plans, dental, vision, life insurance, 3 weeks PTO, 11 Paid Federal Holidays, and a matching 401k).

An option for working on an hourly rate is also available for those not needing a full benefits package.

Experience: 5-10+ Years

Domain: Medicaid MMIS / PBM / Healthcare Modernization

Position Summary

The Senior Conversion & Interface Analyst is responsible for leading data conversion and interface implementation activities across Medicaid MMIS and Pharmacy Benefit Management (PBM) modernization programs. This role serves as a senior technical analyst supporting the end-to-end lifecycle of data migration, interface analysis, source-to-target mapping, data profiling, SQL development, testing, reconciliation, and production readiness.

The candidate will work closely with State stakeholders, Business SMEs, Architects, Conversion Developers, Integration Teams, QA/Test Teams, and Vendor partners to ensure successful delivery of conversion and interface workstreams.

The ideal candidate possesses strong SQL expertise, healthcare data knowledge, interface design experience, and hands-on experience with one of the domains ( claims, member, provider, eligibility, formulary, and financial data domains).

Key Responsibilities

Data Conversion

·        Analyze legacy source systems and target solution data models.

·        Develop and maintain source-to-target mapping documents.

·        Define transformation logic and business rules.

·        Conduct data profiling and data quality assessments.

·        Validate data conversion deliverables through SIT, UAT, Mock Conversion, and Production Cutover.

·        Develop reconciliation methodologies and conversion success criteria.

·        Support defect triage, root cause analysis, and remediation activities.

·        Coordinate conversion activities across conversion, testing, business, and technical teams.

Interface Analysis & Design

·        Analyze inbound and outbound interfaces across MMIS, PBM, MCOs, State systems, and third-party vendors.

·        Develop interface specifications, mapping documents, and transformation requirements.

·        Support file-based, API, XML, JSON, EDI, and batch integration solutions.

·        Analyze NCPDP, X12, T-MSIS, and Medicaid reporting interfaces.

·        Define interface validation and reconciliation processes.

·        Coordinate interface testing activities with trading partners and external vendors.

·        Support production interface cutover planning and post-go-live stabilization.

SQL & Data Analysis

Develop advanced SQL queries for:

·        Data profiling

·        Conversion validation

·        Data reconciliation

·        Interface validation

·        Defect investigations

·        Operational reporting

Perform:

·        Complex joins

·        Window functions

·        Performance tuning

·        Query optimization

·        Referential integrity validation

·        Data quality assessments

·        Create reusable validation frameworks and reconciliation reports.

Testing & Validation

·        Develop test scenarios and validation scripts.

·        Execute conversion and interface validation.

·        Support SIT, UAT, Parallel Testing, Mock Conversion, and Go-Live activities.

·        Manage defect lifecycle and coordinate resolutions.

·        Validate production readiness criteria.

Leadership & Stakeholder Engagement

·        Lead working sessions with business and technical stakeholders.

·        Present findings, risks, and recommendations to project leadership.

·        Mentor junior analysts and developers.

·        Support PMO reporting, RAID management, and executive status updates.

·        Drive issue resolution across multiple vendors and solution teams.

Required Skills

Technical

·        Advanced SQL Server expertise (8+ years preferred)

·        Database design and data modeling

·        ETL and data transformation experience

·        Data profiling and reconciliation

·        Interface analysis and mapping

·        API, XML, JSON, CSV, and flat file processing

·        SSIS, Databricks, PySpark, or similar platforms

·        Excel advanced functions and data analysis

·        Healthcare Domain

Strong understanding of:

·        Medicaid MMIS

·        PBM Operations

·        Pharmacy Claims

·        NCPDP D.0 & F6 transactions

·        Member & Eligibility

·        Provider Data

·        Claims Processing

·        Prior Authorization

·        Formulary Management

·        Encounter Data

·        T-MSIS

·        Financial and Capitation Processes

Documentation

·        Source-to-target mapping

·        Interface specifications

·        Functional specifications

·        Data dictionaries

·        Test plans

·        Reconciliation reports

·        Conversion runbooks

Preferred Qualifications

·        Medicaid DDI implementation experience

·        PBM modernization experience

·        MMIS experience

·        QNXT knowledge

·        Databricks experience

·        Healthcare integration experience

·        Experience with multiple state Medicaid programs

Success Criteria (First 90 Days)

The candidate should be able to independently:

·        Own one or more conversion domains.

·        Own interface inventory and mapping activities.

·        Create complex SQL validation and if needed generate reconciliation scripts.

·        Lead client-facing requirements and mapping sessions.

·        Support SIT/UAT/Mock Conversion cycles.

·        Can serve as deputy lead for conversion and interface workstreams when needed

If qualified and interested, please send an updated resume along with rate/salary requirement and we will follow up quickly to discuss further details and move forward with your interview process.

ec3 Federal Services is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.  ec3 Federal Services is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at ec3 are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. ec3 Federal Services will not tolerate discrimination or harassment based on any of these characteristics.