Senior/Lead Business Analyst

An exciting career awaits you At MPC, we’re committed to being a great place to work – one that welcomes new ideas, encourages diverse perspectives, develops our people, and fosters a collaborative team environment.

Summary Do you have a strong technical background? Do you like building tools and data pipelines that power complex business decisions? Marathon Petroleum Company LP (MPC) has an opening within the Value Chain Optimization organization on the Value Chain Insights team. Our mission is to power confident decisions across the value chain — building the trusted tools and data foundations that drive enterprise optimization and delivering the cutting-edge analytics and insights that increase trust and confidence in our reporting and reducing barriers to timely, actionable insight. This role sits in the Model Interpretation vertical and is an individual contributor responsible for designing, building, and supporting enterprise optimization model case input tools that support Marathon's routine planning and optimization models across the value chain. Case input tools are applications that assemble, validate, and format the data required to run Marathon's Aspen PIMS and Aspen Petroleum Supply Chain Planner (PSCP) models for the full planning cycle, post-audits, and enterprise-wide optimization. This role requires expert-level Excel VBA development, strong SQL and data-pipeline skills, and a disciplined approach to building standardized, robust, low-maintenance solutions. Success depends on the ability to turn inconsistent or manual case-build processes into reliable, repeatable tooling; to partner closely with regional planning teams; and to bring engineering rigor, creative problem-solving, and attention to detail to every deliverable. This position has exposure and impact on other workstreams within the Model Interpretation team that include AI-assisted analytics and business intelligence platforms. This position belongs to a family of jobs with increasing responsibility, competency, and skill level. Actual position title and pay grade will be based on the selected candidate’s experience and qualifications.

Designs, builds, and maintains Excel/VBA-based case input tools that assemble and format the data required for routine Aspen PIMS and Aspen Petroleum Supply Chain Planner (PSCP) optimization model runs. Supports the full range of planning horizons and functions – near-term (0–30 days), short-term (30–120 days), and mid-term (120 days–5 years) planning, along with back casting (post audits) and cross-regional portfolio optimization. Extends and standardizes the established Aspen PIMS case input tool suite across all 13 refineries and four regions, closing gaps where current case-build functionality is inconsistent, manual, or not yet developed. Develops new case input tooling for mid-term planning, back casting, and cross-regional optimization—functions that are new or newly centralized within the Value Chain Optimization organization. Develops and maintains SQL queries and data pipelines that source, transform, and load data from enterprise systems into case input tools in the correct format. Engineers robust, low-maintenance, well-documented solutions, applying version control, error handling, and input validation to ensure the accuracy and repeatability of model inputs. Partners with the Near Term, Short Term, Mid Term, Continuous Improvement, and Cross Regional planning teams to gather requirements and translate them into scalable, maintainable tool designs. Provides day-to-day support, troubleshooting, and enhancements for case input tools used by planners across all regions. Proactively identifies opportunities to reduce manual effort, improve refresh reliability, and simplify end-user workflows across the case-build process. Documents tool logic, data sources, and standard operating procedures, and provide lightweight user guidance to drive consistent adoption.