About the role
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 . Found on 1752vc Careers, the job board for startup and VC roles.
What they're looking for
- Sigma Computing : Design, construct, and maintain scalable Sigma Data Datasets , custom SQL views, and logical models directly on cloud data warehouses
More about this role
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
- 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...
Browse similar: Startup jobs · Remote jobs