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 production data pipelines on Azure, including ETL/ELT with Azure Data Factory, Azure Data Lake Storage and Azure SQL. You will also write Python automation, lead incident root-cause analysis, enforce coding standards and mentor engineers. You will work with US onshore leadership and analytics teams across the US, 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, performing 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 SLAs, 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, including sources, storage, transformations, orchestration and monitoring.
  • 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.
  • Relevant hands-on Databricks experience.
  • 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, 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 employee resource groups and in-office events.
  • Access to the global WPP Media and WPP networks for professional development.

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 work contract, is not permitted.
  • Candidates complete a live SQL coding assessment and must write and troubleshoot their own queries without external AI or code-generation assistance.

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