Cost Analyst
Role Overview
Project Cost Analyst role combining construction cost-control knowledge with data reporting and automation.
The role is neither a pure data analyst nor a pure cost engineer position.
Key Skills for This Role
Full Job Posting
About Clayco
Clayco is a full-service real estate development, planning, architecture, engineering, and construction firm delivering projects across North America.
The company works on mission-critical, industrial, life sciences, power and energy, aviation, commercial, institutional, residential, and sports and entertainment projects.
Role overview
Project Cost Analyst role combining construction cost-control knowledge with data reporting and automation.
The role is neither a pure data analyst nor a pure cost engineer position.
Responsibilities
- Map large warehouse datasets to real project activity and navigate data independently.
- Maintain data pipelines for recurring reports and Excel deliverables as source systems and processes change.
- Troubleshoot and fix Excel formulas and SQL queries.
- Translate cost-side reporting needs for data engineering teams.
- Develop and deliver ad hoc reports for project teams from request through delivery.
- Travel to nationwide clients and projects as required.
Required qualifications
- 4+ years of construction experience, including active project-site experience.
- Hands-on cost control, cost management, or estimating on commercial or industrial projects.
- B.S. in Engineering, Construction Management, or a related technical field.
- Working SQL skills to read, write, and debug warehouse queries.
- Demonstrated Excel automation or report development with specific tools built.
- Advanced Excel: complex formulas, pivot tables, and large-dataset modeling.
Preferred qualifications
- Power Query or Power Automate experience; BI and semantic modeling with Power BI, SSAS, or Tableau.
- Python, Snowflake or another cloud data warehouse, VBA or Office Scripts, Procore, PMWeb, JD Edwards, an MBA, or other programming experience.
Workplace and role conditions
- Travel is required because clients and projects are nationwide.
- The position is classified as safety-sensitive; selected candidates are subject to a background check and mandatory drug testing.
Benefits
- The posting lists a discretionary annual bonus subject to company and individual performance.
- Benefits include medical, dental, and vision plans, 401(k), PTO, paid holidays, employee assistance, flexible spending accounts, life insurance, disability coverage, and learning and development programs.
Compensation
- The posting describes a salary range determined by factors such as education, qualifications, skills, training, experience, certifications, internal equity, and location; it does not state an amount.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career