This job has been closed, and is no longer taking applications.
Categories: Information Technology
The Workbook Developer is responsible for all design, development, unit testing and documentation tasks required to implement clients onto Fidelity's Workbook platform that is primarily used to audit the calculations from the Blaze Engine and to perform otherwise non-automated calculations.
The Workbook Developer:
• Is expected to have experience with programming of benefit calculations, spreadsheets, and database applications.
• Should have the analytical, programming and defined benefit skills to implement new requirements changes and address identified defects in existing client Workbooks.
• Is expected to have a solid understanding of the software development process including analysis, design, coding, system and user testing.
• May be responsible for multiple concurrent projects and may be requested to mentor less experienced Developers or Pension Benefit Consultants on Workbook development.
• Analyze and convert business requirements as appropriate into the development of the calculation spreadsheet.
• Ensure that all design, and development solutions adhere to existing standards and methodologies.
• Update technical system design specifications based on independent Plan Rule updates as required.
• Apply standard calculation spreadsheet methodology as appropriate.
• Complete development of the calculation spreadsheet that meets the scheduled release date provided for in the project plan (i.e., design, develop, test, regression, certify and release).
• Support and coordinate with project teams on all Workbook development issues.
• Escalate project issues as appropriate
• Complete thorough unit and workbook integration testing to ensure development is delivered on time and in conjunction with defined release management practices.
• Review the test matrix, test lives and criteria and identify missing or additional test cases.
• Participate in the self-certification of the DB Actuarial Workbook.
Education and Experience
• Bachelor's degree in math, finance, computer science, actuarial science or other related subject.
• The Actuarial Application Developer will typically have a minimum of 3-5 years of development experience preferably in the defined benefits area.
• Experience with programming and unit testing of defined benefit calculations, spreadsheets, and database applications.
• Experience working both independently and as a team member coordinating tasks and working with business and systems counterparts to resolve issues in a fast paced environment.
Skills and Knowledge
• Detailed knowledge of actuarial concepts and calculation methods: actuarial factors, commutation functions.
• Proficient in programming Excel based workbooks and spreadsheets, using complex formulas / macros.
• Proficient in VBA or Visual Basic.
• Experience with Microsoft Access, SQL queries and Microsoft Word.
• Strong time management skills and ability to prioritize and handle multiple tasks.
• Excellent writing, communication and time management skills.
• Solid understanding of full Project Life Cycle and software development methodology. (i.e., analysis, design, coding, system and user testing, problem resolution and planning).
• Solid business analysis, problem solving and testing techniques.
• Ability to thrive in a matrix-managed environment across multiple locations and functions.
• Experience creating and maintaining comprehensive yet concise technical documentation a plus.
About Fidelity Investments
Fidelity Investments is one of the world's largest providers of financial services. Founded in 1946, the firm is a leading provider of investment management, retirement planning, portfolio guidance, brokerage, benefits outsourcing and many other financial products and services to more than 20 million individuals and institutions, as well as through 5,000 financial intermediary firms. For more information about Fidelity Investments, visit www.fidelity.com.