Consultant, Hedge Fund Acctng

ntrs; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Northern Trust in Bengaluru seeks a Client Implementation professional to onboard Hedge Fund Services clients, coordinating with investment managers and IT partners during the onboarding process.

You will design VBA scripts, develop Python data workflows, and build Xceptor reports, while managing multiple projects and ensuring timely system setups. Strong English communication and mentoring are essential for success in this role.

Qualifications

• Excellent prioritization skills.
• Advanced Excel skills.
• VBA programming for macros and automation.
• Strong Python programming (Pandas, NumPy, OpenPyXL).
• Mentor through confidence and approachability.
• Good analytical, numerical and reasoning skills.
• Time management and delegation skills.
• Proactive and able to handle multiple tasks.

Responsibilities

• Design/write complex VBA scripts as per the business requirement.
• Troubleshoot issues related to VBA coding and provide timely solutions.
• Design/write complex Python programming using OOP concepts, data structure and algorithms.
• Debug and optimize the code.
• Main point of contact with external investment managers and in-house technology partners during onboarding.
• Analyze and create Xceptor reports for reconciliation.
• Coordinate and perform system set-up and testing; lead weekly client meetings.
• Manage multiple projects simultaneously from beginning to end.
• Interface with internal and external IT to ensure timely setup.
• Maintain client tracking documents and communicate to management.

Skills

Advanced Excel

VBA Macros

Python Pandas

Analytical skills

Time management

Mentoring

Communication

Tools

Xceptor

Job description

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world's most successful individuals, families, corporations and institutions.

Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide.

With more than 135 years of financial experience and over 24,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.

OMNIUM services- Consultant, FUND admin, HFS

Founded in Chicago in 1889, Northern Trust is one of the world's leading financial institutions. We specialize in providing asset servicing solutions and asset management to both institutional and personal clients. The delivery of products and services to this client base is supported through a network of offices around the globe.

Role

Employee would be responsible for working with investment managers and in-house technology partners, operational areas, management and product development during the implementation process of onboarding a new Hedge Fund Services client. The Client Implementation function is responsible for onboarding third party clients onto the HFS platform and converting data sets from existing fund administrators or clients.

Major Duties

• Design/Write complex VBA scripts as per the business requirement.
• Troubleshoot issues related to VBA coding and provide timely solutions to the business.
• Design/write complex python programming using OOP concepts, data structure and algorithms
• Should be able to debug and optimize the code
• main point of contact with external investment managers and in-house technology partners, operational areas, management and product development during the implementation process.
• Able to analyze and create Xceptor reports for reconciliation
• Understand the output requirement and build Xceptor report accordingly. Also, able to build complex Xceptor reports with appropriate data analysis
• Troubleshoot and fix the Xceptor reports within the given timelines.
• Manage multiple projects simultaneously from beginning to end.
• Facilitate and ensure structure for weekly client meetings including producing agendas and document and distribute takeaways.
• Coordinate and perform system set-up and testing: complete personal setup responsibilities and confirm all groups have completed their setup responsibilities.
• Interface with internal and external IT to ensure external IT setup is completed timely and within the constraints of the internal control framework.
• Identify and communicate bespoke client requests (for reporting and other IT builds) according to established guidelines.
• Ensure all necessary implementation tracking documents are initiated and maintained (client matrix, subway map, etc.).
• Follow-up with Shared Services to update the tracking documents. This includes ensuring that the subway map is properly updated/maintained by applicable members of the Virtual Team and all escalations are identified and communicated to management.
• Carries out complex activities with significant financial, client, and/or internal business impact.
• Able to serve as a key subject matter expert and mentor to other more junior level employees.
• Drives the engagement of other partners as appropriate to solve inquiries/issues of different stake holders
• Ability to handle several tasks and prioritize work based on deadlines
• Results oriented self-starter who can lead efforts with little or high-level direction

Accountabilities

• Employees are required to comply with the regulatory regime in which Northern Trust operates as appropriate to the above role
• Employees are expected to exercise due care and diligence, ensuring the areas the incumbent is responsible for are organised and controlled
• Employees are required to observe proper standards of market, business and personal conduct, demonstrating integrity in the execution of duties
• Generating efficiencies within the team and effective utilization of resources
• Demonstrate high ethical standards.
• Strong operations knowledge including secondary review & controls, risks & mitigation

Skills

• Excellent prioritization skills
• Advanced excel skills
• VBA Programming(Macros and Automation
• Strong Python Programming (Pandas, NumPy, OpenPyXL)
• Be able to mentor through confidence and approachability
• Good analytical, numerical and reasoning skills
• Time management and delegation skills
• Approachable and able to promote teamwork through creative solutions
• Self-starter with the ability to function independently in a fast-paced, dynamic and demanding environment.
• Excellent spoken and written English and the ability to write business correspondence.
• Proactive and capable to handle multip