Business Intelligence Analyst

Whitaker Construction; Brigham City (UT); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

ESOP

Competitive wages

Health, Dental, Vision, Life, Short/TC

401K and Match

Paid Holidays

Paid Personal Days

Profit sharing (incentive)

Referral Bonuses

Employee Assistance Program (EAP)

Job summary

Whitaker Construction is seeking a Business Intelligence Analyst to turn construction and business data into dashboards, reports, and insights. You will partner with field leaders, project managers, and office teams to deliver practical solutions using Power BI, SQL, automation, and analytics tools.

The role focuses on improving data quality, expanding self-service analytics, and responsibly integrating AI capabilities across the business.

Qualifications

• Bachelor’s degree preferred; equivalent practical experience considered.
• Education credentials (Precision Exams, NOCTE, etc.) preferred.
• Typically 2–5 years in business intelligence, analytics, or related role (construction experience helpful).
• Hands-on Power BI experience: data modeling, Power Query, DAX, visualization, publishing, security, refreshes.
• Working knowledge of SQL, joins, views, transformations, and dimensional modeling.
• Experience with ERP data, APIs, cloud services, and operational apps; Microsoft Fabric/Azure Data Factory a plus.
• Power Automate, Python, Git, data governance or similar tools are a plus.
• Experience with Copilot/Azure AI Services, Azure OpenAI, Microsoft Fabric, or similar AI platforms is helpful.
• Understanding of responsible AI: privacy, security, oversight, validation, monitoring.
• Enjoy solving problems and explaining findings clearly.
• Care about accurate, understandable, and useful data.
• Ability to manage priorities and collaborate across teams.
• Excellent written and verbal communication.
• Teamwork and collaboration.
• Proficient with Word, Excel, Outlook.
• Valid driver’s license and reliable transportation.

Responsibilities

• Build and maintain Power BI dashboards, reports, scorecards, and data models supporting operational, financial, and executive decisions.
• Translate business needs into clear requirements, metrics, calculations, and visuals.
• Improve report performance, usability, security, and documentation.
• Fulfill ad hoc data requests for stakeholders.
• Prepare and validate data from ERP, timekeeping, telematics, PM, safety, finance and other systems.
• Create SQL queries, data transformations, APIs, and automated workflows for reporting.
• Monitor data refreshes and coordinate with IT on integration/performance issues.
• Maintain reliable data models, reusable measures, calculations, and trusted sources.
• Identify data-quality issues and implement validation, reconciliation, and monitoring controls.
• Define terms, ownership, access, and retention with data owners.
• Gather requirements and support BI solution design, testing, launch and acceptance.
• Help field leaders and teams use dashboards confidently; drive adoption.
• Use adoption data to improve solutions and business value.
• Analyze trends, risks, and performance drivers across projects and departments; deliver findings.
• Evaluate analytics and automation tools to reduce manual work.
• Identify AI opportunities to improve productivity, decisions, safety, risk management, and UX.
• Develop or support approved AI solutions and copilots; integrate them securely.
• Track AI quality, usage, cost, risk, adoption, and business results; document controls.
• Promote safety and adherence to procedures.

Skills

Power BI

SQL

Data modeling

DAX

Python

APIs

Power Automate

Git

AI platforms

Responsible AI

Problem solving

Communication

Teamwork

Microsoft Office

Driver's license

Education

Bachelor’s degree or equivalent practical experience

Tools

Microsoft Fabric

Azure Data Factory

Power Query

APIs

Job description

The Business Intelligence Analyst turns construction and business data into dashboards, reports, and insights that drive better decisions. This position partners with field leaders, project managers, and office teams to deliver practical solutions using Power BI, SQL, automation, and analytics tools. The Business Intelligence Analyst will improve data quality, expand self-service analytics, and help bring practical, responsible AI solutions into the business.

Whitaker Holdings is a 100% employee-owned (ESOP) family of companies with over 70 years of experience in heavy civil construction, underground utilities, and telecommunications. Whitaker Holdings encompasses multiple companies, including Whitaker Construction, DasCo of Idaho, Advanced Cable Technology, and Bighorn Traffic Services. Operating across Utah, Idaho, Nevada, Wyoming, Colorado, Oregon, and beyond, our companies are united by four core values — Value Safety, Embrace Ownership, Be Honorable, and Elevate Team — which guide how we work, how we treat each other, and how we deliver quality results on some of the most challenging projects in the region.

Roles and Responsibilities:

Including but not limited to the list below.

• Build and maintain Power BI dashboards, reports, scorecards, and data models that support operational, financial, and executive decisions.
• Turn business needs into clear 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, calculations, and trusted data sources.
• Find data-quality issues and implement validation, reconciliation, and monitoring controls.
• Partner with data owners to define 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 with confidence.
• 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, and deliver clear findings and recommendations.
• Evaluate analytics, automation, and data tools that reduce manual work and improve operations.
• Identify practical AI opportunities that 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 a culture of safety and awareness by practicing and enforcing safe work procedures.
• Other duties and responsibilities may be assigned by supervisors.

Skills and Qualifications:

• Bachelor’s degree in a related field preferred; equivalent practical experience will be considered.
• Those with an education and/or work-related credential from a secondary or post-secondary educational system will be given preferred interview status (Precision Exams, NOCTE, etc.).
• Typically 2–5 years of experience in business intelligence, analytics, reporting, or a related role. Construction or heavy civil experience is helpful, not required.
• 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. Microsoft Fabric, Azure Data Factory, or similar platforms are a plus.
• Power Automate, Python, Git, data governance, or similar tools are a plus.
• Experience with Microsoft Copilot, Azure AI Services, Azure OpenAI, Microsoft Fabric, or comparable AI platforms is helpful.
• Understanding of responsible AI, including privacy, security, human oversight, validation, and monitoring.
• Enjoy solving problems, investigating data, and explaining findings clearly.
• Care about accurate, understandable, and useful data.
• Ability to manage priorities well and collaborate across field, operational, financial, and technical teams.
• Excellent written and verbal communication skills.
• Ability to work effectively in a team environment.
• Proficient with Microsoft Word, Excel, and Outlook.
• Valid driver’s license and reliable transportation to get to and from work.

Physical Requirements:

• Able and willing to work extended hours as needed, including outside of normal hours.
• Able to sit for extended periods, walk, reach, stand, grasp, and lift up to 25 pounds occasionally.
• Requires good manual dexterity for extended computer use.
• Able to visit field locations and work in outside environments, being subjected to weather changes, noise, vibrations, and job hazards.

Whitaker Construction offers an exceptional benefits package including:

• Employee Stock Ownership Plan (ESOP). Employees earn shares in the company – All employees have ownership in the company and its success.
• Competitive wages.
• Health, Dental, Vision, Life, Short Term Disability, Supplemental Insurance.
• 401K and Match.
• Paid Holidays.
• Paid Personal Days.
• Quarterly Incentive Program (profit sharing).
• Referral Bonuses.
• Employee Assistance Program (EAP).

Reasonable Accommodation Statement

The ADA defines “reasonable accommodation” as a change or adjustment to a job or work environment that allows a qualified individual with a disability to satisfactorily perform the essential functions of a particular job, and does not cause an undue hardship for the employer.

Whitaker Construction is an “equal opportunity employer.” Whitaker will not discriminate and will take “affirmative action” measures to ensure against discrimination in employment, recruitment, advertisements for employment, compensation, termination, upgrading, promotions, and other conditions of employment against any employee or job applicant on the bases of race, creed, color, national origin, or sex.

Women and minorities are encouraged to apply.