Senior Associate

Voya India; Pune District; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Voya India is seeking a detail-oriented insurance/accounting operations professional with strong Oracle, advanced Excel, and VBA macro expertise. Candidates with knowledge in accounting, automation, and an eagerness to learn the business will be considered.

Responsibilities include preparing reinsurance accruals, settlements, journal entries, and financial reports, while supporting group reinsurance activities and monthly/quarterly accounting across various insurance books.

Qualifications

• Detail-oriented operations professional with strong Oracle, advanced Excel, and VBA macro expertise.
• Solid accounting knowledge with GAAP/IFRS understanding may be considered.
• Ability to extract, validate, and reconcile data from multiple sources including Oracle and Excel workbooks.

Responsibilities

• Prepare and review reinsurance accruals, settlements, reconciliations, journal entries, and reports.
• Support Group Reinsurance activities including premiums, claims, commissions, and investment income.
• Assist monthly, quarterly, and annual accounting across Life, STD, LTD, and other books.
• Develop and maintain Excel VBA macros to automate data cleansing, formatting, and reporting.

Skills

Detail orientation

Willingness to learn

Automation mindset

Education

Bachelor's degree in accounting or related

Tools

Oracle

Excel

VBA

Job description

Voya India (earlier VFISLK) started out as a joint venture between U.S. financial services company Voya Financial and SLK, a software services company and is head quartered at Bangalore. As of Aug 2023, we are a wholly owned subsidiary of Voya Financial. We are a dynamic technology & business process transformation company that provides world-class technology & business process management services, with an emphasis on quality, speed & optimization driven through automation. We support and deliver innovative solutions to Voya's Retirement, Employee Benefits, and Investment Management businesses.
More information about us is available at: https://www.voyaindia.co

Role Summary

A detail-oriented insurance or accounting operations professional with strong Oracle, advanced Excel, and VBA macro expertise. Candidates with solid accounting and automation skills, basic insurance or reinsurance knowledge, and a strong willingness to learn the business may also be considered.

Prepare and review reinsurance accruals, settlements, reconciliations, journal entries, wire-support files, and financial reports.

Support Group Reinsurance activities involving premiums, claims, commissions, experience refunds, suspense items, investment income, and other assigned transactions.

Assist with monthly, quarterly, and annual accounting activities across Life, STD, LTD, Employer Stop Loss, Health Solutions, EB and discontinued insurance books.

Extract, validate, and reconcile data from Oracle, Excel workbooks, source systems, and supporting reports.

Prepare Oracle journal-entry upload templates and investigate rejected or failed entries.

Perform GAAP and STAT accounting-related activities, where applicable.

Develop and maintain Excel VBA macros to automate data cleansing, formatting, consolidation, reconciliation, journal-entry preparation, and report generation.

Troubleshoot Excel formulas, macros, file links, PivotTables, and large datasets.

Perform variance analysis, prior-period comparisons, and exception investigations.

Ensure adherence to maker-checker controls, business deadlines, audit requirements, and documentation standards.

Maintain SOPs, process flows, control checklists, and training materials.

Participate in process transitions, cross-training, Kaizen, and continuous-improvement initiatives.

Explore opportunities to use Power Query, Power BI, Office Scripts, and Copilot for further process automation.

Desired Experience and Skillset

Bachelor's degree in accounting, MBA-Finance, Commerce, Business Administration, Insurance, or a related discipline.

Relevant experience in insurance, reinsurance, finance, accounting operations, or shared services.

Basic knowledge of insurance and reinsurance concepts.

Excellent Command over English .

Understanding of accruals, settlements, journal entries, general ledger, reconciliations, and variance analysis.

Hands-on experience with Oracle or a comparable ERP/accounting system.

Advanced Microsoft Excel skills, including:

• XLOOKUP or equivalent functions
• SUMIFS and advanced formulas
• Data validation
• Large-data management

Education

Bachelor's degree in accounting, MBA-Finance, Business Administration, Insurance, or related discipline.