DE&A Core Advanced Visualization & Cloud Reporting Power BI

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

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

PBI Developer

PBI Developer