Remote Project Controls & Data Analytics Lead

Granite Construction; Watsonville (CA); On-site; USD 111,123 - 166,683; Full time

Job summary

Granite Construction Incorporated is seeking a Project Controls Specialist IV – Data Analytics & Reporting to administer and standardize BI systems across large projects. You will build and govern dashboards, data models, and reporting environments to enhance decision-making and operational visibility.

Location is flexible with remote options, and collaboration with IT and project teams is essential. Ideal candidates have 7+ years of experience, strong Power BI, DAX, and SQL skills, and

Qualifications

• 7+ years of experience in a related position.
• Proven experience building PowerBI dashboards including relationships, DAX, and user-friendly information formats.
• Experience in AEC sector, preferably construction, using data such as ACC, Primavera P6, and Job Cost systems.

Responsibilities

• Administer and maintain Power BI workspaces, dashboards, and reporting environments with focus on performance, usability, and security.
• Collaborate with project controls teams to develop dashboards, trend analysis, predictive analytics, and decision-support reporting.
• Connect source systems, map APIs, and maintain data structures within the Operational Data Store (ODS).
• Develop and maintain data dictionaries, metadata references, and lineage documentation; ensure BI governance.
• Support development of stable construction project data models and ontology structures across cost, scheduling, procurement, risk, document control, BIM.
• Ensure data accuracy, consistency, and governance across BI development and reporting processes.
• Lead report testing, validation, and internal documentation reviews prior to release.
• Train users on dashboard interpretation, configuration, and best practices to drive adoption.

Skills

Power BI

DAX

SQL

Data modeling

Data governance

Project controls

BIM tools

Revit

Navisworks

Education

Bachelor’s degree in Business, Engineering, Computer Science

Tools

JD Edwards / OneWorld

SQL Server Management Studio

DAX Studio

Job description

Granite Construction Incorporated is seeking a Project Controls Specialist IV – Data Analytics & Reporting to administer and standardize BI systems across large projects. You will build and govern dashboards, data models, and reporting environments to enhance decision-making and operational visibility.

Location is flexible with remote options, and collaboration with IT and project teams is essential. Ideal candidates have 7+ years of experience, strong Power BI, DAX, and SQL skills, and