Senior Business Data / Mapping Analyst
Job Description
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.
