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 informationenabling 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

• Bachelors 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: $90100 to $209500 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 Oracles 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:
1. Medical dental and vision insurance including expert medical opinion
2. Short term disability and long term disability
3. Life insurance and AD&D
4. Supplemental life insurance (Employee/Spouse/Child)
5. Health care and dependent care Flexible Spending Accounts
6. Pre-tax commuter and parking benefits
7. 401(k) Savings and Investment Plan with company match
8. 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.
9. 11 paid holidays
10. 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.
11. Paid parental leave
12. Adoption assistance
13. Employee Stock Purchase Plan
14. Financial planning and group legal
15. 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.
As part of Oracles onboarding process and consistent with applicable law US-based employees are required to complete identity verification which involves the collection and processing of their biometric information. Accommodations to this requirement may be granted following an individualized assessment.