Senior/Lead Business Analyst

Marathon Petroleum Corporation•Findlay, OH

1d•Onsite

About The Position

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. Position 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.

Requirements

Senior Business Analyst Bachelor’s Degree required, with a preference in Business, Engineering, Computer Science, Information Systems, Mathematics, or related. Four (4) years of experience required.
Lead Business Analyst Bachelor’s Degree required, with a preference in Business, Engineering, Computer Science, Information Systems, Mathematics, or related. Six (6) years of experience required.

Nice To Haves

Expert-level skills in building complex, maintainable, automated tools for production business processes, demonstrated through Microsoft Excel and VBA or equivalent technologies (e.g., Python, SQL/database automation, or other scripting and application-development platforms).
Strong SQL skills, including writing and tuning queries against relational databases (e.g., SQL Server) to extract and shape large, multi-table datasets.
Hands-on data pipeline and ETL experience—sourcing, transforming, validating, and loading data from multiple enterprise systems into standardized formats.
Demonstrated ability to design standardized, robust, low-maintenance tooling and templates that are scalable and easy for non-technical users to operate.
Familiarity with linear programming, DPO, or refinery optimization models (e.g., Aspen PIMS, PIMS-AO, XPIMS, Aspen Petroleum Supply Chain Planner) and the data structures they require.
Exposure to refinery or value-chain planning processes such as near-term, short-term, mid-term, back casting, or cross-regional optimization.
Experience manipulating and analyzing complex, high-volume, high-dimensional data from varying sources.
Working knowledge of Power Query, Power BI, Python, or other data-transformation and automation tools.
Proven ability to think critically and solve problems given incomplete information and/or ambiguous requirements, delivering results at varying levels of precision.
Strong documentation habits and a collaborative approach to supporting business users.

Responsibilities

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.
Coordinates with modeling and interpretation colleagues so that case input tools evolve in tandem with the downstream optimization and interpretation workstreams the team supports.