Intern, Logistics Analyst - Summer 2027

Mansfield Oil Company

Denver (CO)

On-site

USD 24,000 - 34,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Paid day for non-profit work
Financial Wellness Program

Job summary

Mansfield Oil Company seeks a Logistics Analyst Internship to provide hands-on business management education while performing logistics analysis, profit analysis, and project management. The role offers exposure to DEF logistics, data systems, and ERP use, with learning outcomes in Power BI, Copilot, and supply chain analytics. Denver-based, onsite, paid internship.

Dates May 24, 2027 – August 6, 2027. $21/hour, full-time.

Qualifications

  • Must be a current or upcoming Junior or Senior pursuing a Bachelor's Degree.
  • Advanced proficiency in Microsoft Excel (pivot tables & lookups required).
  • Proficiency in Power BI, SQL, Python, or other coding for queries is highly desired.
  • Excellent analytical skills and ability to quickly understand and resolve issues.

Responsibilities

  • Compile and analyze information using proprietary data systems to create and present reports for leadership.
  • Maintain and update data on account ownership and investigate cost discrepancies between quoted and delivered gallons.
  • Provide progress updates on key projects.
  • Analyze delivery data to identify cost savings by converting buyback to route shipments.
  • Coordinate logistics for team learning events.
  • Analyze unprofitable business and recommend improvements.

Skills

Advanced Excel
Pivot Tables
Lookups
Power BI
SQL
Python
R Series
Analytical skills

Education

Bachelor's degree in progress

Tools

Entinuum
Copilot systems

Job description

The goal of the Logistics Analyst Internship is to provide a well-rounded business management education to the intern. Intern will perform value-added activities for Mansfield while learning critical operational skills including logistics analysis, profit analysis, and project management.

In addition to learning sound business management skills, which are transferable to any future career, the intern will acquire a working knowledge of Mansfield's industry position in DEF (Diesel Exhaust Fluid), key supply partners, and customers.

Monthly Activities
  • Use proprietary data systems to compile and analyze information in order to create and present reports for use by business leadership
  • Maintain and update data on account ownership and investigate cost discrepancies on quoted vs. delivered gallons.
  • Provide progress updates on key projects
Key Projects
  • Analyze delivery data to identify cost savings by converting buyback to route shipments
  • Coordinate logistics for a team learning event
  • Analyze unprofitable business and recommend changes for improvement.
  • Deep dive analysis into carrier freight rates and discrepancies versus quoted and delivered amounts. This includes delivered routes, dry run fee's.
  • Create a long term system for tracking and comparing these discrepancies for future MOC use
  • Deep dive project on Entinuum source auditing to ensure up to date sourcing and terminal information is used
Key Learning Outcomes / Development Opportunities
  • Develop working knowledge of Microsoft Power BI and Copilot systems
  • Proficiency using Entinuum (proprietary ERP system)
  • Understand DEF & Logistics Industry
  • Enhance communication skills (written, verbal and presentation)
  • Develop skills to present completed work in a concise and knowledgeable presentation that conveys what was accomplished
Requirements
  • Must be a current or an upcoming Junior or Senior pursuing a Bachelor's Degree.
  • Advanced Proficiency in Microsoft Excel (usage of Pivot Tables and Lookups required)
  • Proficiency in Power BI, R Series, SQL, Python, or other coding for queries is highly desired
  • Excellent analytical skills, ability to quickly understand, isolate and resolve issues.
Internship Details:
  • General:Full-time, onsite paid internship ($21/hour)
  • Dates: May 24,2027 through August 6,2027 (Required)
  • Location:Denver, CO
  • Benefits: 1 Paid day to work at a non-profit organization, Financial Wellness Program

This position will remain open until filled.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Intern, Logistics Analyst - Summer 2027
Intern, Logistics Analyst - Summer 2027

Mansfield-Energy-3 • Denver (CO)

On-site
USD 24,000 - 34,000
Paid day for nonprofit volunteering
Financial Wellness Program
On-site internship
Intern, Business Operations / Process Improvement - Summer 2027
Intern, Business Operations / Process Improvement - Summer 2027

Mansfield Energy Corp • Gainesville (GA)

On-site
USD 25,000 - 33,000
Logistics Data Analytics Intern
Logistics Data Analytics Intern

Mansfield-Energy-3 • Denver (CO)

On-site
USD 24,000 - 34,000
Paid day for nonprofit volunteering
Financial Wellness Program
On-site internship
Intern, Business Operations / Process Improvement - Summer 2027
Intern, Business Operations / Process Improvement - Summer 2027

Mansfield Oil Company • Gainesville (GA)

On-site
USD 24,000 - 34,000
Intern, Supply Analyst - Summer 2027
Intern, Supply Analyst - Summer 2027

Mansfield Oil Company • Houston (TX)

On-site
USD 22,000 - 31,000
Paid internship
Onsite role
Onsite Denver Logistics Analytics Intern - Power BI & Excel
Onsite Denver Logistics Analytics Intern - Power BI & Excel

Mansfield Oil Company • Denver (CO)

On-site
USD 24,000 - 34,000
Paid day for non-profit work
Financial Wellness Program
Intern, Supply Analyst - Summer 2027
Intern, Supply Analyst - Summer 2027

Mansfield-Energy-3 • Houston (TX)

On-site
USD 22,000 - 31,000
Paid internship
Onsite in Houston, TX
Intern, Accounting
Intern, Accounting

Mansfield Energy Corp • Houston (TX)

On-site
USD 25,000 - 33,000
Paid internship
Intern, Accounting
Intern, Accounting

Mansfield Energy Corp. • Houston (TX)

On-site
USD 25,000 - 30,000
Paid internship
Onsite in Houston
Full-time in-office role
Intern - Credit Analyst - Summer 2027
Intern - Credit Analyst - Summer 2027

Mansfield Oil Company • Gainesville (GA)

On-site
USD 22,000 - 30,000
Paid internship