Back to jobs

Junior Data Engineer

Toronto, Ontario, Canada

Live, first seen by us 21 days ago
Pay
$55,000–65,000/yearAnnual period assumed — pay source
This is an active vacancy. We are currently hiring for this role and reviewing applications on an ongoing basis. Expected Salary: $55,000 - $65,000 Omnicom Media is providing the compensation range that the company is willing to pay for this position based on the successful applicant’s education, experience, knowledge, skills and abilities.
Omnicom is an equal opportunity employer, committed to providing equal employment opportunities to all employees and applicants without regard to race, colour, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, disability, or any other basis prohibited by applicable federal, provincial, or municipal law. If you require an accommodation in any aspect of the selection process, please reach out to canadatalent@mbww.com 

Salary range: $55,000 - $65,000 Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting

The Data Engineering team is responsible for building and maintaining robust data infrastructure and dashboarding solutions for OMD's highest profile clients.

As a Junior Data Engineer, you will support the execution of our dashboarding roadmap and contribute to ongoing data operations.

  • Build, maintain and optimize ETL/ELT workflows for marketing analytics

  • Write production-ready SQL transformations to prepare marketing datasets

  • Redesign and rebuild the data model in Marketing Cloud Intelligence (Datorama)

  • Integrate marketing data from BigQuery, CSV/Excel files and APIs

  • Implement data validation checks and maintain data dictionaries

From the employer’s posting
The Data Engineering team is responsible for building and maintaining robust data infrastructure and dashboarding solutions for OMD's highest profile clients. We work closely with analytics and strategy teams to ensure clean, reliable, useable data flows and compelling visualizations that drive business insights.
As a Junior Data Engineer, you will support the execution of our dashboarding roadmap and contribute to ongoing data operations. With guidance from Data Engineering senior stakeholders and MarSci teams, you will be responsible for:
Build, maintain, and optimize ETL/ELT workflows supporting marketing analytics and reporting.
Develop production-ready SQL transformations to clean, structure, and prepare marketing datasets.
Redesign and optimize the underlying data model within Marketing Cloud Intelligence (Datorama).
Extract and integrate marketing data from multiple sources, including:
Implement data validation checks to identify data quality issues and inconsistencies.

Before you apply

New graduates
Entry levelJob title: Junior Data Engineer

What you’ll bring

All qualifications

Core experience

  • Experience & Background: You have 2+ years of experience in data engineering or related technical roles.
  • Proficiency in Excel is expected.
  • Communication & Problem-Solving: You are a clear communicator, both written and verbal.

Preferred experience

  • You have familiarity with SQL, and basic understanding of data modelling concepts is a plus.
Qualification wording
Experience & Background: You have 2+ years of experience in data engineering or related technical roles. You have a strong foundation in data fundamentals and are eager to grow your skills. You are comfortable working in technical environments and have a track record of learning new tools quickly.
Technical Skills: You have hands-on experience with the skills outlined above. Proficiency in Excel is expected. You have familiarity with SQL, and basic understanding of data modelling concepts is a plus. You are comfortable working with APIs and databases.
Communication & Problem-Solving: You are a clear communicator, both written and verbal. While technical, you can also explain data concepts to non-technical colleagues. You are a detail-oriented problem solver who approaches challenges methodically, but also creatively if the opportunity arises. You take pride in the quality and accuracy of your work.
Apply at Omnicom Group

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 29, 202621 days ago
Recorded sightings
16
Last seen by us
Nov 15, 2026
Employer says posted
Sep 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 21

Similar jobs usually come down between day 6 and day 56.

From 14,079 similar postings that came down. Coming down is not always a hire.

Omnicom Group is hiring

141 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • BigQuery
  • Excel
  • Tableau
  • Airflow
