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.