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, including ETL/ELT with Azure Data Factory, Azure Data Lake Storage and T-SQL. You will also own pipeline reliability, mentor engineers and work with US leadership and analytics teams. The role is part of the Global Operations Centre (GOC) and works with teams across the United States, Europe and Asia.

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, perform root-cause analysis and resolve 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 CI/CD deployment practices
  • Partner with US onshore leadership and analytics and media teams to translate business requirements into technical solutions
  • Lead 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
  • Personally built or maintained production data pipelines, beyond academic projects or reporting-only work
  • Demonstrated ownership of end-to-end ETL/ELT pipelines
  • Strong hands-on SQL skills, including joins, aggregations, CTEs, window functions, data validation and reconciliation
  • Practical production experience with cloud data pipelines (Azure Data Factory, Azure Data Lake Storage, Azure SQL); strong GCP 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
  • 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
  • Reusable Python automation frameworks, including testing, packaging, concurrency and retry handling
  • Ownership of SLAs/SLOs, observability, data lineage and incident-prevention practices
  • 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
  • Learning and development opportunities across the WPP Media and WPP networks

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
  • Candidates must write and explain their own queries without external AI or code-generation assistance
  • The process includes a live SQL coding assessment and a discussion of pipeline design, Python usage and production reliability
  • 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 works through the WPP Open platform.

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