Middle Office Tech Analyst

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.

Middle Office - Analyst - Business Systems - Permanent

Location: Pune Experience: 3 - 6 years Designation: Associate Industry/Domain: ETL/Mapping Tool, VBA, SQL, Capital Market knowledge, Bank Debts, Solvas

Apex Group Ltd has an immediate requirement for Middle Office Tech Specialist. As an ETL Techno-Functional Support Specialist at Solvas, you will be the bridge between technical ETL processes and end-users, ensuring the effective functioning and support of data integration solutions. Your role involves addressing user queries, providing technical support for ETL-related issues, and collaborating with both technical and non-technical teams to ensure a seamless data integration environment. You will contribute to the development, maintenance, and enhancement of ETL processes for solvas application, ensuring they align with business requirements.

Work Environment:

• Highly motivated, collaborative, and results driven.
• Growing business within a dynamic and evolving industry.
• Entrepreneurial approach to everything we do.
• Continual focus on process improvement and automation.

Functional/ Business Expertise Required:

• Serve as the primary point of contact for end-users seeking technical assistance related to Solvas applications.
• Serve as a point of contact for end-users, addressing queries related to ETL processes, data transformations, and data loads.
• Provide clear and concise explanations to non-technical users regarding ETL functionalities and troubleshoot issues.
• Integrate Client Trade files into the Conversant system: design, develop, implement, and test technical solutions based on client and business requirements.
• Diagnose and troubleshoot ETL-related issues reported by end-users or identified through monitoring systems.
• Work closely with business analysts and end-users to understand and document ETL requirements.
• Monitor ETL jobs and processes to ensure optimal performance and identify potential issues.
• Create user documentation and guides to facilitate self-service issue resolution.
• Hands on experience in working on any ETL tools is mandatory.
• Strong command of SQL, VBA and Advance Excel.
• Good understanding of Solvas or any other loan operation system.
• Mandatory to have good knowledge of Solvas Bank Debt working.
• Intermediate knowledge of financial instruments, both listed and unlisted or OTCs, which includes and not limited to derivatives, illiquid stocks, private equity, bank‐debts, and swaps.
• Understanding of the Loan operation industry is necessary.
• Should have knowledge of market data provider applications (Bloomberg, Refinitiv etc.).
• Proficiency in any loan operation system, preferably solvas.
• An ability to work under pressure with changing priorities.
• Strong analytical and problem-solving skills.

Experience and Knowledge:

• 3+ years of related experience in support/ technical in any loan operation system & accounting system (Solvas/ Geneva).
• Connect with operation to understand & resolve their issues.
• Experience working data vendors (Bloomberg/ Refinitiv/ Markit)
• Able to handle reporting issue/ New requirement raised by operations.
• Strong analytical, problem solving, and troubleshooting abilities.
• Strong Excel and Excel functions knowledge for business support.
• Create and maintain Business documentation, including user manuals and guides.
• Worked on system upgrade/ migration/ Integration.

Other Skills:

• Good team player, ability to work on a local, regional, and global basis.
• Good communication & management skills
• Good understanding of Financial Services/ Capital Markets/ Fund Administration

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.

About Apex Group

We are dedicated to driving positive change in financial services while fuelling the growth and ambitions of asset managers, allocators, financial institutions, and family offices. Established in Bermuda in 2003, the Group has continually disrupted the asset serving industry through our investment in innovation and talent. Today, we set the pace in asset servicing and stand out for our unique single-source solution and unified cross asset-class platform which supports the entire value chain, harnesses leading innovative technology, and benefits from cross-jurisdictional expertise delivered by a long-standing management team and over 13,000 highly integrated professionals.

We’re a people-powered business, and our people are full of ambition. Together, we’re inspired to lead the new era of data and tech enabled service. Bringing new products and services to market. Sharpening our client focus. Disrupting the market to exceed expectations. Innovating across a range of specialisms. With our focus on making a difference to our people, our planet and our society, you’ll experience more here than you would at most other companies. Prepare to accelerate.

We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

Positive change starts with you. We’re a people-powered business with a vision to inspire a new era of service-led FinTech. We’re expanding globally and offering more to our clients. This means you get more opportunities to grow with us. So prepare to accelerate. We’ll make sure the time and effort you put in takes you further, faster.

The journey is yours to own. When you stretch yourself, you grow. We want you to explore ways of working that will see you thrive as part of something bigger. We’ll help you with a solid structure, challenging projects, vibrant networks, supportive colleagues and approachable leaders. All the things you need to own your unique journey. Find out more about us