Senior Construction Cost Analyst - SQL & Data Modeling; Nashville, TN

Position: Senior Construction Cost Analyst - SQL & Data Modeling (Nashville, TN)
** Job Description*
* The Global Program Controls organization provides governance, reporting, controls processes, cost management support, and portfolio visibility to help Oracle Cloud Infrastructure deliver global data center programs with greater consistency, transparency, and execution discipline.

We are seeking a senior construction cost professional with expert SQL and data-modeling capabilities to build and manage a trusted source of truth for cost information.

This role will bring together cost management, estimating, project controls, financial, and operational data from Horizon, Apex, and other internal systems. The successful candidate will turn fragmented source data into consistent, governed, decision-ready information-enabling better forecasting, benchmarking, and leadership reporting.

You will be a close partner to cost management, estimating, project controls, finance, and operations.

Core Responsibilities

+ Lead the collection, reconciliation, and modeling of construction cost data from Horizon, Apex, ERP systems, estimating platforms, project controls tools, spreadsheets, and other data sources.

+ Use SQL to extract, transform, validate, and analyze data across multiple systems and databases.

+ Design and maintain the core cost data model, including project, cost code, estimate, budget, commitment, change order, invoice, actual cost, forecast, labor, material, equipment, and subcontractor relationships.

+ Establish and maintain a governed, centralized source of truth for cost reporting and analysis.

+ Build and manage unit-rate databases using historical cost, productivity, quantity, labor, equipment, material, and subcontractor data.

+ Standardize cost-code mappings, WBS/CBS structures, reference data, reporting definitions, and calculation logic across projects and systems.

+ Develop reusable SQL views, stored procedures, validation routines, and reporting datasets that reduce manual reporting effort.

+ Identify, investigate, and resolve data-quality issues, including incomplete records, inconsistent classifications, duplicate values, and conflicting source information.

+ Partner with cost management and project controls teams to improve estimate-to-budget, budget-to-actual, forecast, change-control, and cost-to-complete reporting.

+ Produce clear analyses and executive-ready reports that communicate cost performance, trends, risks, and opportunities.

+ Document data sources, model relationships, transformation logic, business rules, and ownership to support sustainable use and governance.

+ Support Power Apps and Power Automate solutions that improve data collection, workflow, and control processes.

** Responsibilities*
* ** Required Qualifications*
* + Bachelor's degree in Data Analytics, Computer Science, Information Systems, Finance, Engineering, or a related field; equivalent relevant experience will be considered.

+ 8+ years of experience in construction cost management, cost controls, estimating, project controls, or construction data analytics.

+ Expert-level SQL proficiency, including complex joins, CTEs, subqueries, window functions, aggregations, data reconciliation, and data-validation logic.

+ Strong experience designing relational and dimensional data models, including keys, relationships, normalization, fact tables, dimension tables, and reporting-ready data structures.

+ Experience working with construction estimates, budgets, commitments, purchase orders, change orders, invoices, actual costs, forecasts, unit rates, productivity, and cost codes.

+ Working knowledge of Oracle Primavera Unifier, Horizon and Apex, including their data structures, reporting capabilities, and integration considerations.

+ Ability to reconcile data across multiple operational and financial source systems and establish clear business definitions.

+ Advanced Excel skills and the ability to turn complex analysis into clear, executive-ready reporting.

+ Strong judgment, attention to detail, communication skills, and comfort working across technical and non-technical teams.

** Preferred Qualifications*
* + Experience building and maintaining unit-rate libraries, historical-cost databases, estimating benchmarks, or productivity databases.

+

Experience with cost systems, project controls tools, and ERP platforms such as Oracle ERP, SAP, Eco Sys, Unifier, Primavera P6, Microsoft Project, or comparable systems.

+ Experience designing ETL/ELT workflows, data pipelines, APIs, database integrations, or data warehouses.

+ Familiarity with Power…