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
- 3-5 years of related work experience
- Previous CPG industry experience is an asset
Knowledge, Skills, and Abilities Requirements:
- Proactive engagement in communication with exceptional active listening skills, fostering meaningful dialogue
- Proactive and detail-oriented; able to communicate and engage with client/customer teams
- Excellent presentation skills, coupled with strong written and verbal communication abilities
- Strong organizational and time management skills
- Critical thinking and creative problem-solving skills
- Ability to document and follow up on meeting results, client approvals, and action items
Additional Responsibilities:
- Coordinate project activities, communicate goals, timelines, and milestones
- Advanced PowerBI skills (data transformation, DAX, data flows, visualizations)
- Advanced Excel skills (PivotTables, formulas, Power Query, lookups)
- Experience working with Retailer Data Portals (Retail Link, LDIA, Circana, OneScreen) is a major asset
- Knowledge of querying SQL databases is an asset
- Experience with KPI scorecarding and data modeling
- Ensure data accuracy by analyzing data for completeness, format, and conformity
- 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.
