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, 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
- Technical Implementation
- 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