Analyst II, Business Intelligence, India

ReSource Pro, LLC; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

ReSource Pro, LLC in Bangalore seeks an Analyst II in Business Intelligence to design and develop interactive dashboards and reports. You will translate business questions into analytical outputs, provide data-driven recommendations, and support stakeholders with KPI definitions and governance.

The role emphasizes building dashboards for insurance KPIs and collaborating with data engineering to ensure data quality and timely insights. This is a full-time position based in Bengaluru.

Qualifications

• Design and develop interactive dashboards and reports.

Responsibilities

• Build dashboards for insurance KPIs such as Written premium, Earned premium, In-force premium, Loss ratio, Claims frequency, Claims severity, Renewal ratio.
• Publish reports and tracks workspace configuration, refresh schedules, and access controls; escalate issues and risks as needed.
• Perform root-cause analysis for issues such as declining retention, increasing loss ratios, premium leakage, or claims delays, and propose follow-up analyses.
• Collaborate with data engineering teams to validate source data and data pipelines.

Skills

Dashboard design

Data analysis

KPI definitions

Stakeholder engagement

DAX

Data visualization

Drill-down features

Tools

Power BI

Power Query

M language

SQL

APIs

Job description

## Analyst II, Business Intelligence, IndiaApplylocations: Bangaloretime type: Full timeposted on: Posted 5 Days Agojob requisition id: JR26-0001880UNLEASH 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 warehousesExcel/CSV filesAPIs and cloud platformsInsurance policy and claims systemsCollaborates 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!### ReSource Pro Core Business AdvantageFor any organization, its core capabilities are distinct and not easily replicated by its competitors. This video features 9 executives of ReSource Pro from the United States, China and India delivering a brief overview of our company's core competencies. Please enjoy the following video and learn about our core business advantages: Our core capabilities in business process management, strategic advisory services, management and organic growth consulting, training, and compliance solutions provide a strong foundation to assist and deliver great value to our client, and all this helps us seize new opportunities in the insurance market.### ReSource Pro Bangalore OfficeWe are located in the North Bangalore, conveniently located at Karle Town center near Manyata Tech Park. We have a New York designed modern office, where we enjoy comfortable amenities, hold team activities and refresh ourselves to work with passion for excellence. We look forward to welcoming you to our office. If you have any questions or need further directions, please don't hesitate to contact us.### About UsReSource Pro is an insurance-focused business solutions company that integrates people, process, technology, and data analytics. Over 1,000 carriers, brokers, and MGAs rely on ReSource Pro to execute strategies that improve profitability, accelerate growth, deliver improved claim outcomes, and enhance client and employee experience. With more than 6,000 employees globally, ReSource Pro provides business process management, strategic advisory services, management and organic growth consulting, training, and compliance solutions around the clock. ReSource Pro has been listed as one of the Inc. 5000 Fastest Growing Private Companies annually since 2009 and has consistently achieved a +96% client retention rate for over a decade.