SMU CAP Program - Intern
Sunoco LP is the largest fuel distributor in the United States. We take great pride in our history of innovation, heritage of quality, customer-first philosophy, and ever-growing network of partners.
Project Title: Fuel Margin Analysis Modeling for 500 Sunoco Gas Stations
Project Details: Build an Excel model with current and historical Sales and Cost of Sales data for each fuel grade at 500 Sunoco Gas Stations. Project will require:
· Extracting Sales and Cost of Sales data from SAP.
· Organizing data by store location, grade of fuel, sales, cost of sales.
· Calculating margin (cents per gallon) and compare to previous months.
· Analyzing to identify anomalies based in trend data to determine whether sales or cost of sales is outside of normal parameters.
Bonus Opportunity: build dashboard in Power BI to display data for all 500 locations.
· Duration: March 2022 - May 2022
· Up to 10 hours per week
Required Skills (External)
Requirements:
Education and/or Experience, Knowledge, Skills & Abilities:
- Currently an undergraduate student
- Preferably majoring in Accounting or a related major
- Expected graduation date of May 2026 or May 2027
- Minimum cumulative GPA of 3.5
- Detail-oriented and strong analytical skills
- Proficient in use of Excel, and interest in further expanding Excel skills
Working Conditions:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
1. Usually, normal office working conditions.
2. Must be able to remain in a stationary position 50% of the time due to prolonged periods of sitting or standing.
An equal opportunity employer/disability/vet
Sunoco is an equal opportunity employer and does not discriminate against qualified applicants on the basis of any actual or perceived legally protected characteristics under federal, state, or local law.
The nature and frequency of the above working conditions and requirements may vary depending on individual operational circumstances. Where feasible, the Partnership will make reasonable accommodations to qualified individuals with disabilities to enable them to perform the essential functions of the job.
DISCLAIMER: The statements listed in this job posting, which are subject to change, are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of personnel so classified.