Wppmedia

Data Management and BI Senior Executive, GOC

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

The role

As a Senior Data Engineer in the Global Operations Centre, you will design, build and optimize enterprise ETL/ELT pipelines on Azure and lead pipeline reliability and modernization. You will work with teams in 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, 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
  • 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, with 3+ years of relevant experience
  • Experience personally building or maintaining production data pipelines
  • 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; Azure Data Factory, Azure Data Lake Storage and Azure SQL are 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 and deployment practices
  • 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 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

Before you apply

  • Live SQL coding assessment, plus discussion of pipeline design, Python usage and production reliability
  • Candidates must write and troubleshoot their own queries without external AI or code-generation assistance
  • Only candidates residing in Mexico or Colombia who are legally authorized to work there may apply
  • 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.

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