Business Intelligence Analyst

Whitaker Construction•Brigham City, UT

About The Position

The Business Intelligence Analyst turns construction and business data into dashboards, reports, and insights that support better decisions. The role partners with field leaders, project managers, and office teams to deliver practical solutions using Power BI, SQL, automation, and analytics tools. It focuses on improving data quality, expanding self-service analytics, and bringing practical, responsible AI solutions into the business. Whitaker Holdings is a 100% employee-owned (ESOP) family of companies with more than 70 years of experience in heavy civil construction, underground utilities, and telecommunications. Its companies include Whitaker Construction, DasCo of Idaho, Advanced Cable Technology, and Bighorn Traffic Services, operating across Utah, Idaho, Nevada, Wyoming, Colorado, Oregon, and beyond. The company’s core values are Value Safety, Embrace Ownership, Be Honorable, and Elevate Team. The role builds and maintains BI dashboards, reports, scorecards, and data models; prepares and validates data from business systems; develops queries, transformations, APIs, and automated workflows; and supports reliable, secure, well-documented reporting. The analyst investigates data quality, works with data owners on governance, gathers requirements, and supports BI solutions through design, testing, launch, and adoption. The position also analyzes business trends and performance, evaluates analytics and automation tools, and identifies, develops, or supports approved AI solutions while monitoring their quality, risk, usage, and business results. The analyst promotes safe work practices and may be assigned other duties by supervisors.

Requirements

Typically 2–5 years of experience in business intelligence, analytics, reporting, or a related role.
Hands-on Power BI experience, including data modeling, Power Query, DAX, visualization, publishing, security, and refreshes.
Working knowledge of SQL, joins, views, transformations, and dimensional modeling.
Experience with ERP data, APIs, spreadsheets or flat files, cloud services, and operational applications.
Understanding of responsible AI, including privacy, security, human oversight, validation, and monitoring.
Ability to solve problems, investigate data, and explain findings clearly.
Care for accurate, understandable, and useful data.
Ability to manage priorities and collaborate across field, operational, financial, and technical teams.
Excellent written and verbal communication skills.
Ability to work effectively in a team environment.
Proficiency with Microsoft Word, Excel, and Outlook.
Valid driver’s license and reliable transportation to and from work.
Able and willing to work extended hours as needed, including outside normal hours.
Able to sit for extended periods; walk, reach, stand, and grasp; and occasionally lift up to 25 pounds.
Good manual dexterity for extended computer use.
Able to visit field locations and work outdoors in changing weather, noise, vibrations, and job hazards.

Nice To Haves

Bachelor’s degree in a related field; equivalent practical experience will be considered.
Construction or heavy civil experience.
Microsoft Fabric, Azure Data Factory, or similar platforms.
Power Automate, Python, Git, data governance, or similar tools.
Experience with Microsoft Copilot, Azure AI Services, Azure OpenAI, Microsoft Fabric, or comparable AI platforms.
Education and/or a work-related credential from a secondary or post-secondary educational system; examples include Precision Exams and NOCTE. Such candidates receive preferred interview status.

Responsibilities

Build and maintain Power BI dashboards, reports, scorecards, and data models for operational, financial, and executive decisions.
Translate business needs into requirements, metrics, calculations, and visualizations.
Improve report performance, usability, security, and documentation.
Complete ad hoc data requests for stakeholders.
Prepare and validate data from ERP, timekeeping, telematics, project management, safety, financial, and other systems.
Create SQL queries, data transformations, APIs, and automated workflows for reporting and analytics.
Monitor data refreshes and work with Information Technology to resolve integration and performance issues.
Maintain reliable data models, reusable measures and calculations, and trusted data sources.
Identify data-quality issues and implement validation, reconciliation, and monitoring controls.
Partner with data owners to define data terms, ownership, access, and retention requirements.
Gather requirements and support the design, testing, launch, and acceptance of BI solutions.
Help field leaders, project managers, and office teams use dashboards and data confidently.
Use adoption data and feedback to improve solutions and increase business value.
Analyze trends, risks, and performance drivers across projects, labor, equipment, safety, and financial results; deliver clear findings and recommendations.
Evaluate analytics, automation, and data tools that reduce manual work and improve operations.
Identify practical AI opportunities to improve productivity, decisions, safety, risk management, and user experiences.
Develop or support approved AI solutions, including copilots, intelligent workflows, predictive analytics, document processing, and automated insights.
Work with Information Technology and business teams to integrate AI responsibly and securely.
Track AI quality, usage, cost, risk, adoption, and business results; document controls, limitations, and support needs.
Promote safety awareness by practicing and enforcing safe work procedures.
Perform other duties and responsibilities assigned by supervisors.

Benefits

Employee Stock Ownership Plan (ESOP); employees earn shares and have ownership in the company and its success.
Competitive wages.
Health insurance.
Dental insurance.
Vision insurance.
Life insurance.
Short-term disability insurance.
Supplemental insurance.
401(k) and employer match.
Paid holidays.
Paid personal days.
Quarterly incentive program (profit sharing).
Referral bonuses.
Employee Assistance Program (EAP).