Role Summary and Impact

As part of the Global Operations Centre (GOC), you will work closely with teams across the United States, Europe, and Asia to deliver high-impact solutions in a collaborative and multicultural environment.

As a Senior Data Engineer, you will be responsible for:

• Designing, developing, and optimizing enterprise ETL/ELT pipelines using Azure Data Factory, Azure Data Lake Storage, and serverless technologies, ensuring scalability, security, and reliability.

• Building and optimizing complex Azure T-SQL solutions, including query tuning, partitioning, and indexing, to support advanced analytics models and real-time data processing.

• Developing automation frameworks with Python and API orchestration to streamline the data lifecycle and improve operational efficiency.

• Owning production pipeline reliability by performing root-cause analysis, resolving critical incidents, and implementing long-term stability measures.

• Defining and enforcing coding and architectural standards through code reviews and technical audits, while mentoring engineers and improving delivery quality.

• Maintaining technical documentation, data lineage, governance, and automated CI/CD deployment practices across data assets.

• Partnering with US onshore leadership and analytics and media teams to translate business requirements into scalable, high-performance technical solutions.

• Leading end-to-end pipeline architecture and modernization initiatives involving Azure Databricks, dbt, and advanced DevOps practices.

• Monitoring service-level agreements, mitigating technical risks, and supporting data security and compliance requirements.

Skills and Experience

If this opportunity looks right for you, we are looking for candidates who have:

• 3–4 years of progressive professional experience in data engineering.

• Expert-level hands-on experience working with Microsoft Azure and Azure data services in professional or production environments.

• Advanced experience designing, building, orchestrating, monitoring, and troubleshooting production-grade pipelines using Azure Data Factory.

• Relevant hands-on experience developing or managing data workloads using Azure Databricks.

• Proven experience designing and optimizing large-scale ETL/ELT pipelines, including ADF orchestration and Azure Data Lake Storage.

• Strong SQL fundamentals, including joins, aggregations, subqueries, CTEs, window functions, data validation, and query troubleshooting.

• Advanced Azure T-SQL and SQL performance-tuning skills, including complex query optimization, partitioning, indexing, and high-volume data processing.

• Strong Python and API orchestration skills for developing automation solutions.

• Advanced experience with production operations, troubleshooting, root-cause analysis, high-availability processing, monitoring, SLA management, and CI/CD automation.

• Experience with one or more of Adverity, Dataflow, BigQuery, dbt, Terraform, Wrike, Jira, or Azure DevOps is a plus.

• DP-203 and/or GCP Professional Data Engineer certification is a plus.

• Candidates progressing through the selection process must be comfortable solving SQL problems in real time and will be required to complete a live SQL coding assessment as part of the SmartData technical evaluation process.

Life at WPP Media & Benefits

Our passion for shaping the next era of media is powered by our commitment to Be Extraordinary, investing in our employees to inspire transformational creativity. We also Lead Optimistically, firmly believing in and Championing Growth and Development for every individual. This commitment allows WPP Media employees to leverage the extensive global WPP Media & WPP networks to pursue their passions, build vital professional connections, and learn at the cutting edge of marketing and advertising.

We Create an Open environment built on trust and respect, where everyone feels they belong and has opportunities to progress. This inclusive culture is fostered through a variety of employee resource groups and frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our comprehensive benefits package reflects this commitment, including competitive medical, group retirement plans, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.

WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We believe the best work happens when we're together, fostering creativity, collaboration, and connection in this open and supportive environment. That's why we’ve adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process. Please note that while our philosophy is the same across WPP, benefits may vary by office/country.

This position is available in a Remote or Hybrid Work Modality and must be performed from any location within Mexico or Colombia. Only candidates residing in either country 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 under any circumstances.

Please read our Privacy Notice (https://www.wppmedia.com/pages/privacy-policy) for more information on how we process the information you provide.

While we appreciate all applications received, only those candidates selected for an interview will be contacted.