Technical Business Analyst – Regulatory Reporting

QUANTEAM - North America (RAINBOW PARTNERS Group); New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Quanteam in New York is seeking a Technical Business Analyst to join a Regulatory Reporting IT team in a financial services setting. You will combine Oracle PL/SQL development with regulatory expertise, driving requirements analysis through testing and data validation.

Required are 10+ years in the role within banking/finance, strong SQL/PLSQL, and experience with FR 2052A. You will liaise across business, regulatory, and IT teams to implement compliant solutions.

Qualifications

• 10+ years as Technical Business Analyst/Developer in a financial institution.
• Hands-on regulatory reporting experience with FR 2052A.
• Strong Oracle PL/SQL and data validation skills.

Responsibilities

• Gather, analyze, and synthesize business requirements related to regulatory reporting.
• Design and implement functional and technical solutions aligned with regulatory requirements.
• Develop and maintain Oracle PL/SQL code (packages, procedures, functions).
• Perform data analysis, reconciliation, and validation of regulatory reports.
• Lead functional testing and support regulatory submissions.
• Act as a liaison between business users, regulatory teams, and IT.
• Support production issues and contribute to continuous improvements.

Skills

Oracle PL/SQL

SQL

Regulatory reporting

Requirements analysis

Data validation

Tools

Oracle Data Warehouse

DataMart

Axiom

Job description

As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specialized in Banking, Finance, and Financial Services. Through our core human values – proximity, teamwork, diversity, excellence – our 1000 expert consultants, hailing from 35 different nationalities, collaborate across 13 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Luxembourg, Geneva, Lisbon, Porto, Casablanca, Madrid and Singapore.

Role Overview

We are looking for a Technical Business Analyst to join a Regulatory Reporting IT team within a financial services environment. The role requires a strong combination of technical development skills (Oracle PL/SQL) and functional expertise in U.S. regulatory reporting, with hands-on involvement from requirements analysis through development, testing, and data validation.

Key Responsibilities

• Gather, analyze, and synthesize business requirements related to regulatory reporting.
• Design and implement functional and technical solutions aligned with regulatory requirements.
• Develop and maintain Oracle PL/SQL code (packages, procedures, functions).
• Perform data analysis, reconciliation, and validation of regulatory reports.
• Lead functional testing and support regulatory submissions.
• Act as a liaison between business users, regulatory teams, and IT.
• Support production issues and contribute to continuous improvements.

Experience & Profile

• 10+ years of experience as a Technical Business Analyst / Developer in a financial institution.
• Hands-on experience within the regulatory reporting domain.
• Experience working closely with both business and technical teams.
• Experience with Axiom is a strong plus.
• Autonomous, proactive, with strong analytical and communication skills.
• Strong experience in Regulatory Reporting IT.
• Mandatory experience implementing FR 2052A.
• Knowledge of other regulatory reports (e.g. FR Y-15) is a plus.
• Proven experience in data validation and regulatory reconciliation.
• Ability to translate regulatory requirements into implementable solutions.
• Strong expertise in Oracle PL/SQL.
• Experience with Oracle Data Warehouse / DataMart environments.
• Solid understanding of SDLC processes.
• Ability to analyze and troubleshoot complex SQL and PL/SQL code