Senior Cloud Data Architect — Azure & Fabric (Hybrid)

HealthDrive Corporation; Framingham (MA); Hybrid; USD 100,000 - 150,000; Full time

Job summary

HealthDrive Corporation in Framingham, MA seeks a Senior Cloud Data Engineer to operate, enhance, and extend its cloud data platform on Microsoft Azure and Fabric. You will architect data solutions, design end-to-end pipelines for clinical, operational, and financial data, and drive data governance and semantic modeling.

You will collaborate with the CIO, data warehouse owner, business analysis, and operations to translate business problems into durable data assets and trusted analytics

Qualifications

• 5+ years of hands-on data engineering experience.
• 3+ years on the Microsoft Azure data platform — Azure Data Factory, Synapse, and ADLS Gen2.
• Strong Python and PySpark, and strong SQL.
• Healthcare data engineering across claims, encounters, clinical, operational, and financial data.
• Experience sourcing data from on-premises SQL Server environments.
• Working knowledge of lakehouse and medallion architecture.
• Demonstrated ability to design and architect data solutions independently.
• Ability to explain data models and metric definitions clearly to non-technical partners.

Responsibilities

• Solution design and architecture: Design and architect data solutions end-to-end— taking business problems from operations, finance, and clinical leadership, defining the technical approach, and then building it.
• Data ingestion: Build and operate pipelines that bring clinical, operational, and financial data from source systems into OneLake, using Fabric Data Factory, Azure Data Factory, and Spark notebooks.
• Source system integration: Source data reliably from HealthDrive’s on-premises SQL Server data warehouse and other operational systems, including incremental and change-data-capture patterns.
• Data transformation: Maintain and extend the standardized clinical, operations, and finance data model across the medallion architecture, and develop new data models as the business requires.
• Data quality and reconciliation: Build the validation, reconciliation, and exception handling that healthcare data requires to be trusted for clinical, operational, and financial reporting.
• Certified semantic models: Develop and maintain gold-layer, certified semantic models in Microsoft Fabric that the business analysis and reporting functions build from.
• Business metric definitions: Establish and maintain canonical definitions for HealthDrive’s core business metrics so the organization works from a single source of truth.
• Data governance and PHI: Apply access controls, classification, and lineage — including Microsoft Purview — to protect PHI and meet HIPAA obligations.
• Partnership: Partner with the CIO, the Software Development Manager, the business analysis function, and the operations and finance teams to translate business questions into durable data assets.

Skills

Data engineering

Python

PySpark

SQL

Healthcare data domain

Cloud data modelling

Communication

Problem solving

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Azure Data Factory

Azure Synapse

ADLS Gen2

dbt

Power BI

Microsoft Purview

Job description

HealthDrive Corporation in Framingham, MA seeks a Senior Cloud Data Engineer to operate, enhance, and extend its cloud data platform on Microsoft Azure and Fabric. You will architect data solutions, design end-to-end pipelines for clinical, operational, and financial data, and drive data governance and semantic modeling.

You will collaborate with the CIO, data warehouse owner, business analysis, and operations to translate business problems into durable data assets and trusted analytics