BI Engineer at Loenbro in Remote

Summary: 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 Required 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 Preferred Qualifications: - 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 Required Skills: Power BI, DAX, SQL, Semantic model creation, Power Platform, Project finance, ETL/ELT concepts, Microsoft Fabric, Row-level security, Data validation techniques, Fact, dimension table literacy, Software development, Microsoft PL-300 certification 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)