Business Data Analyst - Mapping (Fully Remote - No C2C)

Role: Business Data Analyst - Mapping

Duration: 16 weeks (possibility of extension)

Location: USA (Fully Remote)

Domain: Healthcare Medicaid/T-MSIS business rules

Role Summary

Senior analysis role focused on source-to-target mapping, Medicaid/T-MSIS business rules, data profiling, and translating regulatory requirements into clear implementation specifications.

Roles & Responsibilities

• Create and maintain detailed source-to-target mappings for complex healthcare data transformations.
• Analyze source-system structures and identify the correct source fields for regulatory reporting requirements.
• Document transformation rules, filters, exclusions, defaults, derivations, crosswalks, and valid-value logic.
• Perform data profiling and gap analysis to identify missing, inconsistent, or undocumented mapping logic.
• Analyze legacy ETL logic, SQL, or existing processing documentation when requirements are incomplete.
• Maintain mapping traceability across source fields, business rules, target elements, and validation requirements.
• Work with business SMEs, data architects, engineers, and QA to clarify requirements and resolve mapping gaps.
• Support defect analysis and reconciliation by tracing data differences back to source or mapping logic.
• Prepare clear mapping and rule documentation for technical implementation and validation.

Required Skills & Experience

• 6+ years of business data analysis, data mapping, or data-integration experience.
• Strong experience creating and managing complex source-to-target mapping documents.
• Strong SQL and source-data profiling skills.
• Experience documenting derivations, crosswalks, filters, exclusions, defaults, reference data, and transformation logic.
• Ability to understand relational data models, ETL flows, and batch-processing logic.
• Experience analyzing existing SQL, ETL jobs, or legacy code when documentation is incomplete.
• Strong requirements-analysis, gap-analysis, traceability, and documentation skills.
• Excellent communication and facilitation skills for working with business SMEs and technical teams.
• Familiarity with Databricks / lakehouse concepts is preferred.

Domain Knowledge

• Strong Medicaid / MMIS domain experience is preferred.
• T-MSIS experience is highly desirable.
• Knowledge of claims, encounters, eligibility, provider, managed care, TPL, pharmacy, and financial transaction data.
• Experience interpreting CMS specifications, T-MSIS data elements, crosswalks, valid values, and state-specific rules.
• Healthcare payer / regulatory reporting experience.