Logo of Huzzle

Business Intelligence Analyst

image

Acosta

1mo ago

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

AI generated summary

  • You must have strong communication skills, advanced PowerBI and Excel proficiency, experience in CPG and Retailer Data Portals, and a knack for data accuracy and analysis.
  • You will analyze data from various sources, develop client scorecards, ensure data accuracy, present insights, collaborate with managers, and participate in client meetings to drive business decisions.

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 score carding and data modelling
  • Responsible for data accuracy- analyzing 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 of the Business Intelligence Analyst position is to support clients by providing KPI and sales scorecards, along with insights and analysis to aid business initiatives.

What types of data sources will the analyst be working with?

The analyst will be utilizing various data sources including POS data, Retail data, Shipment data, Nielsen, Kantar, and others.

What skills are required for developing and maintaining client-facing scorecards?

Advanced skills in PowerBI and Excel are required, along with the ability to analyze data for accuracy and present it clearly.

Is this role client-facing?

Yes, this position is client-facing and requires excellent communication and presentation skills.

What kinds of analysis will the Business Intelligence Analyst conduct?

The analyst will conduct data analysis to support data-driven decisions, measuring progress against defined KPIs, and providing visualization, analysis, and next step recommendations.

What qualifications are preferred for this position?

Preferred qualifications include prior experience in the CPG industry, experience with Retailer Data Portals, and knowledge of querying SQL databases.

Are there opportunities for professional development in this role?

Yes, the analyst will be required to stay up to date on data visualization trends and theory, allowing for opportunities for professional growth and development.

What is the salary range for this position?

The salary range for the Business Intelligence Analyst position is between $50,000.00 and $65,000.00.

How does this position fit within the company structure?

The Business Intelligence Analyst position is categorized under Marketing, is a full-time role within the Sales business unit, and is part of Mosaic Sales Solutions Canada Operating Co.

What should a candidate expect in terms of accommodations for disabilities?

The company is committed to providing accommodations for persons with disabilities and will work with candidates to meet their needs as required by law.

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.