Senior Construction Cost Analyst – SQL & Data Modeling (Nashville, TN)

Ll Oefentherapie; Olympia (WA); On-site; USD 120,000 - 190,000; Full time

Job summary

Oracle Cloud Infrastructure seeks a senior construction cost professional to lead the integration of cost data from Horizon, Apex, ERP systems, and estimating platforms. You will design a centralized cost data model, establish a governed source of truth, and enable reliable forecasting and leadership reporting.

You will partner with cost management, project controls, finance, and operations to improve estimate-to-budget and cost-to-complete reporting, and you will develop reusable SQL views and

Qualifications

• Senior construction cost professional with expert SQL and data-modeling capabilities.
• Ability to consolidate data from multiple systems into a single source of truth.
• Experience delivering executive-ready cost analyses and reports.

Responsibilities

• Lead the collection, reconciliation, and modeling of construction cost data from Horizon, Apex, ERP systems, estimating platforms, spreadsheets, and other 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 governance.
• Support Power Apps and Power Automate solutions that improve data collection, workflow, and control processes.

Skills

SQL

Data modeling

Cost governance

Data integration

Tools

Horizon

Apex

ERP systems

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.