Position Summary

The Analyst, Media Investment Analytics role will fall within the Investment arm of IPG Mediabrands Canada, reporting to the Senior Director, Investments and Accountability. On the Investment side, the Analyst will support the Managers and Directors in data analysis and insight generation to support investment functions within Mediabrands. On the Investment Analytics side, you will work with the Manager of Investment Analytics to handle complex data sets, producing insightful, data-driven strategic recommendations and client dashboards.

Key Responsibilities

· Help to identify and communicate buying market conditions, changes, and developments to the Investment team.

· Proactively provide guidance and direction to the Investment team on buying conditions.

· Work with Investment Directors and Managers to update documentation and decks for agency teams on topics such as industry trends and media buying conditions.

· Support key processes within the Investment team including the buying accountability process, client pricing processes, maintenance of large data sets, etc.

· Work within a team environment in data sourcing, aggregation, and analysis to build robust Market Inflation and Ad Forecasts.

· Assist in analysis of partnership proposals to support contract negotiations.

· Support in deal management processes including creation of deal summaries, requesting and processing of partner investment trackers, tracking deal benefit utilization, etc.

Desired Skills & Experience

· Ability to work with large data sets while maintaining attention to detail, accuracy, and efficiency.

· Ability to drive actionable insights through analysis.

· Excellent ability to manage and prioritize time effectively across multiple projects.

· Takes a proactive approach to problem solving, supporting a team, self-development, etc.

· Ability to work well under pressure and multi-task in a fast-paced environment.

· Ability to work well within a team environment

· Shows an aptitude to pick up new processes, systems, and terminology quickly.

· Willingness to roll-up sleeves and manage data clean-up, data modeling, and slide creation

Qualifications

Post-secondary education – University graduate and/or quantitative background preferred

· 2+ years in a planning, buying, or insights/analytics role preferred

· Strong data interpretation and analytics skills

· Excellent written and verbal communication skills

· Proficient in MS Word, Excel, and PowerPoint.

· Proficiency in MS Teams & Asana is preferred but not necessary

· Experience with programs such as Tableau or Power BI, and SQL Server Management Studio [or similar programs] is an asset.

· Knowledge of coding, primarily SQL, preferred but not required

MAGNA is the leading global media investment and intelligence company. Our trusted insights, proprietary trials offerings, industry-leading negotiation, and unparalleled consultative solutions deliver an actionable marketplace advantage for our clients and subscribers. We are a team of experts driven by results, integrity, and inquisitiveness. We operate across five key competencies, supporting clients and cross-functional teams through partnership, education, accountability, connectivity and enablement. For more information, please visit magnaglobal.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.

Magna 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]