Business Intelligence Analyst

Department: Analytic Support 105604

Employment Type: Full Time

Location: Sterling Heights

Compensation: $70,000 - $85,000 / year

Description

The Business Intelligence Analyst is a strategically embedded role focused on delivering data-driven operational improvements throughout our organization. This position partners directly with leadership across operations to analyze performance, identify inefficiencies, and develop solutions that improve cost control, productivity, inventory accuracy, labor effectiveness, and the overall customer experience.


This role is ideal for a high-capacity analyst who enjoys solving operational challenges with data and wants to contribute meaningfully to a company’s service and distribution excellence.

WHAT YOU'LL DO

• Develop data models, KPIs, interactive visual dashboards, and insights to improve distribution center performance, including throughput efficiency, labor utilization, inventory control, and replenishment cycles.
• Provide ad hoc and project-based analysis to support tactical decisions and long-term strategic planning.
• Partner with operations, distribution, and senior leadership teams to design and maintain end-to-end business intelligence solutions, driving KPI performance, strengthening accountability, enhancing customer service, and delivering cost efficiency across the organization.
• Build tools and reports in Excel and Qlik Sense to simulate scenarios, streamline decision-making, and enhance performance tracking.
• Communicate findings and recommendations clearly across technical and non-technical teams, empowering data-led operational action.

WHO YOU ARE

• Advanced proficiency in Microsoft Excel (e.g., advanced formulas, modeling, Power Query).
• Professional experience with Qlik Sense, Power BI, or other BI/reporting tools.
• Ability to connect operational data to business goals, identifying and communicating high-impact opportunities for performance improvement.
• Excellent critical thinking and organizational skills; experience working independently with cross-functional partners.
• Prior experience with Python to support data cleaning, modeling, and reporting required.
• Operational exposure to routing logistics, delivery territory optimization, or direct-store delivery (DSD) service models.

Additional Skills & Experience:

• Prior experience in refreshment services, food/beverage logistics, or field-based distribution environments.
• Working knowledge of SQL or HTML is a plus but not required.

Benefits

We prioritize the health, wellness and work-life balance of our team members and designed our comprehensive compensation packages to reflect that. 

• Full-time team members are eligible for medical, dental and vision insurance, life insurance, disability insurance, parental leave, 401(k) with company match, at-work dining perks, flexible schedules, generous PTO, and a total rewards program. Team Members can also use our inclusive employee assistance program. 
• Part-time Team Members are eligible for our 401(k) with company match, at work dining perks and team members can also use our inclusive employee assistance program. 

Location-specific perks may also include wellness programming, on-the-job training, corporate-hosted courses, certifications and team events.

#CONALB