DEandA - Core - Advanced Visualization And Cloud Reporting - Power BI

Zensar Technologies; Bengaluru Urban; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Zensar Technologies in Bengaluru is seeking a Senior Power BI Developer to drive enterprise-wide report rationalization and transformation for an insurance customer. You will modernize legacy reporting into a self-service BI ecosystem using Power BI on a Snowflake + dbt-based data platform structured as Raw, Silver, and Gold.

You will enable business-led analytics, reduce report redundancy, and deliver scalable, governed reporting solutions.

Qualifications

• 6–10+ years of experience in BI/Analytics with strong Power BI expertise.
• Hands-on experience with Power BI Desktop & Service, DAX, Power Query (M), and 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).
• Experience in Insurance domain (Claims, Policy, Billing, Underwriting) preferred, with understanding of regulatory and operational reporting requirements.

Responsibilities

• Lead assessment and rationalization of existing reports, identifying redundancy and consolidation opportunities.
• Design a target-state reporting architecture aligned with self-service BI principles.
• Build interactive dashboards and reports enabling slicing, dicing, and drill-through analysis.
• Develop paginated reports for regulatory and operational needs.
• Implement complex DAX calculations, KPIs, and semantic models.
• Optimize report performance through data modeling and query optimization.
• Design and consume curated data models from Snowflake (Gold layer) for reporting.
• Collaborate with data engineering to define data transformations in dbt (Silver → Gold).
• Enable business users with governed datasets and reusable semantic layers.
• Define and enforce Power BI governance standards (workspace strategy, naming conventions, versioning).
• Optimize Power BI datasets, queries, and dashboards for performance and scalability; implement incremental refresh and aggregations.

Job description

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 efficient usage of Snowflake resources for reporting workloads

Responsibilities

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)

Qualifications

Domain Expertise

• Experience in Insurance domain (Claims, Policy, Billing, Underwriting) preferred
• Understanding of regulatory and operational reporting requirements

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensarand join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace.

All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.