Data Architect

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 OpenKyber 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, OpenKyber or eTMF implementation. OpenKyber CTMS implementation and Integrations to OpenKyber 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. For applications and inquiries, contact:hirings@openkyber.com