Project Controls Data & Process Analyst

Position Summary

The Project Controls Data & Process Analyst is a versatile, technology-forward role that combines core project-controls analysis with reporting automation and process improvement. This position builds and maintains the reporting backbone of the Project Controls group — leveraging Power BI and Fermi’s AI tooling (Claude) heavily to automate reporting, surface insights, and reduce manual effort — while also performing hands-on cost/invoice analysis, schedule assistance, reconciliation, and change-order support. The role is central to standardizing and continuously improving how Project Controls operates.

Key Responsibilities

ATS provider: Paylocity.

• Design, build, and maintain Power BI dashboards and reports spanning cost, schedule, invoices, commitments, and cash flow, drawing from Unifier, Fusion, and P6 data.
• Leverage Claude and other AI tooling to automate recurring reporting, document analysis, data extraction, and narrative summaries — and to standardize/streamline controls workflows.
• Perform general project-controls analyst duties: cost tracking, budget-vs-actual analysis, forecasting support, and variance reporting.
• Process and analyze invoices — validation, coding, accruals, and reconciliation against POs, commitments, and contract terms.
• Provide schedule assistance: updating, progress capture, and coordination with the scheduling team; support reconciliation between schedule and cost data.
• Support the change-order lifecycle — logging, tracking, documentation, and status reporting.
• Reconcile data across systems to ensure consistency and a reliable single source of truth for reporting.
• Develop, document, and implement improved processes, templates, and controls procedures; drive adoption across the team.
• Prepare ad-hoc analyses and reporting packages for leadership and stakeholders.