KeHE Distributors logo

Sr Analyst, Revenue Reporting

Location
Naperville, IL
Other
Sales
Why Work for KeHE?
  • Full-time
  • Pay Range: $95,700.00/Yr. - $127,490.00/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 Senior Analyst of Revenue Reporting will play a key role in supporting revenue and margin improvement at KeHE by owning and enhancing the enterprise Customer Profitability (CP) model and Power BI dashboards. Drawing on expertise in Power BI, SQL, and DAX, the Sr Analyst will enhance and maintain the customer profitability model, delivering accurate insights through dashboards and collaborating with cross-functional teams to improve data quality and performance.

    Essential Functions

    DUTIES, TASKS AND RESPONSIBILITIES:
    • Maintain, refresh, and improve KeHE's Customer Profitability (CP) model and reporting tools, including facilitating the monthly refresh process, validating results, and investigating anomalies.
    • Own the CP enhancement backlog: translate business priorities into actionable development sprints and drive implementation of changes to the Customer Profitability Power BI dashboard. If enhancements require data engineering work, collaborate with the KeHE data engineering team to implement the required changes.
    • Identify and address data quality issues and upstream data dependencies impacting the CP model.
    • Design and deliver Power BI dashboards and reports, including insights into customer segmentation, distribution center (DC) profitability, and margin trends.
    • Perform proactive analytics into the makeup of KeHE customer profitability, investigating profitability trends, cost trends, customer profitability peer analysis, and more.
    • Present findings in a clear, concise format tailored to executive and commercial stakeholders.
    • Collaborate with Finance, Sales, Pricing, IT, and Operations to ensure CP model assumptions align with business priorities and financial goals.
    • Educate and consult stakeholders on CP methodologies, assumptions, and results to build organizational understanding.
    • Maintain documentation of model assumptions, business rules, data sources, and system knowledge to ensure transparency and accountability.
    • Support audit and compliance efforts by providing reconciliations, documentation, and process expertise.
    • Leverage SQL and DAX to extract, transform, and model data across large, complex datasets.
    • Leverage workflow automation tools (e.g., Power Query, Power Automate, Power Apps) to streamline reporting processes, reduce manual effort, and improve accuracy.

    SKILLS, KNOWLEDGE AND ABILITIES:
    • Proficiency in Power BI, with advanced skills in SQL and DAX.
    • Exceptional attention to detail, organization, and communication skills.
    • Strong critical thinking and problem-solving skills.
    • High level of professionalism, integrity, and ability to manage confidential or sensitive information with discretion.

    Minimum Requirements, Qualifications, Additional Skills, Aptitude

    EDUCATION AND EXPERIENCE:
    • Bachelor's degree in Computer Science, Data Science, Mathematics, Finance, Accounting or related field required.
    • A minimum of 4 years of experience in financial, commercial, or operational analytics, preferably within food distribution, retail, or consumer goods.
    • Experience leveraging automation tools (e.g., Power Query, Power Automate) to streamline reporting and improve accuracy.

    PHYSICAL REQUIREMENTS:
    • Office based role.


    Requisition ID
    2025-27778
    Equal Employer Opportunity Statement
    KeHE Distributors provides equal employment opportunities to all employees and applicants for employment and prohibits all forms of discrimination and harassment on the basis of race, color, religion or faith, sex, gender, age, ancestry, national origin, mental or physical disability or medical condition, sexual orientation, gender identity or expression, marital status, military or veteran status, genetic information, or any other category protected under federal, state, or local law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training as well as the administration of all Human Resources and Talent Acquisition processes.