Hiring.Camp

Analyst II, Business Intelligence, India

Resourcepro

·

2 days ago

Location
IND Bagmane Tech Park, India
Type
Full-time
Source
Workday

Description

UNLEASH YOUR BEST SELF
JOIN. LEARN. ADVANCE. EARN

YOUR PASSION FOR EXCELLENCE STARTS HERE!!

1. Analytics & Dashboarding - 50%

Conducts the design and development of interactive dashboards, reports, scorecards, and analytical views to meet defined business needs.

Researches reporting requirements with business stakeholders and contributes to aligning dashboards to agreed KPI definitions and business rules.

Creates business-friendly visualizations for operational, financial, and executive reporting.

Builds dashboards for insurance KPIs such as: Written premium, Earned premium, In-force premium, Loss ratio, Combined ratio, Claims frequency, Claims severity, Quote-to-bind ratio, Renewal ratio, Policy retention, Producer/agency performance, Commission trends.

Analyzes data from insurance systems related to: Policy administration, Underwriting, Quotes and submissions, Claims, Billing, Commissions, Reinsurance, Agency/broker performance, Customer retention, etc.

Develops enhanced user experience features including drill-down, drill-through, slicers/filters, bookmarks, tooltips, and KPI cards.

Publishes reports and tracks workspace configuration, refresh schedules, and access controls; escalates issues and risks as needed.

2. Data Analysis & Insight Generation - 25%

Conducts data analysis to identify patterns, trends, variances, and actionable insights for business partners.

Reviews business questions and translates them into analytical outputs (dashboards, KPI scorecards, and ad hoc analyses) using established approaches.

Creates executive summaries and data-driven recommendations based on dashboard findings; contributes to stakeholder readouts and recurring performance reviews.

Supports business teams in interpreting dashboard results and making informed decisions; provides guidance on metric definitions and appropriate usage.

Performs root-cause analysis for issues such as declining retention, increasing loss ratios, premium leakage, or claims delays, and proposes follow-up analyses to confirm drivers.

3. Data Modeling & Transformation - 15%

Builds and maintains data models using star schema / dimensional modeling principles and established internal standards.

Develops calculated measures and KPIs using DAX; reviews and refines existing measures for accuracy and reusability.

Uses Power Query / M language for data cleaning, transformation, and shaping; documents key assumptions and transformation logic.

Works with structured and semi-structured data from:

SQL databases, data warehouses

Excel/CSV files

APIs and cloud platforms

Insurance policy and claims systems

Collaborates with data engineering teams to validate source data, curated datasets, and data pipelines; contributes to requirements and testing for new or updated data feeds.

.

4. Quality, Governance & Performance - 10%

Validates reports against source systems and business rules; tracks reconciliation results and data quality findings.

Ensures accuracy, consistency, and reliability of reported metrics; supports standardization of KPI definitions and report templates.

Optimizes report performance, dataset refresh time, and DAX calculations; proposes improvements when performance issues are identified.

Implements row-level security and access controls following established governance practices.

Maintains reusable datasets and standardized reporting components; supports adoption of certified datasets where applicable.

Supports production issue analysis, defect fixes, and enhancement requests; participates in release testing and post-deployment validation.

If you have the willingness to learn and develop your skills, we have the right job for you. Let’s make a deal!

Not the right fit?  Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest!

Skills

SQLData EngineeringExcelUnderwriting

Similar Jobs

30

Business Analyst II

Coherehealth · United States

6 days ago

Business Analyst II

WoodmenLife · WoodmenLife Home Office, 1700 Farnam Street, Omaha, Nebraska, United States of America · Remote

1 week ago

Business Analyst II

Elevancehealth · NY-LATHAM, 15 PLAZA DR, United States of America +5 · Remote, Hybrid

1 week ago

Business Analyst II

Td · TD Centre - TD Tower - 66 Wellington Street West, Toronto, Ontario, Canada · Hybrid

1 week ago

Business Analyst II

Elevancehealth · VA-NORFOLK, 5800 NORTHAMPTON BLVD, United States of America +3 · Remote, Hybrid

1 week ago

Business Analyst II

Our Talent Community by submitt · Columbia, South Carolina, United States of America · Onsite

2 weeks ago

Business Analyst II

Chess · Student Services Center Rm 105, United States of America

2 weeks ago

Business Analyst II

32BJ Benefit Funds · New York, NY

3 weeks ago

Business Analyst II

Global Payments · Xian - AN, China · Hybrid

3 weeks ago

Business Analyst II

Old National Bank · St Louis Park, MN, US +2

3 weeks ago

Business Analyst II

Americanfidelity · Oklahoma AF Corporate Home Office, United States of America

1 month ago

Business Analyst II

Mastercard · Bogota, Colombia

1 month ago

Business Analyst II

Mastercard · Bogota, Colombia

1 month ago

Business Analyst II

Takeda is an industry · MEX - Santa Fe, Mexico

1 month ago

Business Analyst II

Fairfax County · FAIRFAX (EJ32), VA, VA, US

1 month ago

Business Analyst II

Fairfax County · FAIRFAX (EJ27), VA, VA, US

1 month ago

Business Analyst II

Icwgroup · Innovation Point, United States of America

1 month ago

Business Analyst II

Mastercard · Bogota, Colombia

1 month ago

Analyst II, Business

MP0001-WM Logistics India Private Ltd · Houston, TX, United States · Hybrid

1 month ago

Business Analyst II

Cherokee Federal · Atlanta, GA, United States, US · Onsite

1 month ago

Business Analyst II

ETE Reman · Milwaukee, WI

1 month ago

Business Analyst II

JPMorgan Chase · Columbus, OH, United States

2 months ago

Business Analyst II

JP Morgan Chase · Columbus, OH, United States

2 months ago

Business Analyst II

Yum Restaurant Services Group · Ho Chi Minh, Dong Nam Bo, Viet Nam, VN · Hybrid

2 months ago

Business Analyst II

Sault Tribe Incorporated · Remote-Nationwide · Remote

2 months ago

BUSINESS ANALYST II

"Formosa Plastics Corporation, USA" · 9 Peach Tree Hill Rd, Livingston, NJ 07039, USA

2 months ago

Business Analyst II

Encora · Peru

2 months ago

Business Analyst II

GAINSCO · Richardson, TX

2 months ago

Business Analyst II

Fis · POL WRSW Virtual, Poland · Remote

2 months ago

Business Analyst II

Pacificlife · Newport Beach CA-700, United States of America · Hybrid

2 months ago