Data Analyst, Digital Hub - Toronto, Canada - IPG Mediabrands

IPG Mediabrands

Verified Company

Toronto, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

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

12 years of experience in an analyticsbased role
12 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 selfcheck work to ensure results are errorfree
Keenness to learn new skills, platforms, and technologies
Nice to haves: exposure to any DSP, DV360, CM360, GA/GA4

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