Quantum Pain & Sports Medicine is building a centralized data and analytics platform in Microsoft Fabric, with a focus on dependable healthcare and business integrations. This Senior Data Engineering role is centered on infrastructure and ingestion pipelines in Fabric, so trusted, analytics-ready datasets can power reporting, operational analytics, automation, and future AI use cases.
You will help design the foundation early, implement the ingestion and data layers that make data reliable, and operate the platform so additional systems and new analytics needs can be added without rebuilding everything.
What you will do
- Design and implement the Microsoft Fabric data architecture using OneLake, Lakehouse/Warehouse, Data Factory pipelines, notebooks, and related Fabric services.
- Build and maintain ingestion pipelines from eClinicalWorks, HubSpot, APIs, databases, files, and future enterprise systems.
- Integrate healthcare and operational systems using REST APIs, FHIR APIs, webhooks, batch exports, and other extraction approaches.
- Implement a medallion-style structure with raw, validated, and analytics-ready layers.
- Clean, standardize, deduplicate, and reconcile data across systems, including building patient, referral, appointment, provider, procedure, case, outcome, and other operational data models.
- Create matching methods for records when identifiers are inconsistent or unavailable.
- Deliver reusable curated datasets that support Power BI reporting, operational analytics, automation, and future AI applications.
- Implement incremental loading, change detection, schema management, error handling, logging, alerting, and pipeline monitoring.
- Set up data quality checks to identify incomplete, inconsistent, or unexpected source data.
- Apply healthcare-appropriate security, access controls, and governance practices.
- Use Git and CI/CD so pipelines and transformations remain version-controlled, documented, and maintainable.
- Monitor Fabric usage, performance, capacity, and cost as the platform grows.
- Document architecture, data definitions, pipelines, dependencies, and operating procedures.
- Maintain and improve the platform after initial implementation, rather than treating it as a one-time migration.
- Assess existing systems, data sources, reporting requirements, and the Microsoft environment, then design and configure the initial Fabric architecture.
Required qualifications
- 4+ years of professional experience in data engineering, data platform, or data integration.
- Hands-on experience building production solutions with Microsoft Fabric or a closely related Azure data stack.
- Strong SQL skills.
- Strong Python and/or PySpark skills.
- Experience designing ETL/ELT pipelines and data ingestion frameworks.
- Experience with Microsoft Fabric Lakehouse, OneLake, Data Factory/Pipelines, notebooks, Delta tables, or equivalent technologies.
- Experience integrating third-party systems via REST APIs.
- Experience implementing incremental data loads rather than relying only on full refreshes.
- Strong understanding of dimensional modeling, relational modeling, lakehouse architecture, and analytics-oriented data modeling.
- Experience troubleshooting API authentication, pagination, rate limits, schema changes, malformed records, pipeline failures, and other real-world integration issues.
- Experience with Git, source control, and CI/CD practices.
- Experience implementing monitoring, logging, data-quality validation, and alerting for production pipelines.