Logo of Huzzle

Home

Matches

Explore

Manage

Business Intelligence Analyst

image

Acosta

1mo ago

  • Job
    Full-time
    Mid & Senior Level
  • Data
    Marketing
  • Mississauga
    Remote

AI generated summary

  • You should have 3-5 years in CPG, advanced PowerBI and Excel skills, strong communication, critical thinking, project coordination, and experience with Retailer Data Portals and SQL.
  • You will analyze data, create client scorecards, ensure data accuracy, present insights, collaborate with managers, track KPIs, and participate in client meetings.

Requirements

  • 3-5 years related work experience
  • Previous CPG Industry experience an asset.
  • 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.

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

FAQs

What is the primary focus of the Business Intelligence Analyst position?

The primary focus is to support clients by providing KPI and sales scorecards, insights, and analysis to help support business initiatives.

What tools and data sources will the Business Intelligence Analyst be using?

The Analyst will utilize various data sources and tools including POS data, Retail data, Shipment data, Nielsen, and Kantar.

What are the required qualifications for this position?

Candidates should have 3-5 years of related work experience, excellent communication skills, advanced skills in PowerBI and Excel, and familiarity with the CPG industry is preferred.

Is previous experience in the CPG industry essential for this role?

While it is not mandatory, prior experience in the CPG industry is considered a major asset.

What kind of reporting responsibilities does the Analyst have?

The Analyst is responsible for developing and maintaining client-facing scorecards, ensuring data accuracy, and presenting findings effectively to clients.

How important is data visualization in this role?

Data visualization is crucial, as the Analyst is required to present data clearly and meaningfully while staying updated on data visualization trends and theories.

Will this position involve direct interaction with clients?

Yes, it is a client-facing position that requires excellent communication and presentation skills for interfacing directly with clients.

What software skills are essential for this position?

Advanced skills in PowerBI for data transformation and visualization, along with advanced Excel skills such as Pivot Tables and formulas, are essential.

Are there opportunities for career growth in this position?

Yes, the position offers opportunities for career growth through involvement in strategic projects and collaboration with various teams.

What is the salary range for the Business Intelligence Analyst position?

The salary range for this position is $50,000.00 - $65,000.00.

image

Acosta

Trusted Brands Trust Us

Retail & Consumer Goods
Industry
10,001+
Employees
1927
Founded Year

Mission & Purpose

Acosta brings simplicity to retail sales. We act as a catalyst to boldly connect brands, retailers and consumers, fueling growth and building long-term value throughout North America and Europe. We are deeply embedded in every corner of the retail industry, strengthening the local, regional and national relationships between brands and retailers.​ Our team of experts uses deep industry insight, cutting-edge analytics and integrated partnerships to help our clients move ahead with confidence.