Analyst, Data Management & Visualization

Adelphi Group; Toronto; Hybride; CAD 50 000 - 60 000; Plein temps

Résumé du poste

Omnicom Media in Toronto, Canada is seeking a Data Visualization Specialist to build and maintain dashboards that reveal media performance and audience behavior. You will gather reporting needs from analysts and planners and translate them into clear, user-friendly dashboards using Tableau, Power BI, Looker, or similar tools.

Responsibilities include connecting data sources, maintaining ETL pipelines, ensuring data quality, and providing ongoing dashboard maintenance and documentation.

Qualifications

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

Responsabilités

• 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.
• 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.
• 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.
• Create and maintain documentation for dashboards, data sources, and data pipelines, following team templates and standards.

Connaissances

Dashboard development

Data visualization

SQL

Python

ETL

Looker

Tableau

Power BI

Outils

Tableau

Power BI

Looker

DOMO

Datorama

Description du poste

Agency:

Omnicom Media

Job Function:

Data and Analytics

Job Subfunction:

Data Engineering

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.

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.

Desired Skills & Experience:

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.

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:

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,pleasereachoutto [e-mail]

Salary Range: $50,000 - $60,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/