Construction Cost Intelligence Analyst

Clayco; St. Louis (MO); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Discretionary annual bonus

Comprehensive benefits

Job summary

Clayco is seeking a Project Cost Analyst to bridge cost control and data analysis across large warehouse projects. You will interpret job costs, budgets, and forecasting, while building tools to automate reporting and improve accuracy across reports and Excel deliverables.

The role requires active field/site exposure, hands-on cost management experience, and strong SQL/Excel capabilities. Expect travel with client nationwide projects and a fast-paced environment.

Qualifications

• 4+ years in construction with active site exposure.
• Hands-on cost control or estimating on commercial/industrial projects.
• B.S. in Engineering, Construction Management, or related technical field.
• Working SQL—read, write, and debug queries against a warehouse.
• Demonstrated Excel automation or reporting (Power BI/Tableau) with concrete tools named on résumé.
• Advanced Excel with complex formulas and large dataset modeling.

Responsibilities

• Understand how large warehouse datasets map to project realities.
• Maintain data pipeline feeding reports and Excel deliverables.
• Troubleshoot and fix Excel formulas and SQL queries.
• Lead or advise data engineering on reporting needs.
• Develop and deploy ad hoc reporting for project teams.

Skills

4+ years construction experience

Cost control / estimating

Advanced Excel

SQL read/write

Education

B.S. in Engineering / Construction Management / related field

Tools

SQL

Power BI

Tableau

Power Query

Power Automate

SSAS

Snowflake

Job description

Clayco is seeking a Project Cost Analyst to bridge cost control and data analysis across large warehouse projects. You will interpret job costs, budgets, and forecasting, while building tools to automate reporting and improve accuracy across reports and Excel deliverables.

The role requires active field/site exposure, hands-on cost management experience, and strong SQL/Excel capabilities. Expect travel with client nationwide projects and a fast-paced environment.