Data Engineer

Data Engineer — Eligibility & Integrations (Microsoft Fabric)

Role overview

You will design and deliver scalable, high-quality eligibility and membership data solutions in a Microsoft Fabric environment. This highly visible role sits at the intersection of data engineering, healthcare domain expertise, and analytics enablement, supporting ingestion, validation, transformation, and downstream integrations.

Responsibilities

• Eligibility data engineering: architect, build, and maintain robust pipelines for eligibility and membership data in Microsoft Fabric.
• Ensure accurate, timely, and compliant data delivery for integrations and analytics.
• Perform root-cause analysis to investigate and resolve data issues across ingestion, transformation, and integration layers.
• Modern data platform (Fabric): design and implement scalable solutions using Fabric Lakehouse/Warehouse architectures.
• Build end-to-end ETL/ELT pipelines using:
  • Data Pipelines
  • Dataflows Gen2
  • SQL
  • Python
• Use Notebooks (Python/PySpark) for advanced transformations, validation, and exploratory analysis.
• Build and maintain conformed data models (fact/dimension tables) for operational and analytical reporting.
• Improve performance, reliability, and observability across the data platform.
• Data quality & governance: implement proactive validation and quality frameworks for eligibility data integrity.
• Adhere to HIPAA-aligned handling and security standards.
• Maintain governed, secure data access across teams and environments.
• Produce documentation of business rules, mappings, and transformations for auditability.
• Collaboration: partner with Product, Integration, Operations, and Analytics teams.
• Enable self-service analytics via Power BI semantic models.
• Standardize best practices with engineering peers to raise platform maturity.

Requirements

• 5+ years of experience in Data Engineering (or related).
• Advanced SQL skills (complex transformations, optimization, performance tuning).
• Proven experience building pipelines and data models for healthcare eligibility or membership data.
• Hands-on experience with Microsoft Fabric (or closely related Azure-based platforms).
• Understanding of data integration patterns, ingestion frameworks, and system dependencies.
• Ability to analyze, troubleshoot, and resolve complex pipeline/data issues.

Preferred experience

• Microsoft Fabric & Azure ecosystem, including:
  • Fabric Lakehouse/Warehouse
  • Data Pipelines
  • Dataflows Gen2
  • OneLake
  • Azure SQL / SQL Server
  • Azure Synapse
  • Azure Data Factory (or equivalents)
• Analytics & visualization:
  • Power BI (semantic modeling, DAX, data modeling best practices)
• Engineering best practices:
  • CI/CD, version control, and environment promotion for data workflows
• Healthcare domain knowledge of eligibility structures such as contract/PBP, carve-outs, and exclusion logic.