Lead BI Engineer

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., * 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., 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.

• 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

3.43.4 out of 5 stars Westminster, CO Remote $135,000 - $150,000 a year - Full-time, Pulled from the full job description

• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance
• Employee assistance program
• Disability insurance, 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.

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.