Position SummaryDo 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.
Key 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.
Minimum QualificationsSenior 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.
Preferred Qualifications- 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.
Skills- Adaptability: Maintaining effectiveness when experiencing major changes in work responsibilities or environment; adjusting effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful.
- Business Partnerships: Acting as a trusted advisor and building strong relationships with colleagues and the business to drive business performance.
- Communication: Speaking and writing effectively; demonstrating fundamental command of language; communicating well using all mediums.
- Critical Thinking: Identifying and understanding issues, problems and opportunities; using data analysis to draw conclusions; using judgment in choosing a course of action; intellectually curious.
- Customer-Focused: Ensuring that the internal or external customer's perspective is a driving force behind strategic priorities, business decisions, organizational processes, and individual activities; crafting and implementing service practices that meet customers' and own organization's needs; promoting and operationalizing customer service as a value.
- Data Analysis: Identifying, evaluating, interpreting and organizing data so that it can be used for business decisions; sorting through data to identify patterns and establish relationships.
- Data Operations: Managing, manipulating, and analyzing data throughout its lifecycle; deriving meaningful insights and supporting decision-making through the collection, storage, retrieval, transformation, and visualization of data.
- Digital Transformation: Adopting digital technology to transform services or businesses through replacing non-digital or manual processes with digital processes or replacing older digital technology with newer digital technology.
- Work Management: Take ownership of actions and behaviors. Effectively managing one's time and resources to ensure that work is completed efficiently. Time management is the process of planning and exercising conscious control of time spent on specific activities, especially to increase effectiveness, efficiency, and productivity. Using time effectively gives the person the ability to choose how to spend or manage activities at their own time and expediency.
Location:
Findlay, Ohio
Additional locations:
Houston, Texas, San Antonio, Texas
Job Requisition ID:
Location Address:
539 S Main St
Education:
Bachelors (Required)
Employee Group:
Full time
Employee Subgroup:
Regular
