Senior Data Engineer – Azure ETL & BI (Remote)

Wpp; Mexico; Hybrid; PHP 3,743,000 - 6,238,000; Full time

Job summary

WPP Media is hiring a Senior Data Engineer for the Global Operations Centre (GOC). You will design, build, and optimize enterprise ETL/ELT pipelines using Azure Data Factory, Data Lake Storage, and serverless tech, ensuring scalability, security, and reliability.

You will own production pipeline reliability, perform root-cause analysis, and mentor engineers while advancing CI/CD practices and governance across data assets.

Qualifications

• 3–4 years of progressive experience in data engineering.
• Expert-level hands-on experience with Azure Data Factory, Azure T-SQL, and cloud data platforms such as Azure and/or GCP.
• Proven experience designing, optimizing, and managing large-scale, production-grade ETL/ELT pipelines, including ADF orchestration.
• Advanced SQL performance tuning skills, including query optimization, partitioning, indexing, and high-volume data processing.
• Strong Python and API orchestration skills for automation.
• Advanced production operations, troubleshooting, root-cause analysis, high-availability processing, monitoring, SLA management, and CI/CD automation.
• Experience with Adverity, Dataflow, BigQuery, Databricks, dbt, Terraform, Wrike, Jira, or Azure DevOps is a plus.
• DP-203 and/or GCP Professional Data Engineer certification is a plus.

Responsibilities

• Design, develop, and optimize enterprise ETL/ELT pipelines using Azure Data Factory, Azure Data Lake Storage, and serverless technologies.
• Build and optimize complex Azure T-SQL solutions, including query tuning, partitioning, and indexing.
• Develop automation frameworks with Python and API orchestration to streamline the data lifecycle.
• Own production pipeline reliability by performing root-cause analysis, resolving incidents, and implementing long-term stability measures.
• Define and enforce coding and architectural standards through code reviews and technical audits, while mentoring engineers.
• Maintain data lineage, governance, and automated CI/CD deployment across data assets.
• Partner with US onshore leadership and analytics/media teams to translate business needs into scalable, high-performance solutions.
• Lead end-to-end pipeline architecture and modernization initiatives involving Databricks, dbt, and DevOps; monitor SLAs, mitigate risk, and support compliance.

Skills

Python

SQL performance tuning

API orchestration

Data lifecycle automation

Mentoring engineers

CI/CD automation

Production operations

High-availability processing

Tools

Azure Data Factory

Azure Data Lake Storage

serverless technologies

Azure T-SQL

Databricks

dbt

Terraform

Wrike

Jira

Azure DevOps

BigQuery

Dataflow

Job description

WPP Media is hiring a Senior Data Engineer for the Global Operations Centre (GOC). You will design, build, and optimize enterprise ETL/ELT pipelines using Azure Data Factory, Data Lake Storage, and serverless tech, ensuring scalability, security, and reliability.

You will own production pipeline reliability, perform root-cause analysis, and mentor engineers while advancing CI/CD practices and governance across data assets.