Middle Office Tech Analyst

theapexgroup; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Apex Group Ltd is seeking aMiddle Office – Analyst – Business Systems in Pune to support Solvas-driven ETL processes and end-user inquiries. The role bridges technical ETL operations with business users and requires hands-on ETL tooling, SQL, VBA, and Excel expertise.

The associate-level position emphasizes data integration, user guidance, and collaboration with analysts to document requirements and ensure smooth data loads across the Conversant system.

Qualifications

• 3+ years of related experience in support/technical in loan operation systems (Solvas/Geneva).
• Experience acting as front-line liaison for end-users on Solvas applications.
• Ability to diagnose ETL issues and provide clear user guidance.

Responsibilities

• Serve as the primary point of contact for end‑users seeking technical assistance related to Solvas applications.
• Address ETL process queries, data transformations, and data loads for end users.
• Integrate client trade files into the Conversant system; design, develop, test, and implement solutions.
• Monitor ETL jobs to ensure performance and resolve issues in a timely manner.
• Develop user documentation and guides for self-service issue resolution.
• Collaborate with business analysts to document ETL requirements and improvements.
• Assist in system upgrades, migrations, and integrations.

Skills

SQL

VBA

Advanced Excel

ETL tools

Solvas

Bloomberg

Refinitiv

Tools

ETL tools

Solvas

Bloomberg

Refinitiv

Job description

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