Where the posting names them
- Build, maintain, and optimize ETL/ELT workflows supporting marketing analytics and reporting. - Develop production-ready SQL transformations to clean, structure, and prepare marketing datasets. - Create reusable datasets and data models that support dashboards, reporting, experimentation, and advanced analytics.
Technical Skills & Experience - Strong SQL skills and ability to write production-quality queries. - Experience with data transformation and modeling.
Experience & Background: You have 2+ years of experience in data engineering or related technical roles. You have a strong foundation in data fundamentals and are eager to grow your skills. You are comfortable working in technical environments and have a track record of learning new tools quickly. Technical Skills: You have hands-on experience with the skills outlined above. Proficiency in Excel is expected. You have familiarity with SQL, and basic understanding of data modelling concepts is a plus. You are comfortable working with APIs and databases. Communication & Problem-Solving: You are a clear communicator, both written and verbal. While technical, you can also explain data concepts to non-technical colleagues. You are a detail-oriented problem solver who approaches challenges methodically, but also creatively if the opportunity arises. You take pride in the quality and accuracy of your work.
- Marketing Cloud Intelligence (Datorama) - Google BigQuery - Vendor-provided CSV/Excel files
- Experience with data transformation and modeling. - Experience working with cloud data warehouses (Google BigQuery preferred). - Familiarity with APIs and data integrations.
- Identify opportunities to automate recurring reporting processes. - Support evaluation and potential migration of dashboards from Marketing Cloud Intelligence (Datorama) to Tableau. Data Integration & Data Preparation
- Experience working with marketing analytics data sources is preferred. - Experience with visualization platforms such as Tableau is an asset. - Understanding of marketing measurement concepts and analytical methodologies.
- Understanding of marketing measurement concepts and analytical methodologies. - Familiarity with Airflow What We Are Looking For

Your next step

Complete your application on interpublic.wd5.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

Agency:

Omd

Job Function:

Consulting

Job Subfunction:

Technology Consulting

Job Description:

About the role

The Data Engineering team is responsible for building and maintaining robust data infrastructure and dashboarding solutions for OMD's highest profile clients. We work closely with analytics and strategy teams to ensure clean, reliable, useable data flows and compelling visualizations that drive business insights.


What will you do

As a Junior Data Engineer, you will support the execution of our dashboarding roadmap and contribute to ongoing data operations. With guidance from Data Engineering senior stakeholders and MarSci teams, you will be responsible for:


Marketing Data Engineering & Pipeline Development

  • Build, maintain, and optimize ETL/ELT workflows supporting marketing analytics and reporting.
  • Develop production-ready SQL transformations to clean, structure, and prepare marketing datasets.
  • Create reusable datasets and data models that support dashboards, reporting, experimentation, and advanced analytics.
  • Collaborate with analytics and marketing science teams to translate business requirements into scalable data solutions.

Marketing Cloud Intelligence (Datorama) Dashboard & Data Model Rebuild

  • Redesign and optimize the underlying data model within Marketing Cloud Intelligence (Datorama).
  • Rebuild data views, datasets, and reporting structures to improve usability and scalability.
  • Improve dashboard performance, data refresh processes, and reporting efficiency.
  • Identify opportunities to automate recurring reporting processes.
  • Support evaluation and potential migration of dashboards from Marketing Cloud Intelligence (Datorama) to Tableau.

Data Integration & Data Preparation

  • Extract and integrate marketing data from multiple sources, including:
  • Marketing Cloud Intelligence (Datorama)
  • Google BigQuery
  • Vendor-provided CSV/Excel files
  • Third-party marketing platforms through APIs
  • Build and maintain data ingestion processes to ensure timely and accurate data availability.
  • Clean, transform, and standardize data from multiple sources for analysis.

Data Quality & Documentation

  • Implement data validation checks to identify data quality issues and inconsistencies.
  • Monitor data accuracy and troubleshoot issues affecting reporting and analytics.
  • Maintain data dictionaries, metric definitions, and documentation of data processes.
  • Ensure consistency in business logic across reporting and analytical datasets.

Marketing Analytics Enablement

  • Understand the data requirements behind marketing measurement approaches, including:
  • Attribution & Multi-Touch Attribution (MTA)
  • Marketing Mix Modeling (MMM)
  • Incrementality testing & Experimentation
  • Forecasting
  • Partner with Marketing Science analysts and data scientists to support measurement, modeling, and optimization efforts.

Technical Skills & Experience

  • Strong SQL skills and ability to write production-quality queries.
  • Experience with data transformation and modeling.
  • Experience working with cloud data warehouses (Google BigQuery preferred).
  • Familiarity with APIs and data integrations.
  • Experience working with marketing analytics data sources is preferred.
  • Experience with visualization platforms such as Tableau is an asset.
  • Understanding of marketing measurement concepts and analytical methodologies.
  • Familiarity with Airflow

What We Are Looking For

Experience & Background: You have 2+ years of experience in data engineering or related technical roles. You have a strong foundation in data fundamentals and are eager to grow your skills. You are comfortable working in technical environments and have a track record of learning new tools quickly.

Technical Skills: You have hands-on experience with the skills outlined above. Proficiency in Excel is expected. You have familiarity with SQL, and basic understanding of data modelling concepts is a plus. You are comfortable working with APIs and databases.

Communication & Problem-Solving: You are a clear communicator, both written and verbal. While technical, you can also explain data concepts to non-technical colleagues. You are a detail-oriented problem solver who approaches challenges methodically, but also creatively if the opportunity arises. You take pride in the quality and accuracy of your work.

Mindset: You are curious and passionate about learning. You work collaboratively with others and are eager to contribute to team success. You are proactive, reliable, and committed to continuous improvement. You understand the importance of data integrity and best practices.


This is an active vacancy. We are currently hiring for this role and reviewing applications on an ongoing basis.


Expected Salary: $55,000 - $65,000


Omnicom Media is providing the compensation range that the company is willing to pay for this position based on the successful applicant’s education, experience, knowledge, skills and abilities.

In addition, Omnicom Media provides rewarding offerings such as:

• Generous paid time off with a minimum of 37 paid days off including vacation and monthly wellness days. We also have four-day long weekends, half-day summer Fridays, and meeting-free Friday afternoons year-round.

• A flexible hybrid work model that works for you.

• A focus on personal development with formal training opportunities, including mental health training and inclusion education for everyone.

• A chance to be part of and grow within a global network of agencies.

• The opportunity to contribute to our company culture by joining one of our many community-based employee groups, such as Black Employee Network, Girls on Fire, Hispanic or Latinx Alliance, Neuro Network, Pan-Asian Network, and Rainbow Lounge.


Omnicom is an equal opportunity employer, committed to providing equal employment opportunities to all employees and applicants without regard to race, colour, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, disability, or any other basis prohibited by applicable federal, provincial, or municipal law. If you require an accommodation in any aspect of the selection process, please reach out to canadatalent@mbww.com





Salary range: $55,000 - $65,000

Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.


Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.


Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice/

About Omnicom Group

People
About 120,000 in 2025.Annual report (SEC Form 10-K)
Company
Listed as OMC.
H-1B visas
22 approved for new hires in fiscal 2025.US Citizenship and Immigration Services

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
This is an active vacancy. We are currently hiring for this role and reviewing applications on an ongoing basis. Expected Salary: $55,000 - $65,000 Omnicom Media is providing the compensation range that the company is willing to pay for this position based on the successful applicant’s education, experience, knowledge, skills and abilities.
More source context
Omnicom is an equal opportunity employer, committed to providing equal employment opportunities to all employees and applicants without regard to race, colour, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, disability, or any other basis prohibited by applicable federal, provincial, or municipal law. If you require an accommodation in any aspect of the selection process, please reach out to canadatalent@mbww.com 

Salary range: $55,000 - $65,000 Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.
Location & working pattern

Toronto, Ontario, Canada

• Generous paid time off with a minimum of 37 paid days off including vacation and monthly wellness days. We also have four-day long weekends, half-day summer Fridays, and meeting-free Friday afternoons year-round. • A flexible hybrid work model that works for you. • A focus on personal development with formal training opportunities, including mental health training and inclusion education for everyone.
Work authorization
• The opportunity to contribute to our company culture by joining one of our many community-based employee groups, such as Black Employee Network, Girls on Fire, Hispanic or Latinx Alliance, Neuro Network, Pan-Asian Network, and Rainbow Lounge. Omnicom is an equal opportunity employer, committed to providing equal employment opportunities to all employees and applicants without regard to race, colour, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, disability, or any other basis prohibited by applicable federal, provincial, or municipal law. If you require an accommodation in any aspect of the selection process, please reach out to canadatalent@mbww.com 

Salary range: $55,000 - $65,000

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.