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

Ll Oefentherapie; Nashville (TN); On-site; USD 120,000 - 180,000; Full time

Job summary

Oracle is seeking a senior construction cost professional to lead the integration and governance of cost data for Oracle Cloud Infrastructure's global programs. You will work with Horizon, Apex, ERP systems, and other platforms to turn fragmented data into trusted, decision-ready information.

You will collaborate with cost management, estimating, project controls, finance, and operations to improve forecasting, benchmarking, and leadership reporting through robust SQL-based data models and

Qualifications

• Senior cost professional with expert SQL and data-modeling capabilities.
• Experience collecting, reconciling, and modeling construction cost data across multiple systems.
• Ability to design and maintain a governed core cost data model and centralized reporting.

Responsibilities

• Lead collection, reconciliation, and modeling of construction cost data from Horizon, Apex, ERP systems, and other sources.
• Use SQL to extract, transform, validate, and analyze data across systems.
• Establish a centralized source of truth for cost reporting and analysis.

Skills

SQL

Data modeling

Cost management

Data integration

Data analysis

Tools

Power Apps

Power Automate

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.