Onsite Denver Logistics Analytics Intern - Power BI & Excel

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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, Logistics Analyst - Summer 2027
Intern, Logistics Analyst - Summer 2027

Mansfield Oil Company • Denver (CO)

On-site
USD 24,000 - 34,000
Paid day for non-profit work
Financial Wellness Program
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
Houston Supply Chain Intern: Data Analytics & Logistics
Houston Supply Chain Intern: Data Analytics & Logistics

Mansfield Oil Company • Houston (TX)

On-site
USD 22,000 - 31,000
Paid internship
Onsite role
Operations & Process Improvement Intern (Power BI)
Operations & Process Improvement Intern (Power BI)

Mansfield Oil Company • Gainesville (GA)

On-site
USD 24,000 - 34,000
Supply Analytics Intern – Fuel Logistics (Onsite Houston)
Supply Analytics Intern – Fuel Logistics (Onsite Houston)

Mansfield-Energy-3 • Houston (TX)

On-site
USD 22,000 - 31,000
Paid internship
Onsite in Houston, TX
Supply Chain Analytics Intern - Onsite in Midland, TX
Supply Chain Analytics Intern - Onsite in Midland, TX

Propetro • United States

On-site
USD 25,000 - 39,000
Supply Chain Analytics Intern - Power BI & SQL
Supply Chain Analytics Intern - Power BI & SQL

Propetro • Midland (TX)

On-site
USD 25,000 - 30,000
Energy Market Analytics Intern: Data-Driven Insight
Energy Market Analytics Intern: Data-Driven Insight

East Daley Analytics • Greenwood Village (CO)

On-site
USD 23,000 - 32,000
BI Internship: Power BI, SQL & Excel – On-Site Oshkosh
BI Internship: Power BI, SQL & Excel – On-Site Oshkosh

Amcor Limited • Appleton (WI), Oshkosh (WI), Neenah (WI)

On-site
USD 25,000 - 30,000