Analyst, Customer Insights BI Job at KeHE Distributors (Boulder)

Job Description

The Consumer Insights Business Intelligence Analyst will own the backend data management, UPC-level database architecture, and PowerBI 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.

Job Responsibility

Own the backend data management, UPC-level database architecture, and PowerBI infrastructure that power Consumer Insights’ transformation into a proactive intelligence platform
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
Design, build, and maintain 12+ monthly Brand Intelligence dashboards
Create and maintain the underlying data models, relationships, and row-level security configurations
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
Own and manage UPC-level data mapping between CPG syndicated sources (SPINS, Circana, Nielsen), internal KeHE product databases, and the PowerBI data models they feed
Build and maintain automated ETL pipelines using Python scripts, SQL stored procedures, and Power Query (M)
Establish and enforce data governance standards for CPG UPC databases
Design and maintain the centralized data architecture (SQL databases, Python-managed data stores)
Automate recurring reports
Reduce manual Excel/PowerPoint workflows through dashboard automation
Build alerting systems for KPI thresholds
Enable retailer-specific and category-specific parameterized views
Partner with Consumer Insights Lead to translate analytical frameworks into scalable dashboards
Train cross-functional teams on dashboard usage and self-service capabilities
Gather requirements from business stakeholders
Present insights, tool capabilities, and roadmap updates to senior leadership

Requirements

High competency in PowerBI, 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)
Experience with Tableau or Qlik (in addition to PowerBI)
Python for data pipeline automation, UPC database management, statistical modeling, and integration scripting (pandas, numpy, requests, etc.)
Azure Data Factory, Databricks, or similar ETL tools for data pipeline automation
SSRS report building for enterprise-grade reporting
Analytical mindset with the ability to interpret complex CPG datasets and provide clear, actionable insights for cross-functional stakeholders and executive leadership
Working knowledge of category management concepts (assortment planning, SKU productivity, promotional evaluation) sufficient to support analytical outputs—deep category expertise is not required
Sense of urgency and attention to accuracy and detail in fast-paced, deadline-driven environment
Self-motivated, eager to learn, and focused on continuous improvement of tools and processes
Excellent communication skills: Ability to translate complex data findings into clear, compelling stories for non-technical stakeholders (buyers, sales teams, suppliers)
Strong collaboration skills: Work across multiple departments (Merchandising, Sales, Finance, Marketing, Category Management)
Highly credible, collaborative, and resourceful style with ability to work independently and as a team player
Capable of managing multiple projects simultaneously and prioritizing based on business impact
Bachelor's degree in Computer Science, Data Analytics, Information Systems, Business, Statistics, or related field
4-5 years of experience using BI tools such as PowerBI, Tableau, or Qlik (PowerBI preferred)
2+ years working with CPG/retail datasets, syndicated data platforms, or consumer insights analytics
Proven experience building data models, writing DAX expressions, creating Power Query (M) transformations, and implementing row-level security in PowerBI
Hands-on experience with syndicated data (SPINS, Circana, Nielsen) and ability to manage, map, and manipulate large UPC-level CPG datasets
Experience in natural/organic foods, specialty grocery, or CPG distribution, preferred
Background supporting Private Label development, innovation pipelines, or white space analysis, preferred
Previous experience working with distributor data or supporting brand/supplier relationships preferred
Knowledge of Exclusive Brands, KeHE portfolio, or specialty food distribution preferred
Ability to remain in a stationary position (seated or standing) for extended periods
Ability to operate a computer, keyboard, mouse, and other standard office equipment
Ability to view a computer screen for long periods
Ability to move about the office occasionally to access files, equipment, or attend meetings

Nice to have

Experience in natural/organic foods, specialty grocery, or CPG distribution
Background supporting Private Label development, innovation pipelines, or white space analysis
Previous experience working with distributor data or supporting brand/supplier relationships
Knowledge of Exclusive Brands, KeHE portfolio, or specialty food distribution
Experience with Tableau or Qlik (in addition to PowerBI)
Azure Data Factory, Databricks, or similar ETL tools
SSRS report building

What we offer

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

KeHE Distributors - All Job Offers

Select Country

Analyst, Customer Insights BI

Job Description

Job Responsibility

Requirements

Nice to have

What we offer

Looking for more opportunities?

Analyst, Customer Insights BI

Customer Insights & BI Analyst

Commercial Insights Analyst

Revenue Insights Analyst

Revenue Insights Analyst

Revenue Insights Analyst

Revenue Insights Analyst

BI Analyst

Senior BI Analyst (Business Intelligence)

Our AI answers in your language