Integration Architect (MS Fabric Azure Data Architect

Compest Solutions Inc
Wilmington, DE, United States
17 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Unity 3d Third Normal Form Artificial Intelligence Microsoft Azure Clinical Trial Management Systems Continuous Integration Information Engineering Data Governance Data Masking Data Vault Modeling DevOps Python (Programming Language)
+31 more
Network Security Meta-Data Management SQL Azure Performance Tuning Role-Based Access Control Azure DevOps Pipelines Azure Data Lake SQL Databases Systems Integration Teradata SQL Azure Service Bus Azure Data Factory Netezza Snowflake Apache Spark Firewalls (Computer Science) Microsoft Fabric Data Lakes Pyspark Collibra Bicep Cosmos DB Data Management Veeva Terraform Azure Synapse Analytics Stream Analytics Serverless Computing GXP Key Vault Databricks

Job description

  • Own and drive the enterprise data architecture roadmap across Azure, aligning with business strategy and long-term scalability goals.
  • 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).
  • Serve as the primary technical authority in client architecture reviews, steering committees, and executive presentations.
  • Lead and mentor a team of data architects and senior data engineers, both onshore and offshore.
  • Drive modernization/migration initiatives legacy on-prem warehouses to Azure, or multi-cloud to Azure consolidation.
  • Establish and govern CI/CD, IaC (Terraform/Bicep), and DevOps practices for data platform delivery.
  • Own cost optimization and FinOps practices across Azure data services.
  • Conduct architecture governance reviews, risk assessments, and design authority sign-offs (HLD/LLD).
  • Partner with enterprise architects, security teams, and business leadership to ensure alignment with overall IT strategy.
  • Evaluate and pilot emerging Azure data/AI capabilities (e.g., Microsoft Fabric, AI Foundry integration) and recommend adoption.

Requirements

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., * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…