Construction Cost & Data Analytics Specialist

Clayco; St. Louis, Northern (MO, KY); Hybrid; USD 85,000 - 115,000; Full time

Benefits offered by this job

Discretionary annual bonus

Medical, dental & vision plans

401(k)

Paid time off & holidays

Job summary

Clayco is seeking a Project Cost Analyst to oversee job costs, budgets, and forecasting with a blend of cost engineering and data analysis. You will maintain data pipelines, automate reports, and work with Excel and SQL in a fast-paced construction environment on nationwide projects.

The role requires hands-on cost control experience on commercial/industrial projects, university-level engineering or construction management education, and travel to project sites as needed.

Qualifications

• 4+ years construction industry experience including time on active project sites.
• Hands-on cost control, cost management, or estimating experience on commercial/industrial projects.
• B.S. in Engineering, Construction Management, or a related technical field.
• Working SQL - able to read, write, and debug queries against a warehouse.
• Demonstrated Excel automation or report development (Power BI, Tableau).
• Advanced Excel: complex formulas, pivot tables, large-dataset modeling.

Responsibilities

• Understand how large warehouse datasets map to what's actually happening on a job, and navigate them without hand-holding.
• Maintain the data pipeline feeding standing reports and Excel deliverables, keeping them accurate as source systems and business processes change.
• Troubleshoot and fix Excel formulas and SQL queries when they break - which in construction is often, because the work and the org structure keep moving.
• Lead or advise data engineering on changing reporting and data needs, translating cost-side requirements into something engineering can build.
• Develop and deploy ad hoc reporting for project teams, from request through delivery.

Skills

Construction cost control

SQL queries

Advanced Excel

Power BI

Tableau

Excel automation

Data analysis

Education

B.S. in Engineering/Construction Management

Tools

SQL

Power BI

Tableau

Power Query

Excel

Job description

Clayco is seeking a Project Cost Analyst to oversee job costs, budgets, and forecasting with a blend of cost engineering and data analysis. You will maintain data pipelines, automate reports, and work with Excel and SQL in a fast-paced construction environment on nationwide projects.

The role requires hands-on cost control experience on commercial/industrial projects, university-level engineering or construction management education, and travel to project sites as needed.