Construction Cost Data Architect - SQL & Modeling

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

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