Senior Business Intelligence Analyst

Acosta; Ontario; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in advertising services seeks a Senior Business Intelligence Analyst to support data-driven decisions and develop client-facing scorecards. This role requires advanced skills in PowerBI and Excel, along with strong communication and problem-solving abilities. The candidate will work closely with clients to deliver insightful analyses and improve business initiatives in a fast-paced environment.

Qualifications

• 3-5 years related experience.
• Advanced PowerBI and Excel skills required.
• Experience in CPG industry is a major asset.

Responsibilities

• Support data-driven decisions using various data sources.
• Develop and maintain client-facing scorecards with KPIs.
• Present results and discuss KPIs with clients.

Skills

Communication

Critical thinking

Problem solving

Data visualization

Tools

PowerBI

Excel

SQL

Job description

Join to apply for the Senior Business Intelligence Analyst role at Acosta

Join to apply for the Senior Business Intelligence Analyst role at Acosta

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Acosta

Sr. Talent Acquisition Partner at Acosta & Mosaic North America

The Sr Analyst, Business Intelligence 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 with possible additional team / management lead responsibilities.

Essential Functions:

• 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
• Able to function as a Team Lead. This entails providing support, mentorship, and guidance to other members of the team. May also include some management responsibilities.

Work Experience Requirements:

1. 3 – 5 years related experience

2. Previous leadership skills a bonus.

Knowledge, Skills, and Abilities 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.
• 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
• Managing performance. Able to function as a team lead, guiding and assisting other team members
• Experience with Nielsen Discovery, Answers an asset.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Analyst and Marketing

• Industries

  Advertising Services, Marketing Services, and Retail

Referrals increase your chances of interviewing at Acosta by 2x

Get notified about new Business Intelligence Analyst jobs in Greater Toronto Area, Canada.

Business Analyst (Power BI & Tableau), Technology Services Group

Business Analyst / Power BI & Alteryx - Contract Role

Senior Business Intelligence Analyst (Power Automate / Apps)

Business Analyst (New or Recent Graduate)

Business Analyst-Azure data/ datawarehouse

Senior Analyst, Business Analysis and Insights

Mississauga, Ontario, Canada 16 hours ago

Senior Business Analyst - Insurance (Fully Remote)

Markham, Ontario, Canada CA$55,000.00-CA$65,000.00 2 weeks ago

Business Analyst (Intermediate) 8733-0611

Business Analyst (Intermediate) 8366-1612

Business Analyst (Intermediate) 8472-1612

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.