General information

Agency: Initiative

Function: Data & Analytics

Location: Toronto, Canada

Job Ref#: 15415

Description & Requirements

Position Summary

This role provides a unique opportunity to stretch and grow your reporting analytics skills in the marketing industry. We are looking for a passionate analyst with a love for using their technical skills to produce accurate reports for our internal teams. The role of a Reporting Analyst is to provide data governance and quality assurance so that clients can rely on this data for decision making. Some of the data you’ll be working with include social media data, display & video programmatic buys, and site data. You will play a key role in driving an ongoing learning agenda and fostering a data driven decision making process, working collaboratively with various internal partners and client teams.

Key Responsibilities

  • Provide data quality audits on our SQL database on an ongoing basis
  • Provide data quality audits on our Tableau and Data/Looker Studio dashboards
  • Update executive summaries for various clients 
  • Highly leverage the use of technology for data processing and workflow automation 
  • Create and maintain client dashboards in Tableau, Datorama, Domo, Data Studio or Excel
  • Support and update dictionary mapping as needed
  • Site served / vendor data collection support
  • Analyze data to recommend campaign execution and visualization improvements, based on data and observed trends 
  • Automate ETL processes with Tableau Prep, python, App Script, or other scripting tools
  • Work closely with Business Intelligence, to ensure timely and accurate maintenance of internal dashboards and data management

Desired Skills & Experience

  • 1-2 years of experience in an analytics-based role 
  • 1-2 years of experience in marketing and/or media performance (digital experience desired)
  • Demonstrated proficiency in Microsoft Excel, SQL, or VBA 
  • Proficient in SQL queries and views.
  • Strong familiarity with using Tableau, Google Data Studio, DOMO or other reporting visualization platforms 
  • Familiarity with social media marketing and programmatic media channels
  • Strong communication skills (verbal & written); ability to provide concise and clear reporting
  • Proven ability to self-check work to ensure results are error-free 
  • Keenness to learn new skills, platforms, and technologies
  • Nice to haves: exposure to any DSP, DV360, CM360, GA/GA4

Employment Transparency

IPG Mediabrands is an equal opportunity employer. We welcome and encourage applications from all interested parties, regardless of their preferred official language. Accommodations are available, upon request, for individuals with disabilities or medical needs at any stage of the recruitment process. We thank all applicants for their interest in IPG Mediabrands. However, only those candidates selected for an interview will be contacted.

About Us

We’re a global media agency designed to grow brands through culture. Over the last three years, we’ve been named as the fastest growing media agency in the world by independent media ratings agency, RECMA. Key to our success is the fact most media agencies are built for brand awareness, with a bias for paid media. We’re a little different. We’re built for brand relevance, with a bias for Cultural Velocity. We believe the brands that succeed move and adjust with consumers at speed, showcasing their relevance and meaningfully contribute to their lives. We call this Cultural Velocity™ - a measure for the speed at which a brand moves through culture to drive relevance. The faster a brand can move with culture, the more relevant they become and the greater the growth. Operating in over 90 countries, Initiative employs 4,000 of the smartest and most diverse talent in the industry.