What are the responsibilities and job description for the Estimator position at Short Partners LLC?
The Construction Estimator Data & Takeoff Analyst supports estimating, operations, and executive leadership by
converting construction plans, project data, and operational information into accurate material and labor
takeoffs and actionable business insights. This role combines blueprint interpretation with advanced
data analysis using Excel, Power Query, Pivot Tables, and Power BI to produce decision-ready reports.
Core Responsibilities:
- Analyze construction drawings and produce accurate material and labor takeoffs.
- Identify scope gaps, inconsistencies, and risk items within plans.
- Convert takeoff quantities into cost models for estimating teams.
- Build Excel data models using formulas, pivot tables, and Power Query.
- Develop Power BI dashboards to track operational and financial performance.
- Analyze job cost data to identify productivity trends and margin opportunities.
- Automate reporting workflows and improve data collection methods.
- Provide executive-level summaries for management review.
Key Performance Indicators (KPIs):
- Takeoff accuracy within ±3–5% variance from actual usage.
- Standard takeoff turnaround within 24–48 hours.
- Maintain greater than 99% reporting data accuracy.
- Reduce estimator manual takeoff time by 30–50%.
- Deliver monthly operational analytics reports.
- Improve reporting efficiency through automation.
Required Skills:
- Advanced Microsoft Excel (pivot tables, Power Query, formulas, data modeling).
- Power BI dashboard development and visualization.
- Blueprint and plan reading proficiency.
- Strong understanding of construction materials and labor productivity.
- Analytical thinking and data mining capability.
Salary : $90,000 - $110,000