Business Intelligence Analyst

The Business Intelligence Analyst 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

• 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

Qualifications

• 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 score carding and data modelling
• Responsible for data accuracy- analyzing data for completeness, format, and conformity
• Experience with Nielsen Discovery, Answers an asset.