Project Controls Specialist - Data Analytics and Reporting

Job description

Building a career at Granite may be the most valuable thing you could do... Find your dream job today, and be part of something great. Our most powerful partnership is the one we have with our employees. Our people are our most valued asset and the foundation of Granite’s century-old success. We’re building more than infrastructure; we are building your future. General Summary Project Controls Specialist IV – Data Analytics & Reporting is an advanced technical specialist responsible for administering, improving, and standardizing project controls systems, processes, reporting, and documentation across large or complex projects. This corporate role partners with project teams, operations, corporate functions, and IT to ensure accurate data, effective controls, user support, and consistent process execution. In this specialization, the role focuses on building, maintaining, and governing project controls data models, dashboards, and reporting environments to improve decision-making and operational visibility. Location of this position is flexible with the ability to work from various office location within Granite or remote. Essential Job Accountabilities 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. Education Bachelor’s degree in Business, Engineering, Computer Science, or comparable discipline - or equivalent combination of training and experience Work Experience 7+ years’ experience in a related position Proven experience building PowerBI dashboards including relationships, DAX, intuitive/User-friendly information formats. Experience in AEC sector, preferably construction, using data such as ACC, Primavera P6, and Job Cost systems. Knowledge, skills, and abilities 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. While performing the duties of this job, the employee is regularly required to talk and hear. The employee frequently is required to stand, walk, sit and use hands to operate a computer keyboard. The employee is occasionally required to reach with hands and arms. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job 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/Skills 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 Our Benefits at a Glance: Building tomorrow starts with you, and Granite knows that you can excel only if we support you in and out of the workplace. That is why we offer a broad benefits package that includes paid holidays, sick leave, medical, dental, vision, life insurance, disability insurance, flexible spending plans, as well as special programs for musculoskeletal health, mental wellness, and more. Salaried employees may choose from two PPO medical plans through Anthem BlueCross, including our most popular plan, for which 100% of the premium is paid by Granite for eligible employees and dependents. Employees can also opt into a Health Savings Account (HSA) or a Flexible Spending Account (FSA). As part of our investment in your future outside of the workplace, Granite provides a 100% match on the first 6% of eligible compensation that salaried employees defer into their 401(k) plans, which vests immediately. Benefits may vary for positions located outside of the continental United States. Base Salary Range: $111,123.00 - $166,683.00 Pay may vary based upon relevant experience, skills, location, and education among other factors. ​ About Granite Construction Incorporated Granite Construction Incorporated is a member of the S&P 400 Index and is the parent company of Granite Construction Company, one of the nation's largest heavy civil contractors and construction materials producers. Granite is a Drug-Free Workplace and Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, protected veteran status, or any other protected characteristic. We consider qualified applicants with arrest and conviction records in accordance with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. For additional information on applicant/employee rights please click here . Notice to Staffing Agencies Granite Construction, Inc. and its subsidiaries ("Granite") will not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to Granite, including unsolicited resumes sent to a Granite mailing address, fax machine or email address, directly to Granite employees, or to Granite's resume database will be considered Granite property. Granite will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume. Granite will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. Agencies must obtain advance written approval from Granite's recruiting function to submit resumes, and then only in conjunction with a valid fully-executed contract for service and in response to a specific job opening. Granite will not pay a fee to any Agency that does not have such agreement in place. Agency agreements will only be valid if in writing and signed by Granite's Human Resources Representative or his/ her designee. No other Granite employee is authorized to bind Granite to any agreement regarding the placement of candidates by Agencies.