Lead Data Engineer

We are building the world’s first Clinical Supply Control Tower -a data powered SaaS platform that unifies operational intelligence, analytics, and AI to ensure therapies reach patients without interruption. We are a high-velocity, mission-driven organization where engineering excellence meets healthcare innovation.

AXIOM is our flagship Clinical Supply Chain Command Center - a SaaS platform that provides pharmaceutical organizations with end-to-end visibility, intelligence, and control across their clinical trial supply networks. AXIOM integrates data from planning, manufacturing, logistics, and RTSM systems into a unified platform, enabling real-time visibility into supply networks, early risk detection, and predictive analytics.

Boston Insights is seeking a Lead Data Engineer specializing in Microsoft Fabric to join our dynamic team.

This is hands-on technical leadership role where you will architect scalable data pipelines, build Lakehouse and Warehouse structures, and drive data quality and governance across our multi-tenant SaaS platform. You will work closely with the product and architecture teams to deliver analytics-ready data that powers real-time clinical supply chain intelligence for global pharmaceutical companies.

• Design and build end-to-end data ingestion and transformation pipelines using Microsoft Fabric Data Factory, Dataflows Gen2, Spark, and PySpark notebooks

• Architect and maintain Lakehouse and Warehouse structures within Microsoft Fabric, implementing

medallion architecture (Bronze, Silver, Gold layers)

• Manage OneLake file structures, Delta tables, partitioning strategies, and storage governance for a multi-

tenant SaaS environment

• Develop incremental loading frameworks, data quality validation, and error handling mechanisms

• Optimize query performance, schema design, and data models to support Power BI semantic models and real-time analytics

• Implement CI/CD pipelines for data engineering artifacts using Azure DevOps and Git integration

• Collaborate with Power BI developers, Power Apps developers, and data analysts to ensure seamless data

delivery for reporting and application layers

• Support multi-tenant workspace isolation (workspace-per-customer model on shared Fabric capacity)

and enforce tenant-level data security

• Build and maintain integrations with external systems including ERP, MES, WMS, CTMS, RTSM/IRT, and

3PL platforms

• Produce and maintain comprehensive technical documentation covering data models, pipeline logic,

workspace structure, and governance policies

• Mentor junior data engineers, establish coding standards, and conduct code reviews

• Stay current with Microsoft Fabric updates, new features, and best practices to continuously improve the

platform

• Bachelor's or Master's degree in Computer Science, Data Engineering, Information Technology, or a

related field

• 4–5+ years of hands-on experience in data engineering, with at least 1–2 years working with Microsoft

Fabric

• Strong proficiency in SQL, PySpark, Python, and Delta Lake

• Deep experience with Microsoft Fabric components: Lakehouse, Warehouse, Data Factory, Dataflows

Gen2, Notebooks, and OneLake

• Solid understanding of ETL/ELT patterns, data modeling (star schema, snowflake schema), and data

warehousing concepts

• Experience with Azure services: Azure Data Lake, Azure Key Vault, Azure DevOps, Microsoft Entra ID

• Proficiency in Power BI integration — semantic models, datasets, and DirectLake mode

• Experience with CI/CD workflows for data engineering (Git integration, deployment pipelines)

• Strong understanding of data governance, security, and compliance in multi-tenant environments

• Excellent written and verbal communication skills; ability to produce clear technical documentation

• Microsoft Certified: Fabric Data Engineer Associate (DP-700) certification

• Experience in pharmaceutical, life sciences, or healthcare supply chain domains

• Familiarity with clinical trial data systems (CTMS, RTSM/IRT, CDISC standards)

• Experience with Power Apps, Power Automate, or Power Pages development

• Exposure to AI/ML integration within Microsoft Fabric (Synapse Data Science, notebooks)

• Experience architecting multi-tenant SaaS data platforms

• Knowledge of Kusto Query Language (KQL) and Real-Time Analytics in Fabric

• Remote-first work culture with flexibility
• Opportunity to build a category-defining product in clinical supply chain from the grounds up
• Work with cutting-edge Microsoft Fabric and Azure technologies
• Collaborative, startup-paced environment with significant ownership and growth potential
• Competitive compensation and benefits