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