Job Description

Position Summary

As an analyst on the Audience and Analytics team, you will be positioned for rapid growth and gain hands-on experience working on advanced marketing analysis and measurement projects. This position offers the chance to work with engaged client teams, a variety of media and analytics platforms and data sources, all supported by a strong internal system.

Key Responsibilities

• Providing data and analytics services to our customers:

• Leverage data feeds from various media data sources and our global harmonized Business Intelligence (BI) reporting tools to create holistic performance reports
• Create, modify, run, automate and document "ETL" (SSIS) programs.
• Participate in the modelling, creation, modification of database structures for the data warehouse data.
• Create data visualizations to communicate your key findings to specific audiences
• Developing optimal processes for performing analytics

• Be the subject matter expert and educate the extended team on learnings across the various platforms
• Assist in ongoing processes and decisions around data storage
• Collaborate with other specialists in their sector to define the rules of governance and standards surrounding the practice of business intelligence.
• Draw on expertise of functional experts within internal teams to continually develop skills and capabilities

Desired Skills & Experience

• Fluency of R, Python, SQL, Access, and/or any other advanced analytics software package
• Knowledge of PostgreSQL database management
• Bachelor's degree in Marketing, Advertising, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience
• Data Visualization experience (Tableau, DOMO, Datorama, Data Studio)
• 1-2 years' experience including data extraction, manipulation, analysis, and reporting
• Advanced knowledge and proficiency in use of Microsoft Excel, PowerPoint & Access
• Proactive project management skills: able to manage multiple projects' timelines simultaneously
• Good interpersonal skills: able to maintain positive working relationships with a wide set of internal and external contacts
• Technically-minded with a desire to learn about data, marketing and the future of adtech
• Ability to make the complex simple when describing processes to audiences who might not be so expert in martech
• Nice to have: Working knowledge of media metrics and digital media reporting platforms such as DCM, SA360, Facebook, DSPs and other digital reporting platforms

What do we prioritize at & Canada? Putting People First.

Here's a few of the ways we do this:

?YOE Investing in Your Career Growth: 42% of staff across Canada were promoted last year. With a network of agencies in Canada and over 130 offices worldwide, we support your professional goals locally and globally.

?Y~Z Promoting Flexible Working: A hybrid workweek that works for you! Prefer to work from another country? We have the opportunity to work from anywhere in the world for 6 weeks each year.

ai Prioritizing Your Wellbeing: We start with a minimum of 37 paid days off including vacation and monthly wellness days. We also have 4-day long weekends year-round, meeting-free Friday afternoons, half-day summer Fridays, competitive benefits, RRSP matching, and more. Mental health training is provided for everyone and we have certified Mental Health First Aiders on staff to offer support.

?Y(TM) Building a Community Where Everyone Belongs: Leading the industry in our efforts to increase representation, celebrate uniqueness, and build community, we always look for new ways to foster a sense of belonging through our culture, our partnerships and our work.

?YZ Embracing Challenging Projects: We offer opportunities to be involved with memorable, collaborative and engaging media campaigns for internationally recognized brands. Our work is reflective of the passion, agility, curiosity and drive of individuals across and .

About Us

La meilleure faaon d'attirer l'attention de quelqu'un est de sortir des sentiers battus. Dans cet esprit, Media Experts fait tourner les tates de l'industrie depuis 40 ans en faisant une grande impression. Une agence mediatique canadienne axee sur les donnees et animee par l'esprit de decouverte; nous construisons des marques emblematiques sur le marche canadien. Notre approche unique tourne autour de la conception de strategies mediatiques efficaces et assidues qui stimulent l'engagement de la marque et fournissent des resultats commerciaux exceptionnels.

The best way to get someone's attention is to break a pattern. With that in mind, Media Experts has been turning industry heads for 40 years by Making a Big Impression. A data-driven Canadian media agency powered by the spirit of discovery; we build iconic brands within the Canadian market. Our unique approach revolves around designing effective, hard-working media strategies that drive brand engagement and deliver outstanding business results.