Project Controls Specialist - Data Analytics and Reporting

Granite’s people are our most valued asset and the foundation of our century-old success. We’re building more than infrastructure; we are building your future. This corporate role partners with project teams, operations, corporate functions, and IT to ensure accurate data, effective controls, user support, and consistent process execution.

About the role

This advanced technical specialist role administers, improves, and standardizes project controls systems, processes, reporting, and documentation across large or complex projects. The focus is on building, maintaining, and governing project controls data models, dashboards, and reporting environments to improve decision-making and operational visibility. Location is flexible with the ability to work from various Granite offices or remotely.

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 manuals (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 walkthroughs, 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.

Requirements

• Bachelor’s degree in Business, Engineering, Computer Science, or comparable discipline — or equivalent combination of training and experience.
• 7+ years’ experience in a related position.
• Proven experience building Power BI dashboards including relationships, DAX, and intuitive/user-friendly information formats.
• Experience in AEC sector, preferably construction, using data such as ACC, Primavera P6, and Job Cost systems.

Skills

• Proficiency with Microsoft Office applications (Word, Excel, PowerPoint, Access).
• Experience with JD Edwards / OneWorld (preferred).
• Basic understanding of construction-industry data workflows.
• Familiarity with BIM and coordination tools such as Revit, Navisworks, and Civil 3D (conceptual understanding acceptable).
• Working knowledge of data transformation and analytics tools including Power BI, DAX Studio, and SQL Server Management Studio.
• Ability to write DAX formulas, Power Query (M) scripts, and SQL expressions.
• Strong written and verbal communication skills for clear information sharing.
• Excellent problem-solving skills with reliable follow-through.
• Highly organized with strong attention to detail and the ability to manage multiple priorities.
• Self-starter capable of independently structuring workload and seeking out resources.
• Ability to work effectively with staff at all levels as well as external clients and partners.
• Demonstrated ability to perform well in high-production environments and under tight deadlines.
• Committed to continuous learning, with a strong growth mindset and active pursuit of professional development opportunities.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• Regularly required to talk and hear.
• Frequently required to stand, walk, sit, and use hands to operate a computer keyboard.
• Occasionally required to reach with hands and arms.
• Occasionally required to lift and/or move up to 10 pounds.
• Specific vision abilities required include close vision and ability to adjust focus.
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Additional Requirements

• Comply, understand, and support corporate safety initiatives to ensure a safe work environment.
• Ability and willingness to abide by Granite’s Code of Conduct on a daily basis.
• Valid driver’s license and ability to drive for extended periods of time.
• Some travel required.

Benefits

• Paid holidays and sick leave.
• Medical, dental, vision, life insurance, and disability insurance.
• Flexible spending plans (HSA or FSA).
• Special programs for musculoskeletal health and mental wellness.
• 100% of the premium paid by Granite for eligible employees and dependents under the most popular PPO medical plan.
• 100% match on the first 6% of eligible compensation deferred into 401(k) plans, which vests immediately.

Pay

Base Salary Range: $111,123.00 - $166,683.00. Pay may vary based upon relevant experience, skills, location, and education among other factors.