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.