Data Migration Architect Azure Data Platform

Role description

Data Migration Architect Azure Data Platform

Houston TX Onsite


Job Summary

We are seeking an experienced Data Migration Architect to lead enterprisescale 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 The ideal candidate brings strong expertise in Azure cloud technologies largescale data migrations analytics modernization and enterprise data architecture

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 currentstate ecosystems and design scalable targetstate architectures

Develop migration waves dependency mapping and cutover strategies

Azure Data Platform Architecture

Design and implement migration architectures involving

Azure Databricks for largescale data processing and modernization

Azure Data Factory ADF for orchestration and pipeline migration

Azure Data Lake Storage Gen2

Azure Synapse Analytics

Azure SQL platforms

Power BI semantic models Tabular Models

Azure Key Vault

Azure Purview

Eventdriven architectures and streaming platforms

Responsibilities include

Migrate Databricks notebooks clusters workflows libraries and Unity Catalog assets across subscriptions

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 metadatadriven 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 cloudnative ELT architectures

Oil Gas Domain Responsibilities

Strong understanding of Oil Gas business processes and datasets including

Upstream production and well data

Reservoir and subsurface datasets

Drilling and completions data

Midstream transportation and logistics

Refining and downstream operations

Trading and commodity analytics

Asset reliability and maintenance datasets

Enterprise finance supply chain and operational data domains

Expected 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 Compliance

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 postmigration 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 subscriptiontosubscription 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

CICD 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

Azure Certifications preferred

Experience leading global delivery teams

Success Metrics

Successful migration of enterprise data assets with minimal downtime

Successful migration of Dat