Analyst, Data Management & Visualization

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:

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: $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/