Analyst - Commercial Analytics

Sunoco

  • Newtown Square, PA
  • Permanent
  • Full-time
  • 17 days ago
Sunoco LP is a leading energy infrastructure and fuel distribution master limited partnership operating across 47 U.S. states, Puerto Rico, Europe, and Mexico. The Partnership's midstream operations include an extensive network of approximately 9,500 miles of pipeline and over 100 terminals. This critical infrastructure complements the Partnership's fuel distribution operations, which serve approximately 10,000 convenience stores, independent dealers, commercial customers, and distributors.At Sunoco, we take great pride in what we do and wholeheartedly believe our employees drive success for our company and our customers. We are always looking for the best and brightest talent and we are committed to making your job a challenging and rewarding experience.SummaryThe Commercial Analytics team is part of the Unbranded Sales & Pricing organization and is responsible for providing the data and analysis needed to support the rest of the organization and drive continued growth. The position requires an individual with technical proficiency, strong communication skills, and a desire to learn the fuel distribution business.The role reports to the Manager of Commercial Analytics. This role is an excellent opportunity to learn and develop in a fast-paced environment.Responsibilities:The analyst will support existing analytical tools and dashboards and develop new solutions that provide insights into existing business processes (e.g., hedge exposure management, sales forecasting, financial transparency, etc.) and support new business growth. This position requires effective use of Sunoco's core technology programs including: Right Angle, DTN TABs, Excel, scripting languages (i.e., R & Python), and SQL / relational database management system (RBDMS) infrastructure.The role will work with various internal groups including:
  • Senior Leadership on financial reporting and growth initiatives
  • Sales Reps to support all functions of the sales process
  • Rack Pricing to build and support technical tools
  • Supply & Trading to understand cost structure and market dynamics
  • Other Analytics groups to align processes & best practices
  • Others may include Midstream, Supply Optimization, etc.
  • Design new processes and systems to improve efficiency and data accuracy
  • Provide backup support & coverage for other Commercial Analysts when they are out of the office
Ad Hoc requests as determined by the Manager of Unbranded Sales AnalyticsEssential Requirements:Experience, Educational & Special Training Required
  • Bachelor's Degree
  • 5+ years technical experience desired.
Microsoft Office Suite skills required (Word, Excel, PowerPoint & Outlook)Proficiency in one or more scripting languages (e.g. R, Python)Proficiency in SQL, including building and debugging queriesStrong Data Mining skills including Data Cleaning, Data Preparation and Data VisualizationStrong technical, analytical, and problem solving skillsPredictive modeling skills in machine learning techniques (e.g., linear regression, decision trees, random forests, gradient boosting, neural networks)Strong eagerness to learn the business while developing technically in data scienceFamiliarity with scripting languages and SQL requiredGood presentation and formal proposal skills
  • Handles complex projects with little supervision.
  • Strong communication skills and the ability to partner with internal stakeholders to
Strong work ethic and drivePreferred Skills & CharacteristicsFamiliarity with Frameworks for code-based business intelligence tools such as R-Shiny, Dash etc.Familiarity with API Data requestsFamiliarity with Power BI, Tableau, Qlik etc.Experience building and debugging Excel MacrosKnowledge of the Software Development Life Cycle (SDLC) including Azure DevOps Boards, Source Control (Git) and collaborationExperience with ETL/ELT and Data WarehousingRequired experience is commensurate with the selected job level:
  • The Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 2-5 years of relevant job related experience
  • The Senior Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 5-8 years of relevant job related experience
  • The Lead Specialist/Analyst level requires a Bachelor's degree or equivalent experience and 8+ years of relevant job related experience
Working Conditions:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
  • Usually, normal office working conditions.
  • Must be able to remain in a stationary position 50% of the time due to prolonged periods of sitting or standing.
  • Occasional overnight travel may be required.
  • Occasional visits to industrial/manufacturing settings, which may include exposure to various materials and chemicals, as well as extreme temperature conditions and loud machinery, and require appropriate personal protective equipment.

Sunoco