Mars Logo

Mars

Commercial Planning BI Lead - Mars Snacking

Posted 9 Days Ago
Be an Early Applicant
In-Office
Chicago, IL, USA
108K-149K Annually
Mid level
In-Office
Chicago, IL, USA
108K-149K Annually
Mid level
Owns and maintains Power BI reports and data models supporting Commercial Business Planning. Troubleshoots data, refresh, performance, and reporting issues; develops scalable dashboards and automated solutions; and translates Sales, Supply Chain, and Finance requirements into technical reporting changes. Leads requirements, design, development, testing, and rollout while maintaining consistent metrics and KPIs across shared reporting tools.
The summary above was generated by AI

Job Description:

Commercial Planning BI Lead

Chicago, IL


The Commercial Planning BI Lead is the hands-on technical owner of Power BI reports and data models that support Commercial Business Planning (CBP). This role will maintain accurate reporting, troubleshoot data and performance issues, and partner with Supply, Sales, and Finance to translate business needs into technical solutions. The Commercial Planning BI Lead will utilize expertise in Power BI, DAX, and Power Query to build and improve solutions as planning and business needs evolve, focusing on flexibility, scalability, and automation.  Specific responsibilities include troubleshooting and maintaining critical, complex source-of-truth reporting that support CBP and serve multiple functions; building and developing reporting solutions to meet evolving needs of the business; and partnering with global project teams to drive automated solutions.


What are we looking for?


Minimum Qualifications:

  • Bachelor’s Degree
  • 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 (Data Modeling, DAX, Power Query)
  • Demonstrated ability to validate reporting against source data and troubleshoot refresh and performance issues; as well as experience developing or creating models and dashboards

Preferred Qualifications:

  • 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

What would be your key responsibilities?


  • Owner of Commercial Business Planning Reporting. Own the 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 and resolve complex issues. Trace discrepancies and escalated refresh or performance issues through source data, Power Query transformations, model relationships, and DAX calculations. Validate fixes against source data and confirm the results with affected teams.
  • Translate business needs into reporting changes. Partner with Sales, Supply Chain, and Finance to understand the decisions they need to make, define metrics and business rules, and assess how proposed changes will affect other teams using the same reports.
  • Drive projects and time-sensitive enhancements through delivery. Lead requirements, design, development, testing, and rollout. Respond quickly to emerging business and senior leadership needs while keeping shared definitions and KPIs consistent.

What can you expect from Mars?


  • Work with over 150,000 diverse and talented Associates, all guided by The Five Principles.
  • Join a purpose driven company, where we are striving to build the world we want tomorrow, today.
  • Best-in-class learning and development support from day one, including access to our in-house Mars University.
  • An industry competitive salary and benefits package, including company bonus.

The base pay range for this position at commencement of employment is between the range listed below, however, base pay offered may vary depending on multiple individualized factors, including but not limited to job-related knowledge, skills, and experience. The total compensation package for this position will include variable pay, medical and dental benefits, participation in 401k plan, and paid time off benefits. Details of participation in these benefit plans will be provided if an applicant receives an offer of employment.

The pay range shown is applicable to all US locations listed within the job posting:USD 108,160.00 - USD 148,720.00

Mars Chicago, Illinois, USA Office

1132 W Blackhawk St, Chicago, Illinois, United States, 60642

Similar Jobs

5 Hours Ago
Remote or Hybrid
Riverwoods, IL, USA
138K-158K Annually
Senior level
138K-158K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Manages strategically important global partners and provides operational business support across onboarding, training, customer issue resolution, and internal systems. Leads complex, cross-functional process improvement initiatives, product and solution implementations, and strategic projects. Analyzes metrics to drive improvements, documents requirements, mitigates process and system gaps, and collaborates with technical teams and stakeholders. Coaches peers and mentors junior account executives while facilitating training.
Top Skills: Authorization And Settlement Applications
5 Hours Ago
Hybrid
Riverwoods, IL, USA
138K-173K Annually
Senior level
138K-173K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Manage enterprise risk management initiatives, enhance risk identification frameworks, standardize cross-functional processes, develop risk metrics, and provide executive reporting. Partner with business, technology, product, and data teams to implement improvements, lead training, support governance, fulfill audit and regulatory requests, and ensure consistent risk framework execution across business lines.
Yesterday
Hybrid
Chicago, IL, USA
87K-135K Annually
Mid level
87K-135K Annually
Mid level
Artificial Intelligence • Cloud • Information Technology • Legal Tech • Productivity • Software
Manages post-sale customer success for cloud customers and law firms using a pooled model. Responsibilities include driving adoption, responding to customer inquiries, creating self-service resources, maintaining documentation, coordinating escalations, analyzing customer data, improving scalable workflows, and building customer advocacy. Requires strong communication, organization, resourcefulness, and experience in a high-volume SaaS support or customer success environment.
Top Skills: ImanageSaaSSalesforceZendesk

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account