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
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)
Tech Stack
SQL
Tableau
VBA
Benefits
Remote flexibility available based on candidate location