Wppmedia

Data Management and BI Senior Executive, GOC

Barranquilla, Colombia; Bogota, Colombia; Medellin, Colombia; Mexico City, Mexico. Posted 3 months ago

The role

You will design, build and maintain enterprise data pipelines on Azure, mainly with Azure Data Factory, Data Lake Storage and T-SQL. You will also lead reliability work, mentor engineers and work with US leadership and analytics teams as part of the Global Operations Centre.

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.
  • Mentor engineers and improve delivery quality.
  • Maintain technical documentation, data lineage, governance and automated CI/CD deployment practices.
  • Partner with US onshore leadership and analytics and media teams to turn business requirements into technical solutions.
  • Lead end-to-end pipeline architecture and modernization initiatives involving 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.
  • Demonstrated ownership of end-to-end ETL/ELT pipelines.
  • Strong hands-on SQL skills, including joins, aggregations, CTEs and window functions.
  • Practical production experience with cloud data pipelines, with Azure Data Factory, Azure Data Lake Storage and Azure SQL as the target stack. Strong GCP data engineering experience may also be consid
  • Relevant hands-on Databricks experience.
  • Ability to write Python for data automation, API extraction and data processing.
  • Direct experience monitoring production pipelines, investigating failures and implementing durable fixes.
  • Practical understanding of safe development-to-production delivery, including version control, testing, deployment and rollback.
  • Ability to clearly explain technical decisions, contributions and production outcomes.

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.
  • Building reusable Python automation frameworks.
  • Ownership of SLAs/SLOs, observability, data lineage and incident-prevention practices.
  • Experience with Terraform or other infrastructure-as-code tools, Azure DevOps, dbt testing and data governance.
  • 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
  • Access to global WPP Media and WPP networks and learning opportunities
  • Employee resource groups and in-office events

Before you apply

  • Only candidates residing in Mexico or Colombia who are legally authorized to work there may apply.
  • Remote work from outside Mexico or Colombia, including relocation abroad under a remote contract, is not permitted.
  • The selection process includes a live SQL coding assessment, and candidates must write and troubleshoot their own queries without external AI or code-generation assistance.
  • The process also includes discussion of practical pipeline design, Python usage and production reliability.

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.

Data Management and BI Senior Executive, GOC at Wppmedia | JobZoey