Strategic Project Cost Analytics & Reporting Manager

Homer City Redevelopment LLC; Pittsburgh (Allegheny County); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive Salary

Medical, dental, and vision insurance

401(k) plan with company match

Paid time off

Professional development support

Career growth opportunities

Job summary

Homer City Redevelopment LLC seeks a highly analytical Project Cost Analytics & Reporting Manager to lead cost data analysis, ensure cost coding integrity in ERP, and build reporting tools for management.

You will analyze large datasets, maintain project master data, develop Power BI dashboards, support EAC and budget forecasting, and collaborate with Accounting, Procurement, and Project Management to improve financial reporting.

Qualifications

• Bachelor's degree in Finance, Accounting, Data Analytics, or related field.
• 5+ years in project cost analytics, controls, financial analysis, or construction cost management.
• Advanced Microsoft Excel skills, including Power Query, Pivot Tables, and large dataset analysis.
• Experience working with ERP systems such as NetSuite, Oracle, SAP, JD Edwards, or similar platforms.
• Strong experience with Power BI or comparable business intelligence tools.
• Demonstrated ability to analyze and reconcile large volumes of transactional data.
• Excellent analytical, problem‑solving, and communication skills.

Responsibilities

• Analyze large transaction datasets to determine proper project, task, cost code, and purchase order assignments.
• Review invoices, commitments, purchase orders, change orders, and accounting transactions for coding accuracy.
• Identify transactions assigned to incorrect projects, budgets, vendors, or cost categories.
• Investigate cost anomalies, duplicate charges, budget exceptions, and coding inconsistencies.
• Develop recommendations for reallocating costs between projects and cost structures.
• Create repeatable business rules for transaction classification and project cost assignment.
• Execute approved project cost corrections within NetSuite and associated systems.
• Update project assignments, cost codes, tasks, and purchase orders as needed.
• Maintain project master data to ensure consistency and reporting accuracy.
• Support ongoing cleanup and optimization efforts related to project financial data.
• Monitor compliance with project coding standards and recommend corrective actions.
• Develop and maintain a centralized project cost tracking database.
• Consolidate actual costs, commitments, purchase orders, change orders, and forecasts into a single reporting framework.
• Create reconciliations between project controls systems and ERP data.
• Maintain detailed audit trails supporting all transaction corrections and reallocations.
• Support estimate‑at‑completion and budget forecasting activities.
• Design and maintain Power BI dashboards and management reports.
• Develop reporting for: Budget vs. Actual Performance, Project Spend Trends, Commitment Tracking, Change Order Tracking, EAC, Cost Variance Analysis.
• Automate recurring reporting processes where possible.
• Develop executive‑level reporting packages and KPI scorecards.
• Identify project cost trends and emerging risks.
• Support project leadership with budget forecasting and variance analysis.
• Conduct root‑cause analysis of cost overruns and project budget exceptions.
• Provide recommendations to improve project cost visibility and decision‑making.
• Develop and document project coding standards and procedures.
• Create automated exception reporting and validation controls.
• Recommend process improvements to improve data quality and reporting efficiency.
• Partner with Accounting, Procurement, Project Controls, and Project Management teams to improve project financial reporting processes.

Skills

Advanced Excel

Power BI

Data analysis

ERP systems

SQL

Communication

Problem solving

Education

Bachelor's degree in Finance, Accounting, Data Analytics, Engineering, Construction Management

Tools

NetSuite

Oracle

SAP

JD Edwards

Job description

Homer City Redevelopment LLC seeks a highly analytical Project Cost Analytics & Reporting Manager to lead cost data analysis, ensure cost coding integrity in ERP, and build reporting tools for management.

You will analyze large datasets, maintain project master data, develop Power BI dashboards, support EAC and budget forecasting, and collaborate with Accounting, Procurement, and Project Management to improve financial reporting.