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