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.