Sales Analytics Intern

AWP Safety•North Canton, OH

1d•$27 - $32•Remote

About The Position

AWP Safety is North America’s leading traffic control and roadway safety services provider, protecting work zones with highly trained Protectors and innovative operational systems. We operate in a high-growth, multi-division environment where Sales and Operations alignment directly impacts customer delivery, crew deployment, headcount planning, and profitability. This internship will ideally be based in the Midwest or Northeast, with Pennsylvania a preferred location.

Requirements

Currently pursuing a Bachelor’s or Master’s degree in-- Business Analytics Data Analytics Finance Marketing Economics Supply Chain Operations Management
AI Tools such as Chat GPT and Claude
Advanced Excel (pivot tables, modeling, formulas; VBA a plus)
Experience with BI tools (Power BI, Tableau, or similar)
Familiarity with statistical analysis and forecasting concepts
Ability to structure datasets and clean/validate data
Understanding of sales pipelines and revenue forecasting
Interest in pricing strategy and margin modeling
Foundational knowledge of decision frameworks and structured problem solving
Ability to differentiate customer segmentation strategies (Enterprise vs. SMB)

Nice To Haves

Analytical mindset with strong attention to detail
Ability to translate data into business insights
Comfortable working cross-functionally with Sales and Operations leaders
Curiosity about field operations and service delivery economics
Strong communication and presentation skills

Responsibilities

Account mapping by end user and subcontractors
Assist in developing Total Demand models that include MQL, SQL, Retained demand, and job schedule intensity
Develop contribution margin analytics to project price and efficiency impacts
Identify capacity gaps driving crew mobilization, rentals, and other Cost of Sales metrics
Consolidate customer contracts into a dashboard for commercial use
Assist in constructing a deal desk
Assist in developing account level retention data
Create retention dashboards.
Growth and market share opportunity based on rate cases, federal funding programs, and competitive take-out
Build dashboards and models using tools such as Excel, Power BI, Tableau, or similar.
Cost of Sales modeling for assessing priceand Effective Rate impact
Manager’s dashboards measuring sales performance by resource account, and market
Manager’s console for exposure of daily sales, operational, and safety KPIs
Support enterprise-level initiatives tied to growth planning and profitability
Assist in scenario modeling for new market entry and territory expansion by researching and reporting on Construction and Traffic Control TAM
Contribute to continuous improvement growth and retention reporting