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

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, EcoSys, Unifier, Primavera P6, Microsoft Project, or comparable systems.
• Experience designing ETL/ELT workflows, data pipelines, APIs, database integrations, or data warehouses.
• Familiarity with Power Apps and Power Automate.
• Experience with Python.
• Experience integrating cost, schedule, quantity, and productivity data for forecasting and performance analysis.
• Familiarity with data governance, master-data management, audit controls, and data-quality frameworks.
• Experience supporting large capital programs, multi-project portfolios, campuses, infrastructure, industrial, energy, data-center, or similarly complex construction environments.
• CCP, PMP, MRICS, or related professional certification.

Core Competencies

• Strong construction cost and commercial judgment.
• Advanced analytical thinking and structured problem-solving.
• Ability to bring clarity and consistency to complex, multi-source data environments.
• High ownership, sound prioritization, and comfort operating in a fast-moving environment.
• Collaborative communication across cost management, estimating, project controls, finance, operations, and technical teams.
• Commitment to accuracy, governance, confidentiality, and continuous improvement.

This is a full-time onsite role in Nashville, TN.

Qualifications

Disclaimer:

Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from: $90,100 to $209,500 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:

• Medical, dental, and vision insurance, including expert medical opinion
• Short term disability and long term disability
• Life insurance and AD&D
• Supplemental life insurance (Employee/Spouse/Child)
• Health care and dependent care Flexible Spending Accounts
• Pre-tax commuter and parking benefits
• 401(k) Savings and Investment Plan with company match
• Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
• 11 paid holidays
• Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
• Paid parental leave
• Adoption assistance
• Employee Stock Purchase Plan
• Financial planning and group legal
• Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

…