Analyst, Data Management & Visualization

Omnicom Media; Toronto; Hybrid; CAD 71,000 - 86,000; Full time

Benefits offered by this job

Generous PTO

Flexible hybrid work

Mental health training

Inclusion education

Employee networks

Job summary

Omnicom Media in Toronto, Ontario is seeking a data visualization professional to build and maintain interactive dashboards that reveal media performance, creative effectiveness, and audience behavior.

You will collaborate with analysts and planners to gather requirements and deliver clear, user-friendly dashboards using Tableau, Power BI, Looker, or similar tools.

Qualifications

• 1–2 years of experience in dashboard development and data visualization.
• Hands-on experience with at least one data visualization tool (Tableau, Power BI, Looker).
• Familiarity with data warehousing concepts.
• Working knowledge of SQL, and ideally Python or another data manipulation language.

Responsibilities

• Build and deploy interactive dashboards and data visualizations.
• Connect dashboards to data sources including databases and APIs; maintain ETL pipelines with review from seniors.
• Provide day-to-day maintenance and support for dashboards; troubleshoot issues; implement updates based on user feedback.

Skills

Dashboard development

Data visualization

SQL

Python

Teamwork

Tools

Tableau

Power BI

Looker

DOMO

Datorama

Job description

Position Summary:

You will build and maintain interactive dashboards and data visualizations that provide actionable insights into media performance, creative effectiveness, and audience behavior. Working under the direction of senior team members, you will help gather reporting needs from data analysts, media planners, and other stakeholders, and turn those needs into clear, user-friendly dashboards.

Agency:

Omnicom Media

Job Function:

Data and Analytics

Job Subfunction:

Data Engineering

Key Responsibilities:

Dashboard Development:

• Build and deploy interactive dashboards and data visualizations in tools such as Tableau, Power BI, Looker, DOMO, or Datorama, working from designs and requirements set with senior team members.
• Apply established performance standards to keep dashboards running quickly and efficiently.

Data Integration:

• Connect dashboards to existing data sources, including databases, APIs, and cloud storage.
• Maintain and extend existing ETL pipelines that feed dashboards, and build straightforward new ones with review from a senior team member.
• Monitor data quality and troubleshoot routine data integration issues, escalating recurring or upstream problems to the team.

Maintenance & Support:

• Provide day-to-day maintenance and support for existing dashboards.
• Troubleshoot and resolve dashboard issues in a timely manner.
• Implement updates and enhancements to dashboards based on user feedback and requests prioritized by the team.

Documentation:

• Create and maintain documentation for dashboards, data sources, and data pipelines, following team templates and standards.

Experience:

Desired Skills & Experience:

• 1-2 years of experience in dashboard development and data visualization.
• Hands-on experience with at least one data visualization tool such as Tableau, Power BI, or Looker.
• Familiarity with data warehousing concepts.
• Working knowledge of SQL, and ideally Python or another data manipulation language.
• Exposure to data integration and ETL processes.
• Some exposure to media or advertising reporting platforms (Google Analytics, CM360, etc.)

Skills:

• Ability to problem-solve.
• Ability to communicate clearly and understand briefed tasks.
• Ability to work as part of a team and independently on well-defined tasks.
• Working understanding of data visualization best practices.
• Ability to manage time across multiple assigned projects.

Bonus Points:

• Experience with cloud-based data platforms (e.g., AWS, Azure, GCP).
• Experience with version control systems (e.g., Git).

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

Generouspaidtimeoffwithaminimumof37paiddaysoffincludingvacationand monthlywellnessdays.Wealsohavefour-daylongweekends,half-daysummerFridays,andmeeting-freeFridayafternoonsyear-round.

Aflexiblehybridworkmodelthatworksforyou.

Afocusonpersonaldevelopmentwithformaltrainingopportunities,includingmentalhealthtrainingandinclusioneducationforeveryone.

Achancetobepartofandgrowwithinaglobalnetworkofagencies.

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.

Omnicomisanequalopportunityemployer,committedtoprovidingequalemploymentopportunitiestoallemployeesandapplicantswithoutregardtorace,colour,ethnicity,gender,age,religion,creed,nationalorigin,sexualorientation,genderidentity,maritalstatus,citizenship,geneticinformation,disability,oranyotherbasisprohibitedbyapplicablefederal,provincial,ormunicipallaw.Ifyourequireanaccommodationinanyaspectoftheselectionprocess,[e-mail]

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/

Salary Range: $50,000 - $60,000

Salary Range: $50,000 - $60,000