Apply on Employer Site

Legence · 1 week ago

Power BI Data Engineer

USA

Full-time

Hybrid

Mid Level

$105K/yr - $120K/yr

3+ years exp

Legence is a leading provider of engineering and consulting services for mission-critical systems in buildings. They are seeking a highly skilled Power BI Data Engineer to architect robust data solutions and create compelling dashboards that transform complex data into actionable intelligence.

ConsultingEnergy EfficiencyProfessional ServicesRenewable EnergyService Industry

No H1B

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

Qualification

Power BI developmentDAX proficiencySQL skillsData engineeringAzure data servicesData modeling techniquesData visualization best practicesAIAutomationProblem-solving skillsCommunication skillsDetail-oriented

Required

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

Detail-oriented with commitment to code quality and documentation

Demonstrated ability to use AI and automation in software engineering

Preferred

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

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.