Sr Business Intelligence Analyst
About the role
Description 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.
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:
- 3 – 5 years related experience
- Previous leadership skills a bonus.
Qualifications 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 scorecarding and data modelling
Responsible for data accuracy- analysing data for completeness, format, and conformity
Manging performance. Able to function as a team lead, guiding and assisting other team members
Experience with Nielsen Discovery, Answers an asset.
About Us Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey.
As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America.
We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward to make the human experience better. We are diverse, yet like-minded individuals, and we believe in taking risks and creating shared experiences, not just for our clients, but for each other. Every associate is given the keys to charter new ground as they collectively live in the moment of building memorable experiences together.
Acosta Group and its subsidiaries believe the posted compensation range accurately reflects this role at the time of posting. Final pay may vary based on qualifications and location, and the range may be updated in the future.
Acosta Group is an E-Verify employer. By applying, you agree to our Privacy Statement and Terms of Conditions.
US: http://acosta.jobs/privacy-policy-us/
Canada: http://acosta.jobs/privacy-policy-ca/
We are an equal employment opportunity employer.
Mosaic is part of Acosta Group. To learn more about Mosaic click here: https://acosta.jobs/agency/mosaic
Acosta, and its subsidiaries, is an Equal Opportunity Employer
Job Category: Marketing
Position Type: Full time
Business Unit: Sales
Salary Range: $61,500.00 - $76,900.00
Company: Acosta Canada Corporation
Req ID: 6340
About Acosta
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.
Sr Business Intelligence Analyst
About the role
Description 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.
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:
- 3 – 5 years related experience
- Previous leadership skills a bonus.
Qualifications 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 scorecarding and data modelling
Responsible for data accuracy- analysing data for completeness, format, and conformity
Manging performance. Able to function as a team lead, guiding and assisting other team members
Experience with Nielsen Discovery, Answers an asset.
About Us Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey.
As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America.
We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward to make the human experience better. We are diverse, yet like-minded individuals, and we believe in taking risks and creating shared experiences, not just for our clients, but for each other. Every associate is given the keys to charter new ground as they collectively live in the moment of building memorable experiences together.
Acosta Group and its subsidiaries believe the posted compensation range accurately reflects this role at the time of posting. Final pay may vary based on qualifications and location, and the range may be updated in the future.
Acosta Group is an E-Verify employer. By applying, you agree to our Privacy Statement and Terms of Conditions.
US: http://acosta.jobs/privacy-policy-us/
Canada: http://acosta.jobs/privacy-policy-ca/
We are an equal employment opportunity employer.
Mosaic is part of Acosta Group. To learn more about Mosaic click here: https://acosta.jobs/agency/mosaic
Acosta, and its subsidiaries, is an Equal Opportunity Employer
Job Category: Marketing
Position Type: Full time
Business Unit: Sales
Salary Range: $61,500.00 - $76,900.00
Company: Acosta Canada Corporation
Req ID: 6340
About Acosta
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.