BI Developer

Kshema General Insurance Limited; Secunderabad; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Kshema General Insurance Limited seeks a Power BI Developer to design, build, and maintain dashboards that drive decisions in the General Insurance domain. You will model data, optimize DAX, and integrate diverse sources to deliver scalable reporting solutions for product, IT, and business teams.

You will translate complex datasets into clear visuals, enforce security, and collaborate across teams to embed insights into decision processes with measurable impact.

Qualifications

• 2–5 years of Power BI development experience in enterprise environments.
• Strong data modeling skills including Star Schema and Snowflake concepts.
• Proficient in DAX optimization and performance tuning techniques.
• Hands-on experience with Power Query and data transformation.
• Solid SQL knowledge and familiarity with data warehouse concepts.
• Experience implementing CI/CD for BI solutions and security practices.

Responsibilities

• Design, build, and maintain interactive Power BI dashboards and reports.
• Create scalable data models and semantic layer for multiple domains.
• Optimize DAX queries and tune performance across datasets and reports.
• Implement Power Query transformations for data prep and automation.
• Manage access controls, security policies, and publishing of dashboards.
• Collaborate with IT, Product, and Business teams to deliver insights.

Skills

Power BI development

Data modeling

DAX optimization

Power Query

SQL skills

DevOps CI/CD

Azure analytics

Tools

PostgreSQL

MS Fabric

SharePoint

MS Planner

Azure DevOps

Azure SQL Server

Job description

We are seeking a Power BI Developer with 2–5 years of experience to design, build, and maintain dashboards and reports that provide actionable insights. The role requires strong technical skills in data modeling, DAX optimization, and integration with enterprise data sources. You will collaborate with Product, IT, and Business teams to deliver scalable and reliable reporting solutions that support data‑driven decision making, particularly within the General Insurance domain.

Key Responsibilities

Dashboard Development & Delivery

• Develop interactive dashboards, reports, and paginated reports using Power BI.
• Build advanced data models including Star Schema, Snowflake, and Composite Models.
• Optimize DAX queries and perform performance tuning across datasets and reports.
• Implement Power Query transformations for efficient data preparation.
• Manage workspace access, role assignments, and secure publishing of dashboards.

Standards & Best Practices

• Apply enterprise Power BI development standards, patterns, and best practices.
• Build semantic models and reusable datasets under established guidelines.
• Implement visualization standards, naming conventions, and metadata documentation.

Data Security

• Configure and enforce Row‑Level Security (RLS), workspace security, and access governance.

Performance Optimization

• Improve performance across datasets, data models, reports, and workspaces.
• Monitor dashboard usage and implement enhancements.

Visualization Storytelling

• Translate complex datasets into clear, compelling visual narratives for decision‑makers.
• Design dashboards that highlight trends, KPIs, and actionable insights in a user‑friendly way.

Advanced Analytics Integration

• Incorporate predictive models, statistical analysis, and advanced KPIs into dashboards.
• Collaborate with Data Science teams to embed machine learning outputs into Power BI solutions.

Domain Knowledge – General Insurance

• Develop dashboards and reports tailored to insurance portfolios, claims, underwriting, and risk management.
• Apply understanding of insurance KPIs such as loss ratios, claim frequency/severity, premium trends, and exposure analysis.
• Support actuarial, risk, Operations, and business teams with data‑driven insights for decision making.

Collaboration & Enablement

• Work with Product Owners and Business stakeholders to translate requirements into effective dashboards.
• Coordinate with IT, IT Security and DevOps teams for infrastructure provisioning, deployment, and troubleshooting.
• Provide training and support to business users on dashboard usage and self‑service analytics.
• Promote a culture of accountability, innovation, and continuous improvement in reporting practices.

Requirements – Qualifications / Skills / Experience

• 2–5 years of experience in Power BI development.
• Strong foundation in advanced data modeling (Star Schema, Snowflake, Composite Models).
• Expertise in DAX optimization and performance tuning.
• Proficiency in Power Query / data transformation.
• Hands‑on experience with source connections including PostgreSQL, MS Fabric, SharePoint, MS Planner, and Azure DevOps.
• Strong SQL skills with understanding of data warehouse architecture.
• Experience with Azure / SQL Server‑based analytics platforms.
• Experience implementing DevOps practices and CI/CD pipelines for Power BI.
• Ability to configure and enforce data security strategies, including RLS and workspace governance.
• Domain knowledge in General Insurance, including claims, underwriting, and risk analytics.

Professional Competencies

• Strong analytical and problem‑solving skills.
• Attention to detail with ability to handle complex data.
• Ability to explain insights and technical concepts clearly to business users.
• Strong written and verbal communication for documentation and collaboration.
• Team player with a proactive approach to tasks and projects.

Good to Have

• Experience with Microsoft Fabric.
• Exposure to data lakes, Lakehouse architecture, and modern analytics platforms.