1985103-Manager

EXL; Gurugram District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

EXL Analytics invites a Reserving Data Analyst to join our Gurgaon-based analytics team. You will support in creating data definitions for reserving subsets, code in Databricks, and maintain expense and reserve models, enabling accurate actuarial insights across multiple client sectors.

The role requires strong Excel, Databricks, and SQL skills, with 5–6 years actuarial experience preferred; affiliation to IAI/IFOA is a plus.

Qualifications

• Bachelor’s/Master's degree in engineering, economics, mathematics, actuarial sciences or statistics.
• Affiliation to IAI or IFOA with 2–6 CT actuarial exams is advantageous.
• Strong analytical and problem-solving abilities with data-driven decisions.

Responsibilities

• Support in the creation and update of data definitions for reserving subsets.
• Code in Databricks to encode claims datasets for analysis and reconciliation.
• Maintain expense processes while improving them to goal state levels.
• Develop tracking tables for monitoring catastrophe claims.
• Create and enhance templates that estimate actuarial metrics like AvE, PYD, settlement rates.
• Assist in preparation of exhibits for regulatory filing.
• Develop and maintain reserve models in tools like ResQ, Arius.

Skills

Analytical thinking

Problem-solving

Communication skills

Education

Bachelor’s/Master's degree in engineering, economics, mathematics, actuarial sciences or statistics

IAI or IFOA affiliation with 2–6 CT actuarial exams (advantage)

Tools

Databricks

SQL

Excel

ResQ

Arius

Job description

Reserving Data Analyst EXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa. EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision making and embed analytics more deeply into their business processes. Our global footprint of nearly 2,000 data scientists and analysts assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. EXL Analytics serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries. Please visit www.exlservice.com for more information about EXL Analytics.

Role & Responsibilities Overview:

• Support in the creation and update of data definitions to allow for reserving data to be classed into risk-profiled subsets for actuarial analysis
• Coding in Databricks to encode claims datasets per their defined class codes for further analysis and reconciliation against multiple internal sources for credibility & data assurance
• Maintain current expense (Adjustment & Other expense) processes, while improving them to goal state levels
• Develop tracking tables for monitoring catastrophe claims for the client’s book of business
• Create and enhance templates that estimate and track key actuarial diagnostic metrics like AvE, PYD, Settlement rates etc.
• Support with the preparation of exhibits for regulatory filing
• Develop and maintain reserve models in tools like ResQ, Arius etc.
• Identify opportunities for seamless integration with downstream processes
• Assist in the development and enhancement of other actuarial tools, models, and processes to improve accuracy and efficiency.
• Provide support with the preparation of financial reports, recons and dashboards.
• Stay updated with best practices in actuarial and insurance terminology.
• Mentor and provide guidance to junior team members as needed.

Candidate Profile:

• Bachelor’s/Master's degree in engineering, economics, mathematics, actuarial sciences or statistics.
• Affiliation to IAI or IFOA, with 2-6 CT actuarial exams will be an added advantage 5-6 years Actuarial experience in the P&C insurance industry Good knowledge of insurance terms Advanced skills in Excel, Databricks, SQL, and other relevant tools for data analysis and modeling.
• Familiarity with reserving tools like ResQ, Arius is preferred Excellent analytical and problem-solving skills, with the ability to analyze complex data and make data-driven decisions.
• Strong communication skills, including the ability to effectively communicate actuarial concepts to both technical and non-technical stakeholders.
• Ability to work independently and collaboratively in a team-oriented environment.
• Detail-oriented with strong organizational and time management skills.
• Ability to adapt to changing priorities and deadlines in a fast-paced environment.

What we offer:

EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants. You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques. We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors. Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond.