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 efficient usage of Snowflake resources for reporting workloads
Required Skills & Qualifications
Technical Skills
- 6–10+ years of experience in BI/Analytics with strong Power BI expertise
- Strong hands-on experience with:
- Power BI Desktop & Service
- DAX, Power Query (M)
- Paginated Reports (Power BI Report Builder / SSRS)
- Experience with Snowflake data platform and modern data architectures
- Familiarity with dbt for data transformation and modeling
- Strong understanding of data warehousing concepts (Raw, Silver, Gold layers)
- Expertise in data modeling techniques (star schema, dimensional modeling)
Domain Expertise
- Experience in Insurance domain (Claims, Policy, Billing, Underwriting) preferred
- Understanding of regulatory and operational reporting requirements
