Lead BI Engineer

Loenbro; Westminster (CO); On-site; USD 135,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) retirement plan with company 
匹

Paid time off (PTO) and holiday pay

Life and disability insurance

Professional development and training

Employee assistance program (EAP)

Job summary

Loenbro is seeking a Lead Business Intelligence Engineer to bridge our data platform and business stakeholders, delivering enterprise reports and analytics.

You will design Power BI solutions, govern data, mentor team members, and drive AI-enabled insights using DAX, SQL, and automation. Remote in the US with a competitive Colorado pay range.

Join a team focused on integrity, excellence, and customer success, contributing to critical infrastructure nationwide.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics or equivalent.
• 5+ years of BI experience with at least 1 year in a lead role.
• Advanced proficiency with Power BI, DAX, and SQL.
• Experience translating requirements from stakeholders into reporting solutions.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and semantic models.
• Collaborate with leaders to define KPIs and translate objectives into scalable reports.
• Validate data accuracy and ensure reporting integrity across the organization.
• Establish reporting standards, governance, security, and documentation.
• Drive BI adoption through stakeholder engagement, training, and continuous improvement.
• Provide technical leadership, code/review, and BI best-practice guidance.
• Leverage AI and automation to accelerate development and insights from data.
• Maintain AI-ready data models and semantic layers for trustworthy analytics.

Skills

Power BI

DAX

SQL

Leadership

Data Visualization

Education

Bachelor's degree in Information Systems, Computer Science, Data Analytics

Job description

Job Title: Lead Business Intelligence Engineer

Company: Loenbro, LLC

Business Unit/Department: Information Technology (IT)

Location: Remote

Reports to: Senior Manager, Business Analytics

Employment Type: Full-Time

FLSA Classification: Exempt

About Loenbro

Loenbro is a trusted, long-term construction lifecycle partner to thousands of customers across the U.S. Our market spans all industries and our service offerings include Critical Electrical, Mechanical & Structural, Soft Crafts, Inspection, Underground Maintenance and Installation, and Fabrication. Our expertise lies in simplifying the complex and establishing long-standing relationships with our partners. We have a national presence but a local approach—every customer benefits from our capabilities and our care.

At Loenbro, we don’t just offer jobs—we build careers grounded in integrity, teamwork, excellence, and purpose. Join a team where your expertise is valued, your growth is supported, and your work helps maintain and enhance the critical infrastructure that powers communities across the nation.

Job Summary

The Lead Business Intelligence Engineer serves as the primary link between Loenbro's data platform and business stakeholders, transforming complex operational and financial data into actionable insights. This role designs and delivers enterprise reporting solutions, drives data governance and adoption, and partners with leaders across the organization to support informed decision-making.

Essential Job Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and semantic models that support operational, financial, and executive leadership needs.
• Partner with business leaders to gather requirements, define KPIs, and translate business objectives into scalable reporting solutions.
• Validate data accuracy and collaborate with Analytics Engineering to ensure reporting integrity and consistency across the organization.
• Establish reporting standards, governance practices, security controls, and documentation that support a single source of truth.
• Drive adoption of business intelligence solutions through stakeholder engagement, training, and continuous improvement initiatives.
• Support strategic decision-making by delivering clear, actionable insights from complex data sets.
• Provide technical leadership and coaching to team members through knowledge sharing, code and report reviews, problem-solving support, and development of BI best practices.
• Leverage AI and automation tools (e.g., Copilot for Power BI, AI-driven DAX/M optimization, natural language query features) to accelerate report development, surface deeper insights, and reduce manual reporting effort.
• Design and maintain AI-ready data models and semantic layers that enable accurate, trustworthy AI-generated insights and support the organization's broader AI/analytics maturity.

Minimum Qualifications

Required

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent combination of education and experience.
• 5+ years of experience in business intelligence, analytics, data visualization, or corporate reporting environments, with at least a year of experience in a lead role.
• Advanced proficiency with Power BI, DAX, and SQL, including dashboard development and data validation.
• Experience partnering with business stakeholders to translate requirements into reporting and analytics solutions.

Preferred

• Experience supporting construction, industrial, project-based, or field service organizations.
• Knowledge of project finance, job costing, budgeting, or operational performance reporting.
• Microsoft DP-600 or DP-700 certification or other relevant business intelligence certifications.
• Experience with Power Apps, Power Automate, Python, R.

Physical Demands and Work Environment

The physical demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Work Environment

• Remote work environment
• Occasional travel to support business operations and stakeholders
• Limited job site visits may be required

This role requires compliance with all applicable safety regulations, personal protective equipment (PPE) requirements, and Loenbro's Environmental Health and Safety (EH&S) policies.

Benefits

Loenbro offers a competitive salary, comprehensive benefits package, and rewards to those who join our team:

• Medical, dental, and vision insurance
• 401(k) retirement plan with company match
• Paid time off (PTO) and holiday pay
• Life and disability insurance
• Professional development and training opportunities
• Employee assistance program (EAP)

Benefits eligibility may vary based on employment classification and hours worked.

Guided By Core Values (LEAD), Grounded In Grit And a Commitment To Excellence, Loenbro Betters Our Families, Customers, And Local Communities. If You’re Ready To Be Part Of a Company That LEADS By

• Living with Integrity
• Exceeding Expectations
• Acting with Urgency
• Delivering Excellence

…we want to hear from you.

Loenbro is an Equal Opportunity Employer

Colorado Pay Range: $135,000 USD - $150,000 USD