BI Engineer

Loenbro is a trusted construction lifecycle partner, seeking a BI Engineer to enhance their data team. The role involves gathering business requirements, building reports and dashboards, and ensuring data accuracy to support decision-making across the organization.

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

Requirements:

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