Business Intelligence Analyst

DescriptionThe 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 which requires excellent communication and presentation skills.ResponsibilitiesSupport 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 deliveredKeep abreast of clients KPI's, strategies, innovation, and other important information.Participate in client meetings / QBRs to provide business analysisOther duties as assignedQualificationsWork Experience Requirements:3-5 years related work experiencePrevious CPG Industry experience an asset.Knowledge, Skills, and Abilities Requirements:Demonstrates proactive engagement in communication with exceptional active listening skills, fostering meaningful and productive dialogueProactive and detail oriented. Communicate and engage with client / customer teamsMust be able to make presentations coupled with excellent written and verbal communication skillsExcellent organizational and time management skillsCritical thinking and creative problem-solving skills.Documents and follows up on meeting results, client/customer approvals, and owners ofaction itemsCoordinating project activities- communicates project goals, timelines, and milestonesAdvanced 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 modellingResponsible for data accuracy- analysing data for completeness, format, and conformityExperience with Nielsen Discovery, Answers an asset.About UsMosaic 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 is an equal opportunity employer and will ensure that applicants with disabilities are provided with reasonable accommodations. If reasonable accommodation is needed, please contact AskHR@acosta.com. Be sure to include "Applicant Accommodation" in the subject of your email to expedite the request.Acosta Group believes in good faith that the minimum and maximum annual salary or hourly compensation range for this opportunity is accurate and reasonable at the time of posting.The Acosta Group utilizes E-Verify for validating the ability to work in the United States for all job candidates. If you want more information on what this entails and your rights as a job applicant, please use the link provided to access information on our use of E-Verify and your right to work. Employer Resources (e-verify.gov)By applying, you agree to our Privacy Policy and Terms and Conditions of Use.\#DiscoverYourPathAcosta, and its subsidiaries, is an Equal Opportunity EmployerJob Category: MarketingPosition Type: Full timeBusiness Unit: CorporateSalary Range: $58,900.00 - $65,000.00Company: Mosaic Sales Solutions Canada Operating CoReq ID: 15373Employer Description: MOSAIC\EMP\DESC