Data Migration Architect

JOB TITLE: Data Migration Architect JOB SUMMARY: We are seeking an experienced Data Migration Architect to lead enterprise-scale migration initiatives focused on migrating data assets, analytics platforms, and reporting ecosystems across Azure subscriptions and cloud environments within the Oil & Gas industry. This role will drive migration strategy, architecture, governance, and execution for complex data ecosystems involving upstream, midstream, downstream, trading, and corporate data domains. Key Responsibilities: Migration Strategy & Architecture: Architect and lead migration strategies for moving data assets across Azure subscriptions, tenants, and cloud environments. Define migration frameworks, reusable accelerators, and reference architectures. Assess current-state ecosystems and design scalable target-state architectures. Develop migration waves, dependency mapping, and cutover strategies. Azure Data Platform Architecture: Design and implement migration architectures involving Azure Databricks, Azure Data Factory (ADF), Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure SQL platforms, Power BI semantic models (Tabular Models), Azure Key Vault, Azure Purview, event-driven architectures, and streaming platforms. Migrate Databricks notebooks, clusters, workflows, libraries, and Unity Catalog assets. Migrate and optimize ADF pipelines, linked services, triggers, datasets, and integration runtimes. Lead migration and modernization of Power BI semantic models and enterprise tabular models. Ensure lineage preservation across reporting, semantic, and consumption layers. Design scalable medallion architecture patterns (Bronze, Silver, Gold layers). Define metadata-driven migration approaches. Data Modeling & Analytics: Lead migration of enterprise data warehouses, data marts, and analytical platforms. Design and migrate dimensional models, semantic layers, and tabular models. Ensure reporting continuity across downstream consumers. Support modernization from legacy ETL to cloud-native ELT architectures. Oil & Gas Domain Responsibilities: Translate business processes into migration architecture patterns. Support migration of operational and analytical datasets used across Oil & Gas value chains. Partner with business SMEs to preserve critical business logic and calculations. Governance & Security: Implement secure migration patterns across subscriptions. Design RBAC models and managed identity strategies. Maintain metadata, lineage, governance, and audit requirements. Ensure compliance with enterprise security standards. Delivery Leadership: Lead architecture workshops and migration planning sessions. Drive execution across multiple migration pods and engineering teams. Manage risks, dependencies, reconciliation, and post-migration stabilization. Provide executive updates and technical leadership. Required Qualifications: 10 years in data architecture, cloud engineering, or migration programs. 5 years designing enterprise Azure data platforms. Experience leading subscription-to-subscription migrations. Strong experience in enterprise analytics modernization. Strong Oil & Gas industry experience. Required Technical Skills: Azure Platform: Azure Databricks, Azure Data Factory (ADF), Azure Synapse, Azure Data Lake Storage Gen2, Azure SQL, Azure Purview, Azure Key Vault, Azure Monitor. Data Analytics: Power BI Semantic Models, SSAS Tabular Models, Dimensional Modeling, Data Warehousing, Data Governance, Metadata Management. Engineering & Automation: Azure DevOps, CI/CD Pipelines, Git, Python, PySpark, SQL, PowerShell. Architecture Patterns: Medallion Architecture, Lakehouse Architecture, Data Mesh Concepts, Data Migration Frameworks, Enterprise Integration Patterns. Preferred Qualifications: Experience in large Oil & Gas transformation programs. Experience supporting mergers, acquisitions, or enterprise integrations. Experience with enterprise reporting modernization. Experience leading global delivery teams. Certifications: Azure Certifications are preferred. Education: Masters Degree