Calculation Specialist - UK Pension

Job Description

Role Summary This role will be responsible for calculation programming, data installations, and automation support on various tools during different stages of implementation. This includes the maintenance of updates to existing procedures, policies and manuals as required by the administration businesses. Candidate will be responsible for the completion of all process, procedure and training related tasks, which form part of an UK Implementations. Key Responsibilities Ability to creatively find workarounds and good problem-solving capability Client Communications and reviews Process reporting and Training Ensuring compliance of all internal and client policies Updation of process documents Build requirements docs, specs or sample calcs for development support and testing Build Test Production Packs, automation on system using available and approved tools. Able to identify opportunities to automate and innovate within the system Able to analyse, map and structure data from excel sheets/external sources for loading into SQL server Contribute testing efforts of multiple projects from inception to post implementation. Contribute testing efforts to User Acceptance Testing by executing test scripts and documenting the results. Works closely with the team to build, implement new requirements and test the impact on users with new procedures and controls. Log and review tasks and defects in excel or defect tracking tool (Jira). Learn and understand business specific domain. Knowledge & Skills Required: Good communication skills Proficient in Excel Exposure to Midas, CSIDE and TDC Good knowledge of Pensions - Preferably UK Pensions Proficient in VBA/ Excel programming Good Knowledge of SQL programming Good Analytical Skills Documentation skills for preparing user guides, project manual, issue logs etc. Automating calculations (Scheme Benefit) Good Data mapping, data analysis, data loading and data validation skills. Data Installations (Prepare Load files, Program data installation criterias) VBA Macro development for process improvements and data interface set-up Hands on experience in Excel. Excellent verbal and written communication, interaction with others and time management skills. Knowledge of programming in VB.net and C# will be an advantage Knowledge of system integration with websites using API/Webservices will be an advantage.