This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are looking for a technical problem-solver to join our Global Regulatory Reporting Analytics Team. In this role, you will act as the "Gatekeeper" of our regulatory data. You will be responsible for two critical functions: (1) Proactive Impact Analysis, where you assess how upstream system changes (product updates, migration, schema changes) will affect our regulatory reports, and (2) Reactive Root Cause Analysis, where you investigate data anomalies reported by the reporting team. You will sit at the intersection of Technology and Finance. You must be fluent in SQL to dig into the data and fluent in Financial Products to understand the business context.
Job Responsibility:
Upstream Change Impact Analysis (The "Shield"): Monitor and review upcoming changes in upstream source systems
Analyze the "Blast Radius" of these changes using data mapping files and SQL
Conduct "content analysis" to verify if the nature of the data is changing
Incident Triage & Root Cause Analysis (The "Detective"): Investigate "perceived data issues" raised by the Regulatory Reporting team
Execute complex SQL queries to trace data lineage back to the source
Determine the verdict: Is this a true upstream Data Quality (DQ) issue, a logic gap in our transformation layer, or a valid business event?
Prevent false alarms from reaching the technology development team
Define test cases for User Acceptance Testing (UAT)
Communication & Stakeholder Management: Act as the translator between the Reporting Team and the Technology Team
Present impact assessments to stakeholders to get sign-off on upcoming changes
Requirements:
Advanced SQL: comfortable writing complex queries from scratch (Joins, Window Functions, Case Logic)
Data Analysis: ability to compare large datasets (Source vs. Target) to identify variances
Domain Knowledge (Banking or Trading): Familiarity with Lending products (Mortgages, Revolving Credit, Term Loans), Deposits, and General Ledger concepts OR Familiarity with Capital Markets products (Derivatives, Securities, Repos) and trade lifecycles
Understanding of how product data translates to financial reporting
Experience with JIRA for defect tracking and requirements management
Ability to read and interpret Data Mapping Documents (Source-to-Target mappings)
8+ years experience
Should have team handling experience
Nice to have:
Experience with specific regulations (e.g., FR Y9C, FFIEC 031, FR Y-14, CCAR, FFIEC 009/009A, LCR, 2052a, or other Regulatory Reporting)
Python scripting skills for automating data comparison tasks
Previous experience in a "Data Quality," "Data Governance," or "System Integration" role