ApplySarthi

Specialist - Process Analytics - Claims & Underwriting 4B

Jobgether

Tailor my CV for this job, freeView job and applyYour CV rewritten for this role, from your real experience. Sign in with Google, nothing to install.

Got this interview? Our apps help you get the job.

Skills named in this job

Read from the description itself, not inferred.

This role on the market

77 open underwriting roles across 16 companies are on ApplySarthi right now, most of them in Delhi NCR (39), Hyderabad (5), Bengaluru (3).

What underwriting roles keep asking for: Excel (16%), SQL (13%) — counted across their open postings here.

Excel jobs · SQL jobs

Jobgether has 4,314 open roles listed here.

Counted across 14 company job boards, updated as roles open and close.

Preparing for this interview

Interviews for underwriting roles keep coming back to Excel, SQL. Practise those questions before you sit with Jobgether.

Questions you are likely to be asked

  1. Why do you want to join Jobgether?
  2. What is your experience with SQL? Tell me one thing you learned the hard way.
  3. Explain a join or a window function you have used, and why you needed it.
  4. How would you explain a surprising number to a manager who does not believe it?
  5. Tell me about an analysis that changed a decision. What did you find?

Prep Sarthi gives you a free mock interview: an AI interviewer asks you questions like these out loud, from your own CV and this job, and shows your score and your weakest answer.

Practise the Specialist - Process Analytics - Claims & Underwriting 4B at Jobgether interview free →

Accountabilities:: As a Process Analytics Specialist, you will manage portfolio analytics and catastrophe modeling activities, ensuring accurate exposure data, reliable modeling outputs, and timely delivery of analytical results. You will apply your understanding of reinsurance structures and risk modeling systems to investigate data variations and generate insights that support effective risk management. Manage Treaty and Facultative Submissions: Review and interpret treaty and facultative (FAC) submissions, ensuring relevant information is accurately captured and applied during portfolio modeling. Update Risk Modeling Accounts: Create, update, and model accounts within RMS RiskLink/AIR, incorporating the appropriate treaty information, terms, and conditions. Process Portfolio Exposure Data: Import and validate portfolio exposure summaries, run catastrophe models, and analyze results to identify relevant risk insights. Investigate Exposure Variations: Perform EDM reconciliations to determine the causes of differences between current and previous portfolio exposure results. Develop and Execute SQL Scripts: Create, modify, and run SQL scripts to support routine processing activities, data validation, reconciliation, and analytical workflows. Generate Risk Management Insights: Analyze client data and modeling outputs to identify trends, discrepancies, and opportunities to improve risk assessment and portfolio management. Maintain Data Accuracy: Apply rigorous validation and analytical practices to ensure data integrity and reliable catastrophe modeling results. Meet Delivery Deadlines: Complete assigned tasks within established timelines while maintaining accuracy and productivity, particularly during monthly portfolio roll-up cycles. Collaborate Across Teams: Work closely with colleagues and stakeholders to resolve analytical issues, share findings, and support efficient portfolio processing. Support Knowledge Sharing: Contribute to coaching and mentoring activities, helping colleagues strengthen their technical skills and understanding of portfolio analytics processes. Improve Operational Efficiency: Identify opportunities to refine day-to-day workflows and enhance the speed, quality, and consistency of analytical delivery. Requirements: The ideal candidate combines practical experience in portfolio analytics and catastrophe modeling with strong technical skills in risk modeling systems, SQL, and Excel. You should be comfortable interpreting complex insurance data, troubleshooting discrepancies, and delivering accurate results under pressure. Professional Experience: 3–5 years of experience in portfolio analytics, catastrophe modeling, or a closely related field. Catastrophe Modeling Expertise: Demonstrated experience with catastrophe models is essential, including the ability to interpret modeling outputs and assess portfolio exposure results. RMS RiskLink/AIR Proficiency: Advanced knowledge of RMS RiskLink/AIR and its backend data schema, including account modeling and portfolio processing. Treaty Modeling Knowledge: Understanding of reinsurance treaty modeling, treaty terms and conditions, and facultative submissions. SQL Skills: Proficiency in writing, modifying, and executing SQL queries and scripts to support data processing, reconciliation, and validation. Microsoft Excel Expertise: Advanced Excel skills, including familiarity with macros and spreadsheet-based analysis. Data Reconciliation and Analysis: Strong analytical capabilities and attention to detail, with the ability to investigate data discrepancies and identify the underlying causes of exposure variations. Academic Qualifications: A bachelor's degree in Business Analytics, Computer Science, or Statistics, or a master's degree in Data Science, is relevant to the role. Time Management: Ability to prioritize workloads, deliver time-sensitive tasks, and maintain quality during demanding monthly portfolio roll-up cycles. Problem-Solving Skills: Strong critical thinking and troubleshooting abilities, with a proactive approach to resolving technical and data-related challenges. Communication Skills: Good written and verbal English communication skills, with an indicated proficiency level of B1 or intermediate. Teamwork and Motivation: Ability to collaborate effectively, demonstrate initiative, and maintain a high level of motivation in a fast-paced environment. Execution and Adaptability: Strong execution speed, flexibility, and the ability to manage work pressure while meeting operational requirements. Coaching and Mentoring: Ability to share knowledge and support the development of other team members. Relevant Certifications: Insurance-related certifications may be beneficial, although specific certifications are not clearly established as mandatory in the posting. Benefits: Remote Work: Fully remote position based in India. Flexible Schedule: Flex-time working arrangements aligned with business requirements. Career Development: Opportunities to expand technical expertise and progress professionally through hands-on experience and challenging assignments. Learning and Mentorship: Access to learning opportunities, mentoring, and professional development. Meaningful Business Impact: Contribute to risk analytics and catastrophe modeling activities that support major enterprise clients. Advanced Technology Exposure: Work with specialized catastrophe modeling systems, SQL, Excel, and data analytics processes. Collaborative Culture: Join a team-oriented environment that values innovation, integrity, curiosity, inclusion, and continuous improvement. Inclusive Workplace: Equal employment opportunity and a commitment to a respectful, diverse working environment. Compensation: No specific salary range or detailed benefits package was provided in the job description.

Match this job to your CV

ApplySarthi scores your CV against this role, shows the skills you are missing, and writes a tailored version for the application.

Check my match →

Similar open roles

Need answers during your interview? Try Live Sarthi.

Live Sarthi, an Interview Sarthi app, shows answer suggestions during the call.

Try Live Sarthi free →

A Windows app, from the same team as ApplySarthi.

Listed on lever · posted 2026-10-29. ApplySarthi collects openings and links to application pages; the role is advertised by Jobgether, not by us.