Initiative – Data Analyst

Position Summary

This role provides a unique opportunity to stretch and grow your data science and analytics skills in the marketing industry by leveraging a wide range of analytical areas. We are looking for a passionate analyst with a love for using their technical skills to solve marketing problems with data; someone who is experienced with reporting and data visualization. The role of a Data Analyst is to provide business portfolio and digital media intelligence to make faster and more effective investment decisions to drive business outcomes. Some of the data you’ll be working with – social media data, display and video programmatic buys, site data and market research 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 dashboard. 
•    Highly leverage the use of technology for data processing and workflow automation 
•    Create and maintain client dashboards in Tableau or Excel
•    Support and update dictionary mapping and documentation as needed.
•    Site served / vendor data collection support.
•    Analyze processes and find ways to continuously improve and optimize efficiencies.
•    Analyze data to recommend campaign execution and visualization improvements, based on data and observed trends. 
•    Maintenance and troubleshooting of existing ETL processes to ensure dashboard accuracy.
•    Work closely with the BI team, to ensure timely and accurate maintenance of data management.

Desired Skills & Experience

•    3+ years of experience in an analytics-based role 
•    2+ years of experience with Tableau development
•    2+ years of experience in marketing and/or media performance (digital experience desired)
•    Demonstrated proficiency in Microsoft Excel (Formulas, Macro, Pivot tables, etc.), 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

Initiative unlocks business growth for the world’s most ambitious brands. We believe in the power of media to reshape our industry and orchestrate a brand’s entire consumer experience, by balancing both what unites people and what makes them different. When brands unite people in culture, they build Fame, and when brands connect individuals to their unique journeys, they build customer Flow. Initiative builds Fame and Flow for brands like Amazon, RBC, LEGO, Nintendo and Canada Goose. Media responsibility is at the forefront of everything we do, whether it’s creating media plans that reflect the diversity of our communities, promote brand safety, and foster sustainability. Our agency celebrates diversity in an inclusive environment where all of our 9,000+ strong talent across 90+ markets feel seen, heard, and valued. Our vision is to create not only a better media company, but also a better media industry, and maybe even a better world. Initiative Canada has received many of the industry’s most coveted awards, including two gold Strategy Media Agency of the Year awards, eight Cannes Lions, and a position on WARC’s Top 50 Most Effective Media Agencies in the World. In 2023 Initiative was named the North American Network of the Year by the Festival of Media, and Global Network of the Year by both Ad Age and Ad Week. To learn more, visit initiative.com.

What’s in it for you?
•    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.

Initiative 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.