Middle Office Tech Analyst

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.