Business System Analyst: SQL

Iris Software; Chennai, Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Iris Software, Inc. is seeking an experienced Business Systems Analyst (BSA) with Capital Markets expertise to collaborate with business stakeholders and technology teams. The role emphasizes SQL-driven data analysis, data mapping, and validation to deliver robust business solutions.

You will gather requirements, write functional specs, and support testing and issue resolution while ensuring data integrity across systems. Strong communication and stakeholder management are essential for success.

Qualifications

• 6+ years of experience as a BSA in Capital Markets.
• Strong Capital Markets domain knowledge.
• Proficient in writing complex SQL queries for analysis.
• Experience in data analysis, mapping, and validation.
• Excellent analytical and communication skills; capable of stakeholder management.

Responsibilities

• Gather, analyze, and document business and functional requirements.
• Work with stakeholders to translate requirements into functional specs.
• Perform data analysis and validate data across systems using SQL.
• Conduct impact analysis and support testing and issue resolution.
• Prepare business requirements documents, user stories, and flows.
• Collaborate with development and testing teams to ensure alignment with requirements.
• Support data reconciliation and validation activities as needed.

Skills

Capital Markets domain

SQL

Data analysis

Data mapping

Data validation

Analytical thinking

Communication

Stakeholder management

Job description

Business Systems Analyst (BSA) Capital Markets

Job Summary

We are looking for experienced Business Systems Analysts (BSAs) with strong Capital Markets domain knowledge and expertise in SQL and data analysis. The candidate will work with business stakeholders and technology teams to understand requirements, analyze data, and support the delivery of business and technology solutions.

Key Responsibilities

• Gather, analyze, and document business and functional requirements.
• Work closely with business stakeholders and technology teams to understand business processes and translate requirements into clear functional specifications.
• Perform detailed data analysis, write complex SQL queries, and validate data across systems.
• Conduct impact analysis, support functional testing, and assist in issue resolution.
• Prepare business requirement documents, user stories, process flows, and other relevant documentation.
• Collaborate with development and testing teams to ensure solutions meet business requirements.
• Support data reconciliation and validation activities, where required.

Must-Have Skills

• 6+ years of relevant experience as a Business Systems Analyst (BSA).
• Strong experience in the Capital Markets domain.
• Strong SQL skills, including writing complex queries for data analysis and validation.
• Proven experience in data analysis, data mapping, and data validation.
• Excellent analytical, problem-solving, communication, and stakeholder management skills.

Good-to-Have Skills

• Experience in Regulatory Reporting.
• Understanding of regulatory reporting processes and associated data requirements.