HamburgerMenu
hirist

Business Analyst - SQL

Quess
3 - 6 Years
Multiple Locations

Posted on: 12/10/2026

Job Description

Role : Business Analyst - E-Fund Orders

Job Description :


We are looking for an experienced Business Analyst (3 - 6 years) with strong knowledge of the end-to-end fund lifecycle and hands-on experience in business analysis, functional testing, production support, and stakeholder management. The candidate should have a solid understanding of investment fund order processes, related upstream and downstream systems, and strong SQL skills for data analysis, troubleshooting, and investigation.

Key Responsibilities :

- Gather, understand, and document business requirements from Product Owners and key stakeholders.

- Analyze fund order processes, including order creation, validation, processing, execution, settlement, and downstream distribution.

- Understand the upstream and downstream dependencies of the fund order lifecycle and assess the impact of functional changes.

- Analyze business requirements and translate them into clear user stories, acceptance criteria, functional specifications, and test scenarios.

- Work closely with developers and technical teams to explain business requirements, functional flows, and expected outcomes.

- Perform functional analysis and impact assessment for new requirements and change requests.

- Prepare detailed test scenarios and test cases covering positive, negative, boundary, and end-to-end business flows.

- Perform UAT and functional testing following application deployments.

- Conduct end-to-end connected testing with upstream and downstream systems to validate fund order processing.

- Analyze production issues, incidents, service requests, and problem tickets and perform first-level investigation.

- Work with development and support teams to identify root causes and provide functional guidance for issue resolution.

- Perform data analysis and reconciliation using SQL queries to validate transactions, identify discrepancies, and investigate production issues.

- Participate in Agile ceremonies including backlog refinement, sprint planning, sprint reviews, retrospectives, and daily scrum.

- Support prioritization and estimation of requirements in collaboration with Product Owners and Dev teams.

- Write SQL queries to retrieve and analyze business data; hands on experience with REST APIs.

Experience :

- Preferred : 3 - 6 years of experience as a Business Analyst in financial services / investment banking, with relevant experience in fund order management, investment funds, securities, or financial transaction processing.

- Strong knowledge of the Fund Lifecycle is mandatory for this role.

info-icon

Did you find something suspicious?

Similar jobs that you might be interested in

Loading chat...