Business Intelligence Analyst

Mosaic North America; Mississauga; On-site; CAD 50,000 - 65,000; Full time

Job summary

A leading marketing agency is seeking a Business Intelligence Analyst to support clients by providing key insights and reporting tools. The role requires advanced skills in Power BI and Excel, strong analytical abilities, and excellent communication skills. This client-facing position is pivotal in driving data-driven decisions.

Qualifications

• 3-5 years related work experience.
• Experience in CPG industry is an asset.
• Advanced Power BI and Excel skills required.

Responsibilities

• Provide KPI and sales scorecards for clients.
• Collaborate on reporting strategies and client presentations.
• Analyze data for completeness and accuracy.

Skills

Communication

Detail-oriented

Critical thinking

Creative problem-solving

Data analysis

Tools

Power BI

Excel

SQL

Job description

Join to apply for the Business Intelligence Analyst role at Mosaic North America

Join to apply for the Business Intelligence Analyst role at Mosaic North America

Description

The Analyst, Business Intelligence position will focus on supporting our clients by providing KPI and sales scorecards as well as insights and analysis to help support business initiatives. Incumbent must adapt well to quickly changing environments and collaborate effectively with other team members by sharing new and exciting discoveries related to discovery analysis and process improvements. This position entails working closely with our clients and leadership team to develop and implement retail and HQ reporting strategies. This is a client facing position which requires excellent communication and presentation skills.

Description

The Analyst, Business Intelligence position will focus on supporting our clients by providing KPI and sales scorecards as well as insights and analysis to help support business initiatives. Incumbent must adapt well to quickly changing environments and collaborate effectively with other team members by sharing new and exciting discoveries related to discovery analysis and process improvements. This position entails working closely with our clients and leadership team to develop and implement retail and HQ reporting strategies. This is a client facing position which requires excellent communication and presentation skills.

Responsibilities

• 3-5 years related work experience
• Previous CPG Industry experience an asset.
  
  
  

Knowledge, Skills, and Abilities Requirements:

• Demonstrates proactive engagement in communication with exceptional active listening skills, fostering meaningful and productive dialogue
• Proactive and detail oriented. Communicate and engage with client / customer teams
• Must be able to make presentations coupled with excellent written and verbal communication skills
• Excellent organizational and time management skills
• Critical thinking and creative problem-solving skills.
• Documents and follows up on meeting results, client/customer approvals, and owners of
  
  
  

action items

• Coordinating project activities- communicates project goals, timelines, and milestones
• Advanced PowerBI skillset (data transformation, DAX, data flows, visualizations).
• Advanced Excel skills (Pivot Tables, Formulas, Power Query, lookups)
• Prior experience working in the CPG industry a major asset.
• Experience working with Retailer Data Portals (Retail Link, LDIA, Circana, OneScreen) a major asset.
• Working knowledge of querying an SQL database an asset.
• Experience with KPI scorecarding and data modelling
• Responsible for data accuracy- analysing data for completeness, format, and conformity
• Experience with Nielsen Discovery, Answers an asset.
  
  
  

Qualifications

Support data-driven decisions to keep Clients’ competitive in the marketplace thru the utilization of the following data sources and tools. (POS data, Retail data, Shipment, Nielsen, Kantar, Etc.)

Develop and maintain client facing scorecards, measuring progress against defined KPIs. Provide visualization, analysis, and next step recommendations.

Responsible for data accuracy- analysing data for completeness, format, and conformity.

Present data in clear and meaningful fashion, stay up to date on data visualization trends and theory. Required to interface directly with clients to present results and discuss KPIs.

Work closely with business and client managers to ensure quality results are delivered

Keep abreast of clients KPI's, strategies, innovation, and other important information.

Participate in client meetings / QBRs to provide business analysis

Other duties as assigned

About Us

Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey.

As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America.

We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward to make the human experience better. We are diverse, yet like-minded individuals, and we believe in taking risks and creating shared experiences, not just for our clients, but for each other. Every associate is given the keys to charter new ground as they collectively live in the moment of building memorable experiences together.

Acosta Group and its subsidiaries believe the posted compensation range accurately reflects this role at the time of posting. Final pay may vary based on qualifications and location, and the range may be updated in the future.

Acosta Group is an E-Verify employer. By applying, you agree to our Privacy Statement and Terms of Conditions.

US: http://acosta.jobs/privacy-policy-us/

Canada: http://acosta.jobs/privacy-policy-ca/

We are an equal employment opportunity employer.

Mosaic is part of Acosta Group. To learn more about Mosaic click here: https://acosta.jobs/agency/mosaic

Acosta, and its subsidiaries, is an Equal Opportunity Employer

Job Category: Marketing

Position Type: Full time

Business Unit: Sales

Salary Range: $50,000.00 - $65,000.00

Company: Mosaic Sales Solutions Canada Operating Co

Req ID: 5835

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Advertising Services

Referrals increase your chances of interviewing at Mosaic North America by 2x

Get notified about new Business Intelligence Analyst jobs in Mississauga, Ontario, Canada.

Business Analyst (Power BI & Tableau), Technology Services Group

Business Analyst-Azure data/ datawarehouse

Senior Business Intelligence Analyst (Power Automate / Apps)

Data Analytics & Reporting Analyst - Fall 2025 (Co-op/Internship) - 8 Months

Richmond Hill, Ontario, Canada 3 weeks ago

Senior Analyst, Business Analysis and Insights

Business Analyst with SQL & Regulatory Data Analysis

Business Analyst (Intermediate) 8733-0611

Business Analyst (1y Contract, Contact Center Transformation)

Toronto, Ontario, Canada CA$85,000.00-CA$85,000.00 3 weeks ago

Greater Toronto Area, Canada $60.00-$70.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.