Mis Executive

Family Health Plan (FHPL); Hyderabad; On-site; INR 420,000 - 700,000; Full time

Job summary

Family Health Plan (FHPL) in Hyderabad is seeking a detail-oriented analyst to monitor and manage insurance claim payments, approvals, rejections and settlements. You will generate performance reports for management and finance teams, and ensure data accuracy across claims and core systems.

The role requires strong Excel skills, knowledge of claim lifecycles, TPA operations, and basic financial auditing, with a focus on precision and audit trails in a regulated environment.

Qualifications

• Advanced Microsoft Excel skills, including Pivot Tables, VLOOKUP, XLOOKUP, SUMIFS and Macros.
• Familiarity with health insurance claim lifecycles, TPA operations and financial auditing basics.
• High precision in handling numeric data, detecting payment anomalies and maintaining audit trails.

Responsibilities

• Monitor daily, weekly, and monthly insurance claim payments, approvals, rejections, and pending settlements.
• Generate and distribute regular claims performance and payment status reports to management and finance teams.
• Cross-verify claim documents and core system data for accuracy and completeness.
• Track claim processing timelines to ensure payments are settled within defined Service Level Agreements (SLAs) and regulatory guidelines.
• Liaise with the claims adjudication team, finance/accounts department, and IT support to resolve data discrepancies or stuck payments.

Skills

Attention to detail

Numerical accuracy

Audit trails

Tools

Pivot Tables

VLOOKUP

XLOOKUP

SUMIFS

Macros

Job description

Role & responsibilities

• Monitor daily, weekly, and monthly insurance claim payments, approvals, rejections, and pending settlements.
• Generate and distribute regular claims performance and payment status reports to management and finance teams.
• Cross-verify claim documents and core system data for accuracy and completeness.
• Track claim processing timelines to ensure payments are settled within defined Service Level Agreements (SLAs) and regulatory guidelines.
• Liaise with the claims adjudication team, finance/accounts department, and IT support to resolve data discrepancies or stuck payments.

Preferred candidate profile

• Advanced Microsoft Excel skills, including Pivot Tables, VLOOKUP, XLOOKUP, SUMIFS and Macros.
• Familiarity with health insurance claim lifecycles, TPA operations and financial auditing basics.
• High precision in handling numeric data, detecting payment anomalies and maintaining audit trails.