Sr Analyst, Revenue Reporting

KeHE Distributors, LLC•Naperville, IL

About The Position

The Sr Analyst, Revenue Reporting helps drive profitable revenue growth at KeHE by developing dashboards and ad hoc analyses that provide strategic insights. The role develops reporting that gives visibility into performance drivers, predictive KPIs, and financial outcomes, including revenue performance, customer margin, pricing impact, and profitability. It maintains a structured commercial reporting cadence, uses large datasets for predictive analysis, improves dashboard usability in Power BI, and delivers executive-ready insights to support strategic decisions. The role is expected to act consistently with KeHE’s Mission, Vision, and Values. The analyst develops expertise in revenue, profitability, and KPI data; builds and maintains Power BI semantic models and standardized reporting measures; and consolidates insights from multiple sources into recurring reports for Commercial and Revenue Management priorities. The position also performs customer- and product-level statistical, predictive, and segmentation analyses, addresses data quality and upstream dependencies, documents models and business rules, and uses SQL, DAX, and workflow automation tools to improve reporting accuracy and efficiency. This is an office-based role.

Requirements

Bachelor’s degree in Computer Science, Data Science, Mathematics, Finance, Accounting, or a related field.
At least 3 years of experience in financial, commercial, or operational analytics.
Proficiency in Power BI, with advanced SQL and DAX skills.
Strong understanding of semantic modeling principles that support consistency, performance, and reliability in enterprise reporting.
Proficiency with automation tools such as Power Query and Power Automate to streamline reporting and improve accuracy.
Exceptional attention to detail, organization, and communication skills.
Strong critical-thinking and problem-solving skills.
Professionalism, integrity, and discretion when managing confidential or sensitive information.

Nice To Haves

Experience in food distribution, retail, or consumer goods.

Responsibilities

Develop expertise in revenue, profitability, and KPI data, existing reporting, and standard measurements, focusing on revenue by channel and product, event ROI, pricing impact, gross-to-net performance, customer churn, and margin dynamics.
Design, optimize, and maintain Power BI semantic models for scalable, high-performance reporting.
Establish standardized measures and reusable data structures to ensure dashboard consistency across the organization.
Build and maintain weekly, monthly, and quarterly reporting that consolidates multiple sources into actionable summaries aligned with Commercial and Revenue Management priorities.
Analyze historical performance and trends, identify actionable insights, and present findings clearly to executive and commercial stakeholders.
Improve management reporting through automation, refined KPI frameworks, and enhanced Power BI dashboard usability, visualization, layout, and user experience.
Use large, complex datasets for customer- and product-level insights through statistical modeling, predictive analytics, and segmentation analysis.
Perform ad hoc analyses for leadership and summarize findings using data visualizations and written narratives.
Identify and address data quality issues and upstream data dependencies affecting revenue reporting.
Document Power BI models, business rules, data sources, and system knowledge for transparency and accountability.
Use SQL and DAX to extract, transform, and model data across large, complex datasets.
Use workflow automation tools such as Power Query, Power Automate, and Power Apps to streamline reporting, reduce manual effort, and improve accuracy.