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.
Job Description: Salesforce Developer / Sr Salesforce Developer Company Overview This company is a dynamic technology solutions provider dedicated to engineering robust, scalable, and high-performance enterprise systems. We are seeking a talented and versatile Sr Salesforce Developer to join our engineering team. At this ...
Senior Systems Developer role focused on complex Oracle database application development and support. The position requires extensive experience with APEX, Forms, and PL/SQL, combined with strong analytical and mentoring capabilities for enterprise-level systems. Responsibilities - Perform systems analysis, design, and ...
... Endpoint is headquartered in Raleigh-Durham, North Carolina with offices across the United States, Europe, and Asia. Position Overview: The Senior Software Developer is instrumental in the programming implementation of individual client projects. Working closely with other developers and design managers, you will lead the ...
In This Role, Your Responsibilities Will Be: - Lead the design and development of RESTful and GraphQL APIs using Python frameworks such as FastAPI, Django, and Flask. - Architect scalable backend systems, microservices, and asynchronous workloads using Redis, RabbitMQ.
... execution, you’ll be inspired, connected, developed and rewarded here. Everything that makes you unique is welcome; join us and let’s build what’s next - together! Sr. Applications Developer [Anaplan Model Builder] At Anaplan, we are innovators dedicated to enhancing business decision-making with our AI-powered scenario planning ...
In This Role, Your Responsibilities Will Be: - Develop and maintain desktop applications using C++ and MFC (Microsoft Foundation Classes). - Utilize STL for implementing efficient data structures and algorithms. - Design and implement multithreaded solutions to improve application performance and responsiveness.
Actively hiring SR React Developer Start Date Starts Immediately CTC (ANNUAL) ₹ 3,60,000 - 10,80,000 ₹ 3,60,000 - 10,80,000 /year Experience 1 year(s) 1 year(s) Apply By 31 Oct' 26 Posted 3 weeks ago Job 157 applicants About the job We are looking for a skilled https://jobeax.com/link/6WcBICn0LM558SP0 Developer with 2+ ...
... industry's top coding best practices. You will work in a full stack agile team comprising of Architects, Technical Leads, Scrum Masters, Business Analysts, Developers, QA automators, and DevOps experts. You will report to the team manager. Career Path: As a Developer, you will have an accelerated growth path into Dev Lead, ...
Regeneron seeks a Senior Associate Scientist I in Hyderabad to support quantitative biomarker research through bioinformatics data analysis, pipeline automation, quality control, and cross-study data integration.
... around the world. Join Visa and do work that matters – to you, to your community, and to the world. Progress starts with you. Job Description The Opportunity As a Sr Software Engineer, you will be part of a cross‑functional Agile team responsible for building and supporting software components and features within Visa’s network ...
Purpose of Job ScaleupAlly is looking for a Senior Power BI Developer with strong expertise in Power BI SQL DAX data modeling and BI along with a solid understanding of data engineering and modern data platforms . The role involves building end-to-end BI solutions including data transformation modeling dashboard development ...