Data Management and BI Senior Executive, GOC

The role

This senior data engineer will design, build and optimize enterprise ETL/ELT pipelines on Azure, and write T-SQL and Python automation. The role works with US, European and Asian teams as part of the Global Operations Centre at WPP Media.

What you will do

• 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
• Own production pipeline reliability, including root-cause analysis and resolving critical incidents
• Define and enforce coding and architectural standards through code reviews and technical audits, and mentor engineers
• Maintain technical documentation, data lineage, governance and automated CI/CD deployment practices
• Partner with US onshore leadership and analytics and media teams to translate business requirements into technical solutions
• Lead end-to-end pipeline architecture and modernization using Azure Databricks, dbt and DevOps practices
• Monitor service-level agreements, mitigate technical risks and support data security and compliance

Required qualifications

• Multiple years of hands-on professional data engineering experience in production
• Personally built or maintained production ETL/ELT pipelines, beyond academic or reporting-only work
• Strong hands-on SQL skills, including joins, aggregations, CTEs and window functions
• Practical production experience with cloud data pipelines; Azure Data Factory, Azure Data Lake Storage and Azure SQL are the target stack
• Hands-on Databricks experience with data workloads and distributed transformations
• Ability to write Python for data automation, API extraction and data processing
• Experience monitoring production pipelines, investigating failures and implementing durable fixes
• Understanding of safe development-to-production delivery, including version control, testing and deployment
• Ability to clearly explain technical decisions, contributions and production outcomes
• 3+ years of relevant experience is strongly preferred

Nice to have

• Advanced T-SQL performance tuning, including indexing, partitioning and execution-plan analysis
• Delta Lake optimization, Spark performance tuning and Databricks job orchestration
• Reusable Python automation frameworks with testing, packaging and retry handling
• Ownership of SLAs/SLOs, observability, data lineage and incident prevention
• Terraform or other infrastructure-as-code tools, Azure DevOps, dbt testing and data governance practices
• Experience mentoring engineers, making architectural decisions or leading platform modernization

Benefits

• Competitive medical insurance
• Group retirement plans
• Vision and dental insurance
• Significant paid time off
• Preferential partner discounts
• Employee mental health awareness days
• Employee resource groups and in-office events
• Access to the global WPP Media and WPP networks and learning opportunities

Before you apply

• Only candidates residing in Mexico or Colombia who are legally authorized to work there may apply
• The process includes a live SQL coding assessment and discussion of pipeline design, Python usage and production reliability
• Candidates must write and troubleshoot their own queries without external AI or code-generation assistance
• Accommodations for the assessment can be requested from the hiring team

About the company

WPP Media is WPP's AI-driven media operating unit, bringing together media, data and partnerships to deliver creative personalisation at scale. It is an equal opportunity employer.