DE&A - Core - Advanced Visualization & Cloud Reporting - Power BI

Zensar Technologies · IT Services & Consulting

Pune, Maharashtra, India
On-site
Posted today
Closes today
Data & AI

Apply on Zensar Technologies Create resume for this job

About the job

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

Apply on Zensar Technologies