Sales Analytics Intern
Location
Ohio
Posted
10 hours ago
Salary
$27 - $32 / hour
Bachelor DegreeEnglishSQLTableauVBA
Job Description
• 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 developing account level retention data
• Create retention dashboards 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
• 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
Job Requirements
- Currently pursuing a Bachelor’s or Master’s degree in Business Analytics, Data Analytics, Finance, Marketing, Economics, or 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)
Benefits
- Remote flexibility available based on candidate location