Job Description
Role Summary
We are seeking a highly skilled Senior Power BI Developer to drive enterprise-wide report rationalization and transformation for an insurance customer. The role focuses on modernizing legacy reporting into a self-service BI ecosystem using Power BI, leveraging a Snowflake + dbt-based data platform structured across Raw, Silver, and Gold layers.
The candidate will play a critical role in enabling business-led analytics, reducing report redundancy, and delivering scalable, performant, and governed reporting solutions.
Key Responsibilities
Report Rationalization Transformation
- Lead assessment and rationalization of existing reports, identifying redundancy, consolidation opportunities, and decommissioning candidates
- Design a target-state reporting architecture aligned with self-service BI principles
Power BI Development
- Build interactive dashboards and reports enabling slicing, dicing, and drill-through analysis
- Develop paginated reports for pixel-perfect reporting needs (regulatory, operational)
- Implement complex DAX calculations, KPIs,
and semantic models
- Optimize report performance using best practices in data modeling and query optimization
Data Modeling Integration
- Design and consume curated data models from Snowflake (Gold layer) for reporting
- Work with data engineering teams to define data transformations in dbt (Silver Gold)
- Ensure consistency between source-to-report data lineage and business definitions
Self-Service BI Enablement
- Enable business users with governed datasets and reusable semantic layers
- Define and enforce Power BI governance standards (workspace strategy, naming conventions, versioning)
Performance Optimization
- Optimize Power BI datasets, queries, and dashboards for performance and scalability
- Implement incremental refresh, aggregations, and efficient data models
- Ensure productive usage of Snowflake resources for reporting workloads