Azure Data Architect

Role: Azure Data Migration Architect / Lead Client: Pharma/Life science Location: Bay Area (San Jose or Sunnyvale or Pleasanton etc) Contract: Long Term Working Model: Hybrid Contract: C2C/W2 Visa: H1B, GC, USC, H4EAD Skills & Technical Requirements: Required = must be demonstrated from Day 1. Preferred = advantageous for this engagement. Skill / Technology Level Skill / Technology Level Azure Synapse Analytics Required Parallel environment validation Required Azure Data Factory (ADF) Required Pipeline documentation & handover Required Azure Data Lake Gen 2 Required MDM (Master Data Management) Preferred T-SQL / Serverless SQL Pools Required GxP / regulated data environments Preferred SFTP endpoint management & migration Required Pharma commercial data ecosystems Preferred HIPAA / PHI data handling Required Specialty pharmacy / claims data feeds Preferred Azure RBAC & identity management Required Power Query / Excel automation Preferred Power BI (datasets, gateways, RLS) Required GxP-compliant SharePoint Preferred Python scripting for data pipelines Required Azure DevOps / CI/CD pipelines Preferred Spark Pools / Data Lakehouse patterns Required Veeva / Salesforce CRM data Preferred Experience & Background Essential: • 8+ years in data engineering or data architecture, with a minimum of 4 years delivering on Azure (Synapse, ADF, Data Lake Gen 2) • Proven experience leading production data platform migrations — not greenfield builds — from a source environment to a new Azure tenant under delivery timelines • Hands-on experience managing SFTP-based data ingestion from multiple concurrent external vendors • Demonstrated experience handling PHI data in HIPAA-regulated environments, including technical documentation for compliance and BAA processes • Ability to inherit, reverse-engineer, and document pipelines from third-party managed service providers with varying documentation quality • Experience running parallel environment validation — comparing source and target outputs at scale — prior to production cutover • Comfortable operating as the primary technical owner on a time-pressured delivery program with direct stakeholder accountability Preferred: • Background in pharmaceutical or life sciences commercial data — specialty pharmacy, patient support programs, claims, payer intelligence, or distribution data • Experience migrating Power BI environments across tenants, including RLS re-implementation and dataset re-mapping • Consulting or professional services background — proven ability to document as you go and produce clean handover deliverables • GxP validated data environment or regulated SharePoint experience • Familiarity with Azure Synapse managed services and third-party data aggregation platforms in pharma