Power BI Data Engineer

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.

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

Requirements:

• 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
• 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