Power BI Data Engineer

About this role

About Legence

Legence (Nasdaq: LGN) is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. The company specializes in designing, fabricating, and installing complex HVAC, process piping, and other mechanical, electrical, and plumbing (MEP) systems—enhancing energy efficiency, reliability, and sustainability in new and existing facilities. Legence also delivers long-term performance through strategic upgrades and holistic solutions. Serving some of the world’s most technically demanding sectors, Legence counts over 60% of the Nasdaq-100 Index among its clients.


Position Overview: We are seeking a highly skilled Power BI Data Engineer who combines deep technical expertise in data engineering with exceptional data visualization abilities. This hands-on role requires someone who can architect robust data solutions while creating compelling, insight-driven dashboards that transform complex data into clear, actionable intelligence. This role is expected to interact directly with end users regarding requirements, testing, and implementation. This position is remote with preference to align to one of Legence’ s office locations.

Key Responsibilities

Power BI Development & Visualization

• Create sophisticated, visually stunning Power BI dashboards and reports that drive business decisions
• Develop advanced DAX calculations, measures, and calculated columns to support complex analytical requirements
• Design intuitive, user-friendly interfaces with custom visuals, drill-through capabilities, and interactive features
• Implement dynamic report features including bookmarks, parameters, field parameters, and dynamic formatting
• Build composite models and leverage advanced features like aggregations, incremental refresh, and query folding

Data Engineering & Architecture

• Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflo...