Sales Analytics Intern
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. Sales Planning Analytics 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 Pricing & Contract Management Consolidate customer contracts into a dashboard for commercial use Assist in constructing a deal desk Customer Segment Analysis 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 Data Modeling & Visualization 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 Decision Support & Strategic Projects 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
Requirements
- Currently pursuing a Bachelor’s or Master’s degree in Business Analytics, Data Analytics, Finance, Marketing, Economics, Supply Chain, or 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Intern
