Data Engineer

IntePros is seeking a high-impact Data Engineer with expertise in eligibility and membership data to join their modern Data Engineering organization. This role will lead the design and delivery of scalable data solutions within a Microsoft Fabric environment, focusing on eligibility ingestion, validation, transformation, and integrations.

Responsibilities:

• Architect, build, and maintain robust pipelines for eligibility and membership data within Microsoft Fabric
• Ensure accurate, timely, and compliant data delivery for downstream integrations and analytics use cases
• Investigate and resolve data issues through root cause analysis across ingestion, transformation, and integration layers
• Design and implement scalable solutions using Fabric Lakehouse and Warehouse architectures
• Develop end-to-end ETL/ELT pipelines leveraging Data Pipelines, Dataflows Gen2, SQL, and Python
• Utilize Notebooks (Python/PySpark) for advanced transformations, validation, and exploratory analysis
• Build and maintain conformed data models (fact/dimension tables) to support operational and analytical reporting
• Continuously improve performance, reliability, and observability across the data platform
• Implement proactive data validation and quality frameworks to ensure integrity of eligibility data
• Maintain strict adherence to HIPAA-aligned data handling and security standards
• Establish governed, secure data access across teams and environments
• Produce clear documentation of business rules, mappings, and transformations to support auditability and transparency
• Partner with Product, Integration, Operations, and Analytics teams to support critical business workflows
• Enable self-service analytics through well-structured Power BI semantic models
• Collaborate with engineering peers to standardize best practices and elevate platform maturity

Requirements:

• 5+ years of experience in Data Engineering or a related field
• Advanced proficiency in SQL (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 data platforms
• Strong understanding of data integration patterns, ingestion frameworks, and system dependencies
• Demonstrated ability to analyze, troubleshoot, and resolve complex data issues across pipelines
• Fabric Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, OneLake
• Azure SQL / SQL Server, Azure Synapse, Azure Data Factory (or equivalent tools)
• Power BI (semantic modeling, DAX, data modeling best practices)
• Eligibility and membership data structures
• Contract/PBP configuration
• Carve-outs, exclusions, and regulatory considerations
• Experience with CI/CD pipelines, version control, and environment promotion strategies for data workflows