Haystack
← Back to Jobs
Technology
CS

Integration Azure Data Architect - MS Fabric | Veeva | MDM | ADF | Data Bricks | Life Sciences

Compest Solutions IncWilmington, DE🇺🇸United StatesPosted Sep 25, 2026

Why This Role Stands Out

This role offers a significant opportunity to shape data architecture within the life sciences sector, leveraging cutting-edge Microsoft Fabric and Azure technologies to drive innovation. You'll thrive here if you have extensive experience in complex data platforms, a passion for enterprise data modeling, and a desire to lead impactful projects within a reputable company. Apply now to make your mark on critical clinical R&D initiatives.

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
Wilmington, DE, United States
Posted
18 hours ago
SQLEncryptionSnowflakeAzureDatabricksGDPRHIPAAPythonStakeholder ManagementTerraformUnityVault

Job Description

Job title: Integration Architect (MS Fabric Azure Data Architect)
Client: Pharma / Life Sciences Clinical R&D
Location: Onsite / Hybrid in Wilmington, Delaware
Position Type- Contract

Role Summary

This is a senior, client-facing onshore role requiring deep technical expertise, strong leadership presence, and the ability to independently drive architecture decisions across large, complex programs while managing distributed (onshore/offshore) engineering teams. Preferable to have working experience on Life Sciences Clinical R&D specifically Veeva CTMS implementation and Integrations.

  • Architect complex, high-volume data platforms spanning batch, real-time, and streaming pipelines using Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Event Hubs/Stream Analytics, and Data Lake Storage Gen2.
  • Lead enterprise data modeling efforts (conceptual, logical, physical) across multiple domains supporting analytics, BI, and AI/ML use cases.
  • Define and enforce data governance, lineage, cataloging, and quality frameworks (Azure Purview or equivalent).
  • Own the security and compliance architecture encryption, RBAC, Private Endpoints, Key Vault, data masking, and regulatory alignment (GDPR, HIPAA, GxP).

Required Skills & Experience

  • 10+ years in data engineering/architecture, with hands-on experience in Azure data services at an architect level.
  • Deep, demonstrable expertise across:

Azure Data Factory / Synapse Pipelines

Azure Synapse Analytics (dedicated & serverless SQL pools)

Azure Databricks (PySpark, Delta Lake, Unity Catalog)

Azure Data Lake Storage Gen2

Azure SQL Database / Managed Instance / Cosmos DB

Microsoft Fabric (working knowledge strongly preferred)

  • Good to have at least one implementation of a Life Sciences Clinical R&D project, either EDC, CTMS or eTMF implementation. Veeva CTMS implementation and Integrations to Veeva is preferred.
  • Proven experience architecting Lakehouse, Medallion architecture, and modern data mesh patterns.
  • Strong command of data modeling (3NF, Star/Snowflake, Data Vault 2.0).
  • Advanced proficiency in SQL, Python/PySpark, and Spark performance tuning.
  • Deep knowledge of Azure security & networking (Managed Identity, Private Link, VNet integration, Azure Firewall).
  • Hands-on experience with Infrastructure as Code (Terraform or Bicep) and Azure DevOps CI/CD.
  • Strong background in MDM, data governance, and metadata management tools (Purview, Collibra, or similar).
  • Track record of leading large-scale migrations (Teradata/Netezza/On-prem SQL Azure).
  • Excellent stakeholder management able to independently lead C-level/VP-level architecture conversations.

Similar jobs