Senior Business Data / Mapping Analyst (Healthcare)- Remote - 6 months Contract

Palni IncUnited States🇺🇸United StatesPosted Oct 16, 2026

Quick Overview

Seniority

Mid Senior

Work mode

Remote

Location

United States

Posted

3 days ago

SQLETLDatabricksPharmacyReconciliationRegulatory Reporting

Job Description

Senior Business Data / Mapping Analyst

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.

Duration: 3+ Months Intially

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.