Analyst, Customer Insights BI
Job in
Naperville, DuPage County, Illinois, 60540, USA
Listed on 2026-06-04
Listing for:
Kehe Food Distributors
Full Time
position Listed on 2026-06-04
Job specializations:
-
IT/Tech
Data Analyst, Business Systems/ Tech Analyst, Data Engineer, Data Science Manager
Job Description & How to Apply Below
* Full-time
* Pay Range: $95,700.00/Yr.
- $/Yr.
* Shift Days: , Shift Time:
* Benefits on Day 1
* Health/Rx
* Dental
* Vision
* Flexible and health spending accounts (FSA/HSA)
* Supplemental life insurance
* 401(k)
* Paid time off
* Paid sick time
* Short term & long term disability coverage (STD/LTD)
* Employee stock ownership (ESOP)
* Holiday pay for company designated holidays
Overview
Good people, working with good people, for our common good.
Sound good?
KeHE-a natural, organic, specialty and fresh food distributor-is all about "good" and is growing, so there's never been a more exciting time to join our team. If you're enthusiastic about working in an environment with a people-first culture and an organization committed to good living, good food and good service, we'd love to talk to you!
Primary Responsibilities
The Consumer Insights Business Intelligence Analyst will own the backend data management, UPC-level database architecture, and Power
BI infrastructure that power Consumer Insights' transformation into a proactive intelligence platform. This is a hands-on technical role-you will write and maintain SQL queries, Python scripts, DAX measures, and Power Query (M) transformations to enable self-service insights, real-time KPI tracking, and predictive modeling to support Exclusive Brands' Import, Private Label, and Owned Brand growth strategies. As with all positions at KeHE Distributors, we expect that all actions will be consistent with KeHE's Mission, Vision, and Values.
Essential Functions
DUTIES, TASKS AND RESPONSIBILITIES:
Power
BI Dashboard Development & Data Modeling
* Design, build, and maintain 12+ monthly Brand Intelligence dashboards using DAX measures, calculated columns, and Power Query (M) transformations to track brand velocity, promotional lift, and competitive positioning
* Create and maintain the underlying data models, relationships, and row-level security configurations that enable self-service white space identification tools across 600+ subcategories
* Develop live OKR tracking dashboards for innovation pipeline, Private Label opportunities, and retailer-specific strategic decks
* Build predictive assortment optimization models using Monte Carlo simulations and SKU success forecasting
Backend Data Management & Database Engineering
* Own and manage UPC-level data mapping between CPG syndicated sources (SPINS, Circana, Nielsen), internal KeHE product databases, and the Power
BI data models they feed-ensuring consistency, accuracy, and traceability across all reporting
* Build and maintain automated ETL pipelines using Python scripts, SQL stored procedures, and Power Query (M) to ingest, clean, transform, and refresh UPC-level datasets on daily/weekly cadences
* Establish and enforce data governance standards for CPG UPC databases-maintaining master product hierarchies, resolving mapping discrepancies, and ensuring data quality across syndicated and proprietary datasets
* Design and maintain the centralized data architecture (SQL databases, Python-managed data stores) that serves as the single source of truth for Consumer Insights analytics across cross-functional teams
Automation & Scalability
* Automate recurring reports: monthly Brand Intelligence updates, quarterly thought leadership metrics, KPI snapshots for leadership
* Reduce manual Excel/PowerPoint workflows through dashboard automation and parameterized reporting
* Build alerting systems for KPI thresholds (e.g., velocity drops below 75th percentile, white space opportunities exceeding $1M)
* Enable retailer-specific and category-specific parameterized views (e.g., Albertsons Deli dashboard, Publix Cheese performance)
Stakeholder Collaboration & Training
* Partner with Consumer Insights Lead to translate analytical frameworks (5-stage white space, promotional lift tools, assortment optimization) into scalable dashboards
* Train cross-functional teams (Sales, Merchandising, Marketing, Category Management) on dashboard usage and self-service capabilities
* Gather requirements from business stakeholders across Exclusive Brands, Owned Brands, and Import teams
* Present insights, tool capabilities, and roadmap updates to senior leadership
Minimum Requirements , Qualifications, Additional Skills, Aptitude
SKILLS, KNOWLEDGE AND ABILITIES:
* High competency in Power
BI, including DAX expressions, Power Query (M language), data modeling, relationship management, and row-level security implementation
* Advanced SQL proficiency for database management, data exploration, stored procedures, transformation logic, and ad hoc reporting
* CPG/retail data fluency:
Understanding of UPC-level data structures, velocity, ACV, distribution, promotional lift, and market share metrics
* Proficiency in MS Office Suite, especially Excel (pivot tables, VLOOKUP, Power Pivot, VBA)
* Experience with syndicated data platforms: SPINS, Circana (formerly IRI), Nielsen, or Numerator
* Familiarity with retailer data systems (e.g., Kroger 84.51°, Albertsons Plated, retail POS feeds)
*…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×