Sr PBI Developer 1

Saama; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Saama is seeking a senior BI/Analytics engineer in Pune, India to design and deliver advanced data models and dashboards. You will implement Star Schema models, write high-performance DAX and SQL, and optimize data pipelines for Power BI and Sigma Computing.

You will also ensure data quality, governance, and robust user experiences for executives, claims teams, and underwriters, with adherence to IBCS standards and modern ALM tooling.

Qualifications

• 6+ years in data analytics focused on Power BI and Sigma computing.
• Proven experience with Insurance data (Life, P&C, or Health).
• Expert-level SQL (T-SQL/PL-SQL) with window functions and performance tuning.
• Deep understanding of CALCULATE, filter context, transition context, and evaluation context.
• Proficiency with DAX Studio, Tabular Editor, and ALM Toolkit.

Responsibilities

• Data Modeling and DAX development for optimized dashboards.
• Design and implement Star Schema models for the VertiPaq engine.
• Write advanced DAX to calculate KPIs like Loss Ratios and IBNR.
• Resolve many-to-many relationship challenges in insurance data.
• Create and optimize SQL stored procedures and views for data prep.
• Maximize query folding in Power Query (M) to speed refresh.
• Profile and validate data against the source of truth.
• Build executive dashboards following IBCS standards.
• Use Bookmarks, Field Parameters, and Drill-throughs for UX.
• Design and maintain Sigma Data Datasets and cloud views.
• Create write-back data apps and Sigma workflows.
• Tune Sigma calculations and warehouse queries for performance.
• Oversee administration and governance.
• Manage Power BI Premium capacity and RLS.
• Set up On-Prem Data Gateways and refresh schedules.
• Lead deployment using ALM Tooling Deployment Pipelines.

Skills

DAX

Power BI

SQL

Data Analytics

Data Modeling

Insurance Data

Performance Tuning

Row-Level Security

Window Functions

CTEs

Tools

DAX Studio

Tabular Editor

ALM Toolkit

Job description

• Design and implement Star Schema data models optimized for the VertiPaq engine.
• Write advanced, performant DAX (Time Intelligence, Row-Level Security, and complex filtering) to calculate insurance KPIs like Loss Ratios, IBNR (Incurred But Not Reported), and Persistency.
• Tackle many-to-many relationship challenges common in insurance data (e.g., one policy with multiple claimants).
• Develop and optimize complex SQL Stored Procedures and Views to preprocess data before it hits Power BI.
• Ensure Query Folding is maximized in Power Query (M) to reduce refresh times.
• Perform data profiling and validation to ensure the "Source of Truth" matches the dashboard.
• Build intuitive, executive-ready dashboards that follow IBCS (International Business Communication Standards) or similar best practices.
• Utilize advanced features like Bookmarks, Field Parameters, and Drill-throughs to provide a seamless user experience for claims adjusters and underwriters
• Sigma Computing
• Semantic Layer & Data Datasets: Design, construct, and maintain scalable Sigma Data Datasets, custom SQL views, and logical models directly on cloud data warehouses.
• Write-back & Actionable Data Apps: Build advanced Sigma workflows using input tables, parameters, and action controls to support operational analytics and write-back functionality.
• Performance Tuning: Optimize Sigma calculations, materialized views, and underlying warehouse queries (pushdown SQL optimization) to handle large-scale datasets with high responsiveness.
• Administration & Governance
• Manage Power BI Premium Capacity, Workspace permissions, and Row-Level Security (RLS).
• Set up and maintain On-Premises Data Gateways and automated refresh schedules.
• Lead the deployment process using ALM Tooling (Deployment Pipelines).

Key Responsibilities

• Data Modeling & DAX (The Engine)
• Design and implement Star Schema data models optimized for the VertiPaq engine.
• Write advanced, performant DAX (Time Intelligence, Row-Level Security, and complex filtering) to calculate insurance KPIs like Loss Ratios, IBNR (Incurred But Not Reported), and Persistency.
• Tackle many-to-many relationship challenges common in insurance data (e.g., one policy with multiple claimants).Backend & SQL Engineering
• Develop and optimize complex SQL Stored Procedures and Views to preprocess data before it hits Power BI.
• Ensure Query Folding is maximized in Power Query (M) to reduce refresh times.
• Perform data profiling and validation to ensure the "Source of Truth" matches the dashboard.
• Visualization & UX Design
• Build intuitive, executive-ready dashboards that follow IBCS (International Business Communication Standards) or similar best practices.
• Utilize advanced features like Bookmarks, Field Parameters, and Drill-throughs to provide a seamless user experience for claims adjusters and underwriters
• Sigma Computing
• Semantic Layer & Data Datasets: Design, construct, and maintain scalable Sigma Data Datasets, custom SQL views, and logical models directly on cloud data warehouses.
• Write-back & Actionable Data Apps: Build advanced Sigma workflows using input tables, parameters, and action controls to support operational analytics and write-back functionality.
• Performance Tuning: Optimize Sigma calculations, materialized views, and underlying warehouse queries (pushdown SQL optimization) to handle large-scale datasets with high responsiveness.
• Administration & Governance
• Manage Power BI Premium Capacity, Workspace permissions, and Row-Level Security (RLS).
• Set up and maintain On-Premises Data Gateways and automated refresh schedules.
• Lead the deployment process using ALM Tooling (Deployment Pipelines).

Technical Requirements

• Experience: 6+ years in Data Analytics, dedicated to Power BI & Sigma Comouting
• Insurance Domain: Proven experience working with Insurance data (Life, P&C, or Health). Understanding of policy lifecycles is a massive plus.
• SQL Mastery: Expert-level SQL (T-SQL/PL-SQL) including window functions, CTEs, and performance tuning.
• Sigma Computing : Design, construct, and maintain scalable Sigma Data Datasets, custom SQL views, and logical models directly on cloud data warehouses.
• DAX Expert: Deep understanding of CALCULATE, filter context, transition context, and evaluation context.
• Tools: Proficiency in DAX Studio, Tabular Editor, and ALM Toolkit for model optimization.