Power Bi Developer

Synergech; Chennai District; On-site; INR 1,500,000 - 2,200,000; Full time

Job summary

Synergech seeks an experienced Power BI specialist to architect and deliver end-to-end BI solutions for insurance domains across policy administration, claims, underwriting, and reserves.

You will design star schemas, optimize DAX and M queries, mentor junior developers, and collaborate with actuaries and business stakeholders to translate regulatory and operational requirements into auditable analytics.

Qualifications

• 7+ years of BI/analytics experience with 4+ years in Power BI in production environments.
• Insurance industry experience with familiarity of premiums, claims, reserves and loss/combined ratios.
• Expert-level DAX including context transition, time intelligence and CALCULATE patterns.
• Strong dimensional data modeling (star schema) and optimization for large tabular models.
• Advanced SQL and integration with enterprise data sources (SQL Server, Synapse, Databricks).
• Power BI Service administration skills: workspaces, deployment pipelines, gateways, dataset refresh.
• Familiarity with performance and modeling tools like DAX Studio and Tabular Editor.
• Excellent stakeholder communication and ability to translate requirements into analytics.

Responsibilities

• Architect and develop end-to-end Power BI solutions for insurance domains including policy administration, claims, underwriting, premiums, reserving, and loss ratios.
• Design robust star schemas and maintainable DAX for key insurance KPIs.
• Lead data preparation with Power Query and establish reusable ETL patterns.
• Optimize report/model performance through VertiPaq tuning and refactor of DAX.
• Implement enterprise BI standards: RLS, deployment pipelines, version control, and certified datasets.
• Collaborate with actuaries, underwriters, and stakeholders to translate regulatory and operational requirements.
• Integrate Power BI with data warehouses and Azure Synapse/SQL, Databricks, and Dataflows; support DirectQuery/Import/Composite models.
• Provide mentorship and code reviews to junior/mid-level BI developers.
• Ensure data quality, lineage, and regulatory compliance across delivered solutions.

Skills

Power BI

DAX expertise

Insurance analytics

SQL

Dimensional modeling

ETL patterns

RLS governance

Performance tuning

Mentoring

Stakeholder communication

Power Query

Tools

SQL Server

Azure SQL

Synapse

Databricks

Power BI Service

Git

PowerShell

Tabular Editor

DAX Studio

Job description

Key Responsibilities

• Architect and develop end-to-end Power BI solutions semantic data models, DAX measures, reports, and dashboards — for insurance domains including policy administration, claims, underwriting, premiums, reserving, and loss ratios.
• Design robust, scalable tabular data models (star schema) and author optimized, maintainable DAX for complex insurance KPIs such as loss ratio, combined ratio, earned vs. written premium, retention, and claims frequency/severity.
• Lead data preparation and transformation using Power Query (M), establishing reusable, well‑documented ETL patterns and ensuring query folding where possible against source systems.
• Optimize report and model performance — tune the VertiPaq engine, reduce model size, refactor inefficient DAX, and diagnose bottlenecks using DAX Studio, Tabular Editor, and Performance Analyzer.
• Implement and govern enterprise BI standards: row‑level security (RLS), workspace and deployment pipeline management, version control, naming conventions, and certified datasets.
• Collaborate with actuaries, underwriters, claims teams, and business stakeholders to translate regulatory and operational requirements into accurate, auditable analytics.
• Integrate Power BI with the broader data platform — data warehouses, Azure Synapse / SQL, Databricks, and Dataflows — and support DirectQuery, Import, and Composite model strategies as appropriate.
• Mentor and provide technical leadership to junior and mid‑level BI developers through code reviews, best‑practice guidance, and knowledge sharing.
• Ensure data quality, lineage, and compliance with insurance regulatory and data‑privacy requirements across all delivered solutions.

Required skills:

• 7+ years of professional BI/analytics experience, with at least 4 years dedicated to Power BI development in production environments.
• Demonstrable insurance industry experience (P&C, life, health, or reinsurance) and fluency with insurance data and metrics such as premiums, claims, reserves, loss/combined ratios, and underwriting.
• Expert‑level DAX — context transition, time intelligence, CALCULATE patterns, iterators, and variables — and advanced Power Query (M) transformation skills.
• Strong dimensional data modeling expertise (star schema, relationships, cardinality, RLS) and proven ability to optimize large tabular models for performance.
• Advanced SQL and experience integrating Power BI with enterprise data sources (SQL Server, Azure SQL, Synapse, Databricks, or comparable).
• Hands‑on experience with Power BI Service administration — workspaces, deployment pipelines, gateways, dataset refresh, and capacity/Premium concepts.
• Proficiency with performance and modeling tools such as DAX Studio and Tabular Editor.
• Strong stakeholder communication skills, with a track record of translating ambiguous business requirements into delivered analytics.

Preferred Skills:

• Microsoft certification (PL-300 Power BI Data Analyst Associate, or Fabric/Azure data certifications).
• Experience with Microsoft Fabric, Azure Data Factory, or modern lakehouse architectures.
• Exposure to actuarial or regulatory reporting (e.g., IFRS 17, Solvency II, NAIC) within an insurance context.
• Familiarity with version control (Git), CI/CD for BI assets, and PowerShell or the Power BI REST APIs for automation.
• Experience with Python or R for advanced analytics integration within Power BI.