Power BI-Driven Project Controls Specialist

Granite Construction; The Woodlands (TX); On-site; USD 111,123 - 166,683; Full time

Job summary

Granite Construction seeks a Project Controls Specialist IV – Data Analytics & Reporting to administer, improve, and standardize project controls systems across large projects. Location is flexible with options for remote work, enabling collaboration with project controls teams, IT, and operations to ensure accurate data and actionable insights.

The role focuses on building and governing data models, dashboards, and reporting environments (Power BI, DAX, SQL) to enhance decision-making and

Qualifications

• 7+ years of experience in a related position.
• Proven experience building PowerBI dashboards including relationships, DAX, intuitive/user-friendly formats.
• Experience in AEC sector, preferably construction, using data such as ACC, Primavera P6, and Job Cost systems.
• Proficiency with Microsoft Office applications; JD Edwards/OneWorld preferred.
• Understanding of construction-industry data workflows; BIM tools familiarity.

Responsibilities

• Administer and maintain Power BI workspaces, dashboards, and reporting environments, including performance, usability, and security.
• Collaborate with project controls teams to develop and optimize dashboards, trend analysis, predictive analytics, and decision-support reporting.
• Work with IT to connect source systems, map APIs, and maintain data structures within the Operational Data Store (ODS).
• Develop and maintain data dictionaries, metadata references, lineage documentation, and related BI governance artifacts.
• Support development of stable construction project data models and ontology structures spanning cost, scheduling, procurement, risk, document control, BIM, and related domains.
• Ensure data accuracy, consistency, and compliance with organizational governance standards throughout BI development and reporting processes.
• Develop and maintain process manual (containing Standard Operating Procedures and Process Narratives) to ensure consistent tracking of all in-process projects.
• Lead report testing, validation, and internal documentation reviews prior to release.
• Train users on dashboard interpretation, configuration, and best practices to encourage adoption and effective use.
• Train regional and job-assigned project controls and construction professionals with walkthrough, demos, and training materials for how to configure and use dashboards.
• May supervise, direct, and mentor project staff to ensure individual development and that project standards are met.

Skills

Data analytics

Project controls

Communication

Problem solving

Leadership

Education

Bachelor’s degree in Business, Engineering, Computer Science, or related field

Tools

Power BI

SQL Server

DAX

Power Query

API integration

JD Edwards/OneWorld

Job description

Granite Construction seeks a Project Controls Specialist IV – Data Analytics & Reporting to administer, improve, and standardize project controls systems across large projects. Location is flexible with options for remote work, enabling collaboration with project controls teams, IT, and operations to ensure accurate data and actionable insights.

The role focuses on building and governing data models, dashboards, and reporting environments (Power BI, DAX, SQL) to enhance decision-making and