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