Cost Analyst

Project Cost AnalystClayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $8.1 billion in revenue for 2025, Clayco specializes in the "art and science of building," providing fast track, efficient solutions for mission critical, industrial, life sciences, power & energy, aviation, commercial, institutional, residential and sports & entertainment related building projects.The Specifics of the RoleUnderstand how large warehouse datasets map to what's actually happening on a job, and navigate them without hand-holdingMaintain the data pipeline feeding standing reports and Excel deliverables, keeping them accurate as source systems and business processes changeTroubleshoot and fix Excel formulas and SQL queries when they break — which in construction is often, because the work and the org structure keep movingLead or advise data engineering on changing reporting and data needs, translating cost-side requirements into something engineering can buildDevelop and deploy ad hoc reporting for project teams, from request through deliveryRequirements4+ years construction industry experience, including time on active project sitesHands-on cost control, cost management, or estimating experience on commercial/industrial projectsB.S. in Engineering, Construction Management, or a related technical fieldWorking SQL — able to read, write, and debug queries against a warehouseDemonstrated Excel automation or report development work (Power BI, Tableau) — the résumé should name specific tools built, not just "proficient in Excel"Advanced Excel: complex formulas, pivot tables, large-dataset modelingStrongly PreferredPower Query / Power Automate named explicitly on the résuméBI and semantic modeling experience: Power BI, SSAS, or Tableau. Power BI is the more transferrable of the skills given our usage of Power Query.Nice to HavePythonSnowflake or other cloud data warehouseVBA / Office ScriptsProcore, PMWeb, or JD EdwardsMBAAny other programming experienceSome Things You Should KnowOur clients and projects are nationwide – Travel will be required.No other builder can offer the collaborative design-build approach that Clayco does.We work on creative, complex, award-winning, high-profile jobs.The pace is fast!This position is classified as a safety-sensitive role in accordance with applicable state and federal laws. Candidates selected for this position will be subject to a comprehensive background check, which includes mandatory drug testingWhy Clayco?2025 Best Places to Work – St. Louis Business Journal, Los Angeles Business Journal, and Phoenix Business Journal.2025 ENR Top 400 – Top Data Center Contractor (Top 3).2025 ENR Top 100 Design-Build Firms – Design-Build Contractor (Top 5).2025 ENR Top 100 Green Contractors – Green Contractor (Top 3).BenefitsDiscretionary Annual Bonus: Subject to company and individual performance.Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more!CompensationThe salary range for this position considers a wide range of factors in making compensation decisions including but not limited to: Education, qualifications, skills, training, experience, certifications, internal equity, and location. Compensation decisions are dependent on the facts and circumstances of each case