Commercial Planning BI Lead - Mars Snacking
About The Position
The Commercial Planning BI Lead is the hands-on technical owner of Power BI reports and data models supporting Commercial Business Planning (CBP). The role maintains accurate reporting, troubleshoots data and performance issues, and partners with Supply, Sales, and Finance to translate business needs into technical solutions. It uses Power BI, DAX, and Power Query to build and improve flexible, scalable, and automated reporting solutions as planning and business needs evolve. The position owns the maintenance and technical design of the CBP Rev Report and related Power BI tools, anticipates changes in data sources and business processes, and identifies and prioritizes improvements with business partners. It leads reporting requirements, design, development, testing, and rollout, including time-sensitive enhancements for emerging business and senior leadership needs. The role is based in Chicago, Illinois.
Requirements
- Bachelor’s degree.
- At least 4 years of experience in business analysis, reporting, business intelligence, or analytics, including experience supporting Sales, Supply Chain, or Finance.
- Advanced hands-on experience with Power BI, including data modeling, DAX, and Power Query.
- Ability to validate reporting against source data and troubleshoot refresh and performance issues.
- Experience developing or creating models and dashboards.
Nice To Haves
- Advanced hands-on experience with SQL.
- Experience supporting Sales & Operational Planning (S&OP), or a process that feeds it, such as Sales Forecasting, Demand Planning, or Supply Planning.
Responsibilities
- Own maintenance and technical design of the CBP Rev Report and related Power BI tools.
- Anticipate changes in data sources, business processes, and leadership reporting needs; identify solutions and prioritize improvements with business partners.
- Troubleshoot complex issues, tracing discrepancies and refresh or performance issues through source data, Power Query transformations, model relationships, and DAX calculations.
- Validate fixes against source data and confirm results with affected teams.
- Partner with Sales, Supply Chain, and Finance to understand business decisions, define metrics and business rules, and assess how proposed changes affect other teams using shared reports.
- Lead requirements, design, development, testing, and rollout of reporting changes and enhancements.
- Respond to emerging business and senior leadership needs while keeping shared definitions and KPIs consistent.
- Partner with global project teams to drive automated solutions.
Benefits
- Industry-competitive salary and benefits package, including company bonus.
- Variable pay.
- Medical and dental benefits.
- Participation in a 401(k) plan.
- Paid time off benefits.
- Learning and development support from day one, including access to Mars University.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
