Wppmedia

Data Management and BI Manager, GOC

Barranquilla, Colombia; Bogota, Colombia; Medellin, Colombia; Mexico City, Mexico. Posted a month ago

The role

As a Senior Data Engineer in the Global Operations Centre, you will design, build and optimize ETL/ELT data pipelines on Azure and support analytics and media teams. You will also own pipeline reliability and mentor engineers.

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 translate 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 requirements.

Required qualifications

  • Multiple years of hands-on professional data engineering experience in production; 3+ years of relevant experience strongly preferred.
  • Demonstrated ownership of end-to-end ETL/ELT pipelines, including source systems, storage, transformations, orchestration and monitoring.
  • Strong hands-on SQL skills, including joins, aggregations, CTEs and window functions, applied to validation, duplicate detection and reconciliation.
  • Practical production experience with cloud data pipelines. Azure Data Factory, Azure Data Lake Storage and Azure SQL are the target stack; strong GCP data engineering experience may also be considered
  • Relevant hands-on Databricks experience with data workloads and distributed transformations.
  • Ability to write Python for data automation, API extraction and data processing, with concrete professional examples.
  • Direct experience monitoring production pipelines, investigating failures, performing root-cause analysis and implementing durable fixes.
  • Practical understanding of safe development-to-production delivery, including version control, testing, environment configuration, deployment and rollback.
  • Ability to clearly explain technical decisions, personal contributions, troubleshooting approaches 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, including testing, packaging, concurrency and retry handling.
  • 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 practices.
  • Experience mentoring engineers, making architectural decisions or leading platform modernization initiatives.

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 for professional connections and learning

Before you apply

  • Only candidates residing in Mexico or Colombia who are legally authorized to work there may apply.
  • Candidates will complete a live SQL coding assessment and discuss pipeline design, Python usage and production reliability.
  • Candidates must write and explain their own queries without external AI or code-generation assistance.
  • Accommodations for the assessment can be requested from the hiring team.
  • Only candidates selected for an interview will be contacted.

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 Manager, GOC at Wppmedia | JobZoey