Power BI Data Engineer

About the role

Legence (Nasdaq: LGN) is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. We specialize in designing, fabricating, and installing complex HVAC, process piping, and other MEP systems, enhancing energy efficiency, reliability, and sustainability in new and existing facilities. Serving some of the world’s most technically demanding sectors, Legence counts over 60% of the Nasdaq-100 Index among its clients.

Key Responsibilities

• 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
• Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data Factory
• Develop and optimize data models using star schema, snowflake schema, and other dimensional modeling techniques
• Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms
• Write and optimize complex SQL queries, stored procedures, and database functions for performance and efficiency
• Establish data governance frameworks, including data quality checks, validation rules, and documentation standards
• Configure and manage Power BI/Fabric workspaces, deployment pipelines, and version control
• Implement row-level security (RLS) and object-level security (OLS) for data protection
• Optimize report performance through query optimization, data model refinement, and DAX tuning
• Integrate Power BI with various data sources including SQL databases, APIs, SharePoint, Excel, and cloud platforms
• Automate data refresh schedules and monitor gateway configurations

Required Qualifications

• 3+ years of hands-on experience with Power BI development (Desktop, Service, and Report Server)
• Expert-level proficiency in DAX (Data Analysis Expressions) and Power Query (M language)
• Strong SQL skills with experience in database design, query optimization, and performance tuning
• Solid understanding of data warehousing concepts, dimensional modeling, and ETL principles
• Experience with data visualization best practices and UI/UX design principles
• Proficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric)
• Deep understanding of data modeling techniques and relationships (one-to-many, many-to-many, bi-directional)
• Strong grasp of statistical concepts and analytical methodologies
• Ability to translate complex business requirements into technical data solutions
• Experience with data quality assessment and data profiling
• Proven ability to create visually compelling, executive-level dashboards and reports
• Strong problem-solving skills with a hands-on, solution-oriented approach
• Excellent communication skills to explain technical concepts to non-technical stakeholders
• Demonstrated ability to use AI and automation in software engineering

Preferred Qualifications

• CS or CIS bachelor's degree
• Microsoft certifications: PL-300 (Power BI Data Analyst), DP-203 (Data Engineer), or DP-500 (Enterprise Data Analyst)
• Experience with Python or R for advanced analytics integration
• Familiarity with Git/Azure DevOps for version control and CI/CD pipelines
• Knowledge of DAX Studio, and other Power BI development tools
• Experience with Power BI Embedded or custom API development
• Understanding of data science concepts and predictive analytics

Technical Environment

• Power BI Desktop, Power BI Service, Power BI Premium/Fabric
• SQL Server, Azure SQL Database, Azure Synapse Analytics
• Azure Data Factory, Azure Data Lake Storage
• DAX Studio, Tabular Editor, Power Query
• Git/Azure DevOps for version control and CI/CD pipelines

What Makes You Stand Out

• Portfolio of impressive Power BI dashboards demonstrating design excellence and technical complexity
• Track record of optimizing poorly performing reports and data models
• Experience mentoring others in Power BI development and best practices
• Contributions to the Power BI community (blog posts, speaking engagements, open-source projects)

Pay

Base salary: $105,000–$120,000 per year. This role may be eligible for participation in a discretionary bonus plan based on company and individual performance.

Benefits

• 401(k) Plan with Company Match: Currently match contributions dollar-for-dollar up to 4% of eligible pay; immediate vesting.
• Health & Welfare Benefits: Employer provided medical, dental, vision, prescription drug, Employee Assistance Program and accident & illness coverage.
• Life and Disability Insurance: Employer provided basic life insurance and AD&D valued at 50K coverage amount with the option for voluntary buy up for additional coverage.
• Time Off: Flexible non-accrual vacation; company holidays per policy.
• (For California employees, this is separate from California paid sick leave, if applicable.)
• Expenses: Business travel and related expenses reimbursed per company policy.