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. 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 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.

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) Vendor-provided CSV/Excel files 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.

Understand the data requirements behind marketing measurement approaches, including: 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.

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. While technical, you can also explain data concepts to non-technical colleagues. You take pride in the quality and accuracy of your work. You are proactive, reliable, and committed to continuous improvement.

You understand the importance of data integrity and best practices. We are currently hiring for this role and reviewing applications on an ongoing basis. 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 versatile 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.

📌 Junior Data Engineer (Remote) (Toronto)
🏢 OMD Canada
📍 Toronto