Lead - Reconciliation Automation

Apex Group Ltd; Pune District; On-site; INR 15,00,000 - 20,00,000; Full time

Job summary

A leading global fund administration provider is seeking a Senior Team Lead to drive automation of fund reconciliation processes. The ideal candidate will have 8–12 years of experience, advanced VBA skills, and a strong understanding of fund reconciliation. Responsibilities include managing automation workflows and mentoring the team. This role is located in Pune/Bangalore and offers the opportunity to enhance operational efficiency.

Qualifications

• 8–12 years of experience in Fund Services, Financial Services, or Fund Administration.
• Strong understanding of reconciliation processes and investment structures.
• Proven ability to lead diverse teams and manage stakeholders.

Responsibilities

• Oversee automation of fund reconciliation workflows within Geneva.
• Design and maintain VBA scripts for data processing and reporting.
• Implement reconciliation solutions using Fund Recs platform.

Skills

Advanced VBA proficiency

Fund Reconciliation knowledge

Data Management

Integration Experience

Leadership & Communication

Tools

Fund Recs

SQL

Job description

The Apex Group was established in Bermuda in 2003 and is now one of the world’s largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.

Your career with us should reflect your energy and passion. That’s why, at Apex Group, we will do more than simply ‘empower’ you. We will work to supercharge your unique skills and experience.

Take the lead and we’ll give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Lead – Fund Reconciliation Automation

Location: Bangalore/Pune
Experience: 8–12 years
Industry/Domain: Fund Services, Advent Geneva, Financial Services, Fund Administration

Role Overview

We are seeking an experienced Senior Team Lead to drive the automation of fund reconciliation processes, with a strong focus on leveraging advanced tools such as VBA and the Fund Recs platform. This role will be critical in accelerating delivery of reconciliations and operational efficiency.

Key Responsibilities

• Lead Automation Initiatives: Oversee and manage the automation of fund reconciliation workflows within the Geneva system environment.
• VBA Development: Design, develop, and maintain efficient VBA scripts and tools to automate data processing, reporting, and reconciliation tasks.
• Fund Recs Integration: Implement and optimize reconciliation solutions using the Fund Recs platform, ensuring seamless data import, automated matching, and enhanced oversight capabilities.
• Stakeholder Collaboration: Partner with business and operations teams to gather requirements and translate them into robust automated processes.
• Data Oversight: Ensure rigorous data validation and quality control using customizable dashboards and reporting tools in Fund Recs.
• Team Leadership: Mentor and guide the automation team, managing priorities for timely project delivery.

Essential Skills & Experience

• Automation Tools: Advanced VBA proficiency for custom automation and practical experience with Fund Recs or similar platforms.
• Fund Reconciliation: Strong understanding of reconciliation processes, complex investment structures, NAV/GAV, fee calculations, and PnL allocations.
• Data Management: Experience with data validation, automated matching, exception handling, and break resolution.
• Integration Experience: Familiarity with data vendors and integrating external/legacy systems.
• Leadership & Communication: Proven ability to lead diverse teams and strong stakeholder management and documentation skills.

Additional Technical Skills (Good to have): SQL, ETL/mapping tools.

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.