Job Description

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

Qualifications

Education

• Currently pursuing a Bachelor’s or Master’s degree in--
  • Business Analytics
  • Data Analytics
  • Finance
  • Marketing
  • Economics
  • Supply Chain
  • Operations Management

Technical Skills

• 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

Business Competencies

• 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)

Preferred Attributes

• 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

Additional Information

• Full‑time, temporary internship
• Non‑benefits eligible
• Compensation: $27-32/hour based on location
• Remote flexibility available based on candidate location

What the Intern Will Gain

• Exposure to enterprise-level Sales & Operations Planning (S&OP) processes
• Hands-on experience in pricing and revenue modeling
• Real-world forecasting tied to workforce and crew deployment
• Experience differentiating enterprise vs. SMB customer strategies
• Direct interaction with Sales leadership and operational stakeholders

AWP Safety is an Equal Opportunity Employer (EOE). Women, minorities, veterans, and individuals with disabilities are encouraged to apply. Qualified applicants will receive consideration for employment without regard to their race, color, age, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.