Business Intelligence Analyst

Acosta Sales & Marketing; Mississauga; On-site; CAD 60,000 - 90,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Analyst to support clients with KPI and sales scorecards. This role requires excellent communication and presentation skills, as well as the ability to adapt to rapidly changing environments. The successful candidate will work closely with clients to develop reporting strategies and provide insights that drive data-driven decisions. With a focus on collaboration and continuous improvement, this position offers the opportunity to make a significant impact in a dynamic setting. If you're detail-oriented and passionate about data analysis, this role is perfect for you.

Qualifications

• 3-5 years of experience in business intelligence or related field.
• Experience in the CPG industry is a plus.

Responsibilities

• Develop and implement KPI and sales scorecards for clients.
• Collaborate with clients to present data and discuss strategies.

Skills

Communication Skills

Presentation Skills

Critical Thinking

Problem-Solving

Organizational Skills

Time Management

Tools

PowerBI

Excel

SQL

Retailer Data Portals

Job description

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 support business initiatives. The incumbent must adapt well to quickly changing environments and collaborate effectively with team members by sharing discoveries related to analysis and process improvements. This role involves working closely with clients and leadership to develop and implement retail and HQ reporting strategies. It is a client-facing position requiring excellent communication and presentation skills.

RESPONSABILITÉS

1. 3-5 years of related work experience
2. Previous CPG industry experience is an asset

Knowledge, Skills, and Abilities Requirements:

1. Proactive engagement in communication with exceptional active listening skills, fostering meaningful dialogue
2. Proactive and detail-oriented; able to communicate and engage with client/customer teams
3. Excellent presentation skills, coupled with strong written and verbal communication abilities
4. Strong organizational and time management skills
5. Critical thinking and creative problem-solving skills
6. Ability to document and follow up on meeting results, client approvals, and action items

Additional Responsibilities:

1. Coordinate project activities, communicate goals, timelines, and milestones
2. Advanced PowerBI skills (data transformation, DAX, data flows, visualizations)
3. Advanced Excel skills (PivotTables, formulas, Power Query, lookups)
4. Experience working with Retailer Data Portals (Retail Link, LDIA, Circana, OneScreen) is a major asset
5. Knowledge of querying SQL databases is an asset
6. Experience with KPI scorecarding and data modeling
7. Ensure data accuracy by analyzing data for completeness, format, and conformity
8. Experience with Nielsen Discovery, Answers is an asset

QUALIFICATIONS

Support data-driven decisions to keep clients competitive using data sources and tools such as POS data, retail data, shipments, Nielsen, Kantar, etc. Develop and maintain client-facing scorecards, measure progress against KPIs, and provide visualizations, analysis, and recommendations. Present data clearly and stay updated on visualization trends. Interface directly with clients to present results and discuss KPIs. Collaborate with business and client managers to ensure quality results, stay informed on client KPIs and strategies, participate in client meetings/QBRs, and perform other duties as assigned.