[Remote] Power BI Data Engineer
Note: The job is a remote job and is open to candidates in USA. Legence is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. They are seeking a Power BI Data Engineer who will be responsible for architecting data solutions and creating insightful dashboards that enable data-driven decision making.
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
Skills
- 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
Benefits
- 401(k) Plan with Company Match: Currently match contributions dollar-for-dollar up to 4% of eligible pay; immediate vesting.
- Employer provided medical, dental, vision, prescription drug, Employee Assistance Program and accident & illness coverage.
- Employer provided basic life insurance and AD&D valued at 50K coverage amount with the option for voluntary buy up for additional coverage.
- Flexible non-accrual vacation; company holidays per policy.
- (For California employees, this is separate from California paid sick leave, if applicable.)
- Business travel and related expenses reimbursed per company policy.
Company Overview