Data Management and BI Senior Executive, GOC

WPP Media is WPP's AI-driven media operating unit, bringing together media, data, and partnerships to deliver creative personalisation at scale. As part of the Global Operations Centre (GOC), you will work closely with teams across the United States, Europe, and Asia to deliver high-impact solutions in a collaborative, multicultural environment. We are looking for a Senior Data Engineer who will design, develop, and optimize enterprise ETL/ELT pipelines using Azure Data Factory, Azure Data Lake Storage, and serverless technologies, ensuring scalability, security, and reliability. This position is available in a Remote or Hybrid Work Modality and must be performed from any location within Mexico or Colombia.

Responsibilities

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

Requirements

3–4 years of progressive experience in data engineering; Expert-level hands-on experience with Azure Data Factory, advanced Azure T-SQL/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 and Azure Data Lake Storage; Advanced SQL performance tuning skills, including complex query optimization, partitioning, indexing, and high-volume data processing; Strong Python and API orchestration skills for automation; Advanced experience with production operations, troubleshooting, root-cause analysis, high-availability processing, monitoring, SLA management, and CI/CD automation

Nice to have

Experience with one or more of 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

Benefits

Access to internal learning platforms, certifications, and training sessions; Life insurance; Wellness programs; Significant paid time off; Preferential partner discounts; Employee mental health awareness day