MBCC - Junior Data Analyst

Position Summary

The Data Analyst role will be part of the Audience Strategy team. This role will focus on building audience segments and conducting in-depth analyses to gain deeper insights into their characteristics. The ideal candidate should possess strong expertise in SQL, marketing analytics, and data visualization, along with a creative, outside-the-box approach to problem-solving. In addition to the core responsibilities, the ideal candidate should have exceptional time management skills for meeting deadlines in a fast-paced environment.

Key Responsibilities

• Primary Support of Audience Creation

• Create data visualizations to communicate your key findings to non-technical stakeholders

• Audience Ad-Serving Pacing and Usage Reporting

• Audience Performance Analysis

• Conduct analysis using a combination of tools such as Python, SQL and Tableau to compile and share analysis and insights into a presentation format.

• Work closely with internal teams to identify client business needs and look for opportunities to create customized analyses for clients across industries and verticals.

• Work both independently and in a team environment to research, test and implement new tools

• Automation of insight reports using Tableau and Python or any other software.

• Optimizing SQL queries for better performance and faster analysis

• Continuously seeking opportunities to improve our offerings and deliverables.

Desired Skills & Experience

• Professional or Educational Background in Marketing, Advertising, Computer Science, Information Systems, Business Analytics, or a related field

• Experience in analytics focused roles manipulating data and providing insights on business KPI’s and performance metrics.

• Advanced Proficiency in Microsoft PowerPoint and Excel Skills

• Excellent interpersonal skills and being able to maintain positive working relationships with wide set of internal and external contacts

• Prior experience in marketing analytics, consumer insights, or relevant agency environment

• Fluency in SQL and/or Other Analytics Software

BONUS!

• Experience in using one of the following: Snowflake DB, Microsoft SQL, Amazon Redshift, Google BigQuery

• Experience in building presentation decks for clients

• General Understanding of Programmatic, Social Advertising, DMP, DSP, SSP, Martech

• Python Data Analysis Proficiency

• Media Certifications and/or Analytics Certifications

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its best-in-class brands UM, Initiative, Media Experts, Reprise, MAGNA, Orion, Mediabrands Content Studio, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer packaged goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communications professionals in more than 130 countries. Learn more at www.ipgmediabrands.ca and follow us on LinkedIn: Mediabrands Canada and Instagram: @MediabrandsCanada.

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 with Tuesday anchor day.
• 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.

IPG Mediabrands 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 [email protected]