BI Engineer

Role Description

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.

Qualifications

• Bachelor’s degree in Business Analytics, Information Systems, Finance, Computer Science, or related field.
• 1–3 years of experience in business intelligence, data analytics, or a reporting-focused role.
• Excellent written and verbal communication skills.
• Power BI; designing, publishing, and maintaining interactive dashboards, operational reports, and executive-level visualizations.
• DAX; calculated columns, measures, time intelligence, and KPI logic.
• Basic to intermediate SQL for querying, validating data, and troubleshooting report discrepancies.
• Semantic model creation — ability to build reliable reports on top of models produced by the Analytics Engineering team.

Requirements

• 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.
• Familiarity with ETL/ELT concepts — enough to have informed conversations with the Analytics Engineering team about data availability and pipeline timing.
• Microsoft Fabric — working knowledge of how data flows from source through the medallion layers to the reporting layer; comfortable consuming gold-layer datasets.
• 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.
• Fact and dimension table literacy — understands how a well-modeled dataset enables better, more flexible reporting.
• Software development experience in any language.
• Microsoft PL-300 (Power BI Data Analyst) certification.

Physical Demands and Work Environment

• Work Environment: Remote.
• 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

• 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.