Calculation Analyst

Position: Calculation Analyst (Consultant / Senior Consultant / Delivery Manager)

Location: Mumbai / Bangalore / Gurgaon (Hybrid)

Domain: UK Pensions / Insurance

Role Overview:

We are seeking skilled and detail-oriented Calculation Analysts at various experience levels to support our UK-based pension and insurance clients. In this role, you will be responsible for designing, developing, and maintaining robust Excel-based calculation tools that drive complex pension valuations. This is a high-impact role that sits at the intersection of actuarial modeling, technology, and data analysis.

Key Responsibilities:

• Translate UK defined-benefit pension scheme rules and documentation into efficient Excel/VBA-based calculation tools.
• Develop, document, and maintain clear calculation logic, assumptions, and test cases.
• Build and optimize Excel macros to support large-scale pension data processing and valuation tasks.
• Ensure accuracy and compliance through collaboration with actuarial, IT, and QA teams.
• Provide technical insights to enhance tool performance and maintainability.

Required Skills & Experience:

• 3–8 years of experience as a Calculation Analyst within the UK pensions or insurance domain.
• Advanced proficiency in Excel and VBA macro development.
• Strong understanding of defined-benefit (DB) pension schemes, terminology, and UK regulatory environment.
• Demonstrated ability to write clear, precise, and comprehensive specification documents.
• Strong analytical and problem-solving skills, with keen attention to detail.

Preferred Qualifications:

• Experience working with SQL or pension-related data warehouses.
• Exposure to actuarial software tools such as Prophet or MoSes.
• Familiarity with automated testing frameworks and test case development.
• Prior consulting experience working with UK-based clients.

Why Join Us:

Join a dynamic, collaborative environment where your technical expertise in pensions can make a real impact. You'll work on mission-critical projects for UK clients and have the opportunity to grow your career through a mix of hands-on development, client exposure, and cross-functional collaboration.