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).
2. 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.
3. 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
4. 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.
5. 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.
We Make Life More Rewarding and Dignified Location : Gurgaon Department : 36696 Summary The Sr. Data Developer I designs, develops, and supports scalable data solutions that enable enterprise analytics, reporting, and data-driven decision making. This role works across data integration, transformation, modeling, quality, ...
... protecting the environment, making sure our food is safe or helping find cures for cancer. Summarized Purpose Join ThermoFisher Scientific as a Senior Systems Developer and help build the software platforms that support scientific workflows and customer outcomes. You will design, develop, and maintain secure, scalable Java ...
... Computer Science, Information Technology, Engineering, or related discipline, or equivalent practical experience. Certification and/or Licenses SAP Backend Developer – ABAP Cloud SAP Backend Developer – Cloud Application Programming Model Any SAP Development Cloud related certification Experience - functional/industry/commercial ...
Roles & Responsibilities: - Shift, Day, Weekly& monthly Production plan achievement, adherence - Quality system adherence - Gravity die casting, Melting, Metal treatment process control adherence record maintenance - Set up record, Set up time adherence control - First off approval record review, Approval - Daily
Sr. AI / ML Research Engineer Description - External At Trane Technologies and through our businesses including Trane and Thermo King, we create innovative climate solutions for buildings, homes, and transportation that challenge what’s possible for a sustainable world. We’re a team that dares to look at the world’s challenges ...
We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential.
Senior Visualiser | Location: Mumbai / Hyderabad Role Summary We're looking for a multidisciplinary Senior Visualiser who can move fluidly across design, art direction, and content formats — translating creative briefs and cultural insights into strong visual concepts across brand, campaign, and content deliverables
Be a part of our mission! As a world leader in creating comfortable, sustainable, and efficient climate solutions for buildings, homes and transportation, it's our responsibility to put the planet first.
We’re looking for a sharp, imaginative Senior Copywriter who can craft compelling brand stories, lead creative thinking, and elevate content across campaigns. You’ll work closely with the creative team to deliver ideas that are fresh, strategic, and culturally relevant.
Description Babulal Jewellers is looking for a skilled Sr Accountant to join our dedicated team in Raipur. This full-time, on-site position offers an exciting opportunity to contribute to the financial health of a leading player in the luxury goods and jewelry industry. As a Sr Accountant, you will be responsible for overseeing ...