About this role
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