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.