Senior Data Engineer

VML MAP; Toronto; On-site; CAD 85,000 - 115,000; Full time

Job summary

A leading marketing analytics firm in Toronto is looking for a Senior Data Engineer. You will build and maintain data pipelines to support analytical needs and business initiatives. The ideal candidate has strong SQL and programming skills, a solid understanding of cloud infrastructures, and experience with ETL processes. Join a talented team to transform complex data into actionable insights.

Qualifications

• Experience in Spark, Python, Scala, or similar.
• Excellent SQL skills for data transformation and analysis.
• Understanding of cloud data warehousing and ETL processes.

Responsibilities

• Build high-quality data pipelines and models.
• Develop and optimize code for minimum cost.
• Design processes to correct ETL incidents.

Skills

Spark

Python

Scala

SQL

Data governance

Kubernetes

Tools

Google Dataflow

Looker

DBT

EMR

Airflow

Job description

Are you a Senior Data Engineer with a passion to build, support & maintain digital marketing solutions that offers real value? Are you interested in working with the largest global brands and complex challenges in the media analytics space? Then you might be the Senior Data Engineer we’re looking for!

What will your day look like?

As our new Senior Data Engineer, you will become part of our growing Data Insights and Science team. Here, you will employ new technologies across multiple cloud platforms to help successful brands reach their next level in 1:1 retargeting, communication, and CRM.

More specifically, your tasks include:

• Identify, collect, and integrate data from various sources by building high-quality data pipelines and data models for analytics and business intelligence (BI) purposes.
• Develop and optimize code to enable pipelines at minimum cost and ease of maintenance.
• Build monitoring procedures & tools to ensure solid ETL flows and data quality.
• Design processes and tools to correct ETL incidents.
• Collaborate with CRM developers, data scientists, data analysts, and product owners to ensure the supplied data supports the business initiatives.
• Consult our data analytics teams to ensure best practices on the technical use of data are followed.
• Design data architectures and collaborate in data migrations in cloud environments.

Who are you going to work with?

You will join a team of highly skilled Architects, Data Scientists, and Consultants who are passionate about unlocking insights from data through analytics. You will also get to work closely with experts from other Technology, Creative, and Client Teams.

What do you bring to the table?

As a person, you have a team player mindset and an open-minded attitude. You can communicate ideas and technical topics honestly and clearly – also to non-experts – while respecting the views of others on the team. You are eager to understand and find solutions, allowing you to quickly adapt to changing situations and come up with new ideas.

At the same time, you solve problems in an analytical and pragmatic manner.

Moreover, you have:

• Experience in Spark, Python, Scala, or similar.
• Excellent SQL skills enabling large-scale data transformation and analysis.
• A comprehensive understanding of cloud data warehousing, data pipelines and data transformation (extract, transform, and load) processes and supporting technologies such as Google Dataflow, Looker, DBT, EMR, CI/CD Pipelines, Airflow DAGs, and other analytics tools.
• Experience with cloud-based data infrastructures (Ideally GCP, but AWS or Azure would also suffice)
• Expertise in managing databases, including performance tuning, backup, and recovery.
• Solid knowledge of data quality management best practices, including data profiling, data cleansing, and data validation
• Knowledge of strengths and limitations of visualization tools (e.g. PowerBI, Tableau, Looker, etc.) in terms of data modeling in the visualization tools.
• Understanding of versioning control tools like GitHub to changes related to dbt models and transformations, ensuring that changes are tracked, documented, and reviewed by the appropriate stakeholders.
• Knowledge of applying data governance principles, policies, and practices that ensure data accuracy, consistency, and security
• Knowledge of Kubernetes would be an advantage

Personal skills:

• Strong desire to contribute towards keeping data tidy and well-organized
• Ability to think critically, identify issues autonomously, and propose corrective actions.
• Build great relationships with your team and stakeholders

A leader in personalized customer experiences

VML MAP is a world-leading Centre of Excellence that helps businesses humanize the relationship between the brand and the customer through hyper personalization at scale, marketing automation and CRM.With the brain of a consultancy, the heart of an agency and the power of technology and data, we work with some of the world's most admired brands to help them on their transformation journey to becoming truly customer-centric.Together, we are 1000 + technology specialists, data scientists, strategic thinkers, consultants, operations experts, and creative minds from 55+ nationalities.

A global network

We are part of the global VML network that encompasses more than 30,000 employees across 150+ offices in 60+ markets, each contributing to a culture that values connection, belonging, and the power of differences.

#LI-EMEA

WPP (VML MAP) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

When you click “Apply now” below, your information is sent to VML MAP. To learn more about how we process your personal data during when you apply for a role with us, on how you can update your information or have the information removed please read our Privacy policy . California residents should read ourCalifornia Recruitment Privacy Notice .

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Website / Link to portfolio *

Website Password (if applicable)

How did you hear about us? * Select...

What is your preferred name? *

What is your desired salary? *

Are you authorized to work in the country where this job is located? * Select...

Will you in the future require employer sponsorship to work where this job is located? * Select...

Are you currently a WPP employee? * Select...

If you are currently a WPP employee, what brand are you affiliated with?

Have you worked for a WPP agency in the past 10 years? * Select...

As part of our recruitment process, we kindly request that you provide us with two written references. Otherwise, we will reach out later in the process to collect the references. Can you please confirm if you have any that you can provide now? Select...

If you already have your references, please feel free to upload them here.

Accepted file types: pdf, doc, docx, txt, rtf