Analytics & AI Solutions Lead

We are one of the largest tea and coffee manufacturers in North America, with a mission to create a better beverage experience for our customers. As a leading customer solutions provider to some of North America’s largest retailers and foodservice chains, we use state-of-the-art technology and new product innovation to help our customers grow their business and deliver superior products to their clientele. Our team of coffee and tea experts are deeply passionate about what we do, proud of our 100+ years of business success, and excited about building a future with endless possibilities. Come join our team and work among the best, collaborate with high performers, and contribute to challenging work every day

The Role:

Reporting to the Senior Manager - BI Analytics & Applied AI, the Analytics & AI Solutions Lead is responsible for leading the design, development, and adoption of enterprise analytics, reporting, and AI solutions. This is a hands-on technical leadership role focused on Power BI development, semantic modeling, business engagement, data visualization, and analytics solution delivery.

The role serves as the primary bridge between business stakeholders and the BI team, translating business requirements into scalable reporting, dashboard, and AI solutions while ensuring strong user adoption, business value realization, and adherence to BI standards. The role works closely with the Data Architect & Fabric Platform Lead to leverage enterprise data assets and deliver modern analytics capabilities.

What you get to do:

Lead the design, development, enhancement, and support of enterprise Power BI dashboards, reports, scorecards, and analytics solutions.

Partner with business stakeholders across Finance, Supply Chain, Procurement, Manufacturing, Sales, and Operations to gather requirements and translate them into scalable analytics solutions.

Facilitate workshops, requirements sessions, UAT activities, stakeholder reviews, and solution demonstrations.

Design, optimize, and govern semantic models, measures, calculations, hierarchies, and KPIs to support enterprise reporting requirements.

Develop advanced DAX calculations, Power Query transformations, M Query logic, and analytical data models.

Design and optimize Direct Lake, Import, Aggregation, and Star Schema models to maximize report performance and scalability.

Define Power BI standards, visualization best practices, KPI frameworks, report design standards, and data storytelling principles.

Monitor report usage, performance, adoption, and business value realization while continuously improving existing solutions.

Drive self-service analytics capabilities through training, governance, and user enablement.

Partner with Data Engineering teams to ensure reporting solutions are supported by trusted, scalable, and governed data assets.

Utilize SQL, Python, and modern analytics tools to automate reporting processes and solve complex business problems.

Partner with business stakeholders to develop AI use cases across reporting, forecasting, operational insights, and decision support.

Identify, design, and deliver AI, Generative AI, Copilot, predictive analysis, and intelligent automation solutions that improve business processes and decision-making.

Design AI-ready and Copilot-ready datasets, semantic models, and analytics solutions that support future AI initiatives.

Design solutions that integrate AI capabilities with Dynamics 365, CRM, SharePoint, Teams, Outlook, Power BI, Dataverse, and other enterprise systems.

Support Business Process Automation (BPA) and Robotic Process Automation (RPA) initiatives by leveraging analytics, AI, and Microsoft platform capabilities.

Establish standards for AI solution lifecycle management, deployment, governance, and environment management.

Provide technical mentoring, solution guidance, and best-practice leadership to BI Developers and Analysts.

What you bring to the role:

Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, Mathematics, Statistics, or related discipline, equivalent.

8-10 years of experience in Business Intelligence, Reporting, Analytics, Data Visualization, or Analytics Solution Delivery.

3-5 years leading analytics initiatives, BI projects, or business-facing solution delivery

7+ years of experience in Business Intelligence, Reporting, Analytics, Data Visualization, or Analytics Solution Delivery.

3+ years leading analytics initiatives, BI projects, or business-facing solution delivery.

Proven experience developing enterprise-scale Power BI solutions and semantic models.

Experience managing end-to-end analytics solution delivery from requirements gathering through deployment and adoption.

Exper