Senior Project Controls Analyst: Data-Driven Dashboards

Intellectt INC; North Carolina; On-site; USD 66,000 - 72,000; Full time

Job summary

Intellectt INC in North Carolina seeks a Senior Project Controls Specialist to transform large project datasets into accurate, auditable reports and dashboards. You will own cost, schedule, invoicing, and earned-progress data across projects and support PMO leadership.

The role emphasizes data-driven analysis, advanced Excel/Power BI skills, and collaboration with cross-functional teams to drive reporting improvements and automation.

Qualifications

• Extensive Project Controls experience on construction or capital projects.
• Advanced Excel and Power BI capabilities.
• Strong data analysis, mining, reconciliation, and visualization skills.
• Experience with cost, schedule, invoicing, earned progress, forecasting, and variance analysis.
• Familiarity with Primavera P6 or Oracle Primavera Cloud.
• Understanding of integrated schedules, milestones, dependencies, and float.

Responsibilities

• Analyze and reconcile project cost, schedule, invoicing, and earned-progress data.
• Review invoices, cost codes, work packages, POs, and supporting docs.
• Extract, clean, combine, validate, and reconcile data from multiple project-control systems.
• Identify variances, anomalies, forecast changes, progress trends, and gaps.
• Analyze SPI/LPI, milestones, dependencies, float, and critical paths.
• Support schedule reporting using Primavera Cloud or similar tools.
• Develop and maintain Power BI dashboards and advanced Excel models.
• Perform data-quality checks to ensure auditable reporting.
• Support reporting automation using analytics, automation, and AI tools where relevant.
• Collaborate with Project Controls, Cost, Scheduling, Finance, Procurement, and project teams.

Skills

Project Controls

Excel

Power BI

Data analysis

Data mining

Reconciliation

Visualization

Forecasting

Variance analysis

SQL

VBA

Power Query

Tools

Primavera P6

Oracle Primavera Cloud

SQL

Power Query

VBA

Job description

Intellectt INC in North Carolina seeks a Senior Project Controls Specialist to transform large project datasets into accurate, auditable reports and dashboards. You will own cost, schedule, invoicing, and earned-progress data across projects and support PMO leadership.

The role emphasizes data-driven analysis, advanced Excel/Power BI skills, and collaboration with cross-functional teams to drive reporting improvements and automation.