BI Engineer
Job Title: BI Engineer
Company: Loenbro, LLC
Business Unit/Department: IT
Location: Centennial, CO; Dallas, TX; Westminster, CO
Reports to: Senior Manager – Business Analytics
Employment Type: Full-Time, Hybrid
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 Business Intelligence Engineer is the external-facing half of Loenbro’s data team. This person works alongside the Senior Manager of Business Analytics to gather requirements from the business. They work with operations leaders, project finance teams, field stakeholders, and department heads to understand what decisions they need to make — and then build the reports and dashboards that give them that visibility. The BI Engineer consumes the trusted data models produced by the Analytics Engineering team and transforms them into clear, validated, business-ready reporting. This role requires as much people skill as technical skill: you are the bridge between the data platform and the people who use it every day.
Essential Job Responsibilities
- Design, build, and publish Power BI dashboards and reports that provide clear, actionable visibility into project performance, operational metrics, and financial data
- Own the visual design and user experience of reports — making dashboards that are intuitive and clean
- Identify gaps or issues in the data and communicate them back to the Analytics Engineering team for resolution at the pipeline or model level
- Partner with operations leaders, project finance teams, and department heads to gather reporting requirements and translate business questions into well-defined data needs
- Work closely with the Analytics Engineering team to produce highly curated reports and dashboards
- Validate reports against source data and business logic — ensuring accuracy, consistency, and trustworthiness before reports reach end users
- Support report adoption across the organization — training end users, gathering feedback, and iterating toward solutions that stick
- Maintain thorough documentation for all reports, datasets, and KPI definitions so the business has a single source of truth for how metrics are calculated
- Manage the report development lifecycle using SDLC and ALM practices — versioning, workspace governance, and controlled deployments
Minimum Qualifications
Required:
- Bachelor’s degree in Business Analytics, Information Systems, Finance, Computer Science, or related field
- 3–5 years of experience in business intelligence, data analytics, or a reporting-focused role
- Demonstrated experience working directly with business stakeholders to define KPIs, metrics, and reporting requirements
- Construction, field operations, or project finance background preferred — understanding of job costing, budget vs. actual tracking, and operational workflows is a meaningful advantage in this role
- Power BI — required; designing, publishing, and maintaining interactive dashboards, operational reports, and executive-level visualizations
- DAX — required; calculated columns, measures, time intelligence, and KPI logic
- Power Query (M) — shaping and transforming data within the Power BI and Fabric environment
- Microsoft Fabric — working knowledge of how data flows from source through the medallion layers to the reporting layer; comfortable consuming gold-layer datasets
- Semantic model consumption — ability to build reliable reports on top of models produced by the Analytics Engineering team
- Row-level security (RLS), workspace governance, and report deployment best practices
- Data validation techniques — cross-checking report outputs against source data and business-defined logic
- Solid understanding of medallion architecture — knows how data is structured across bronze/silver/gold and which layer to consume for which use case
- Familiarity with ETL/ELT concepts — enough to have informed conversations with the Analytics Engineering team about data availability and pipeline timing
- Fact and dimension table literacy — understands how a well-modeled dataset enables better, more flexible reporting
- Basic to intermediate SQL for querying, validating data, and troubleshooting report discrepancies
Preferred:
- Power Platform experience (Power Apps, Power Automate) for lightweight workflow and form-based solutions
- Project finance or job costing knowledge — how construction companies track costs, contracts, and budget performance
- Software development experience in any language
- AI experience — using AI tools to accelerate analysis, generate documentation, or enhance reporting workflows
- Microsoft PL-300 (Power BI Data Analyst) certification
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:
- Hybrid office-based with flexibility for remote work as approved
- Occasional support for field teams and job sites
- Travel requirements: minimal
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
This role will remain open for recruitment until successfully filled.
Colorado Pay Range
$100,000 - $125,000 USD
Create a Job Alert
Interested in building your career at Loenbro? Get future opportunities sent straight to your email.
Apply for this job
*
indicates a required field