Calc Analyst - UK Pensions PORTRAY PEOPLE PRIVATE LIMITED
PORTRAY PEOPLE PRIVATE LIMITED
Office Location
Full Time
Experience: 3 - 3 years required
Pay: INR 1800000 - INR 2000000 /year
Type: Full Time
Location: Bangalore
Skills: Documentation, Macros, VBA, pension schemes, actuarial consulting, calculator, SQL, Advanced Excel, pension systems, Insurance operations
About PORTRAY PEOPLE PRIVATE LIMITED
Job Description
What You will Do
- Translate UK defined-benefit pension specs into working Excel/VBA calculators
- Design and document calculation requirements, assumptions and test cases
- Build, optimize and maintain Excel macros to drive large-scale pension valuations
- Collaborate with actuarial, IT and testing teams to ensure accuracy and performance
- 3-8 yrs as a calculation analyst in UK pension or insurance domain
- Expert-level VBA & Excel macros development
- Deep knowledge of defined-benefit (DB) pension calculations, schemes and terminology
- Proven track record in writing clear specification documents
- Experience with data-warehouse or SQL-based pension data extracts
- Familiarity with actuarial tools (e.g., Prophet, MoSes) or automated testing frameworks
- Prior consulting experience supporting UK-based clients