Regulatory Data Impact Analyst: Mumbai
Citi · Mumbai, Maharashtra, India
- On site
- Full-time
- $95,000 / year
- Mumbai, Maharashtra, India
Job highlights
- Analyze upstream system changes impacting regulatory reports.
- Investigate and resolve data anomalies for reporting teams.
- Translate business and technical requirements effectively.
- Requires advanced SQL and financial product knowledge.
- Collaborate between reporting and technology departments.
About the role
Role Summary
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.
Key Responsibilities
Upstream Change Impact Analysis (The "Shield")
- Monitor and review upcoming changes in upstream source systems (e.g., changes to General Ledger, Data Warehouse, Product Processors, or Reference Data).
- Analyze the "Blast Radius" of these changes: Use data mapping files and SQL to determine if an upstream attribute change (addition/removal/logic change) impacts specific regulatory report lines.
- Conduct "content analysis" to verify if the nature of the data is changing, even if the schema remains the same.
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 by filtering out non-issues.
Testing Strategy & Requirements Management
- Translate findings into actionable JIRA tickets.
- Clearly define: The Change: What is changing upstream? The Impact: Which report cells are affected? The Test Plan: How exactly should this be validated?
- Define test cases for User Acceptance Testing (UAT) to ensure upstream changes do not cause regression in reporting.
Communication & Stakeholder Management
- Act as the translator between the Reporting Team (who speak in "Reg Rules") and the Technology Team (who speak in "Code/Schema").
- Present impact assessments to stakeholders to get sign-off on upcoming changes.
Qualifications (The "Must-Haves")
Technical Skills
- Advanced SQL: Must be comfortable writing complex queries from scratch (Joins, Window Functions, Case Logic) to profile data and validate hypotheses. Should be able to write own script to find answers
- Data Analysis: Ability to compare large datasets (Source vs. Target) to identify variances.
Domain Knowledge (Banking or Trading)
- Banking Book: Familiarity with Lending products (Mortgages, Revolving Credit, Term Loans), Deposits, and General Ledger concepts.
- Trading Book: Familiarity with Capital Markets products (Derivatives, Securities, Repos) and trade lifecycles.
- Understanding of how product data translates to financial reporting (e.g., specific attributes like Maturity Date, Interest Rate, Counterparty Type).
Process & Tools
- Experience with JIRA for defect tracking and requirements management.
- Ability to read and interpret Data Mapping Documents (Source-to-Target mappings).
Education
- Bachelor’s degree (or higher) required
- Preferred Major in Data Analytics/Data Science, Computer Science, Quantitative Finance/Economics, Statistics/Mathematics
Preferred Qualifications
- 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.
Experience: Looking for candidates with experience 1 - 6 years
Job Family Group:
Finance
Job Family:
Regulatory Reporting
Time Type:
Full time
Most Relevant Skills
Business Acumen, Change Management, Communication, Data Analysis, Financial Acumen, Internal Controls, Issue Management, Problem Solving, Regulatory Reporting.
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.
Key skills/competency
- Regulatory Data Impact Analyst
- SQL
- Data Analysis
- Financial Products
- Regulatory Reporting
- Root Cause Analysis
- JIRA
- Change Management
- Data Quality
- Banking or Trading Domain Knowledge
Skills & topics
- Regulatory Data Impact Analyst
- SQL
- Data Analysis
- Financial Reporting
- Banking
- Trading
- Regulatory Reporting
- Root Cause Analysis
- Change Management
- JIRA
- Finance
- Data Quality
- Data Governance
- System Integration
- Mumbai
How to get hired
- Tailor your resume: Highlight advanced SQL skills, data analysis experience, and financial product knowledge relevant to regulatory reporting.
- Showcase impact: Quantify achievements in previous roles, especially in data quality, root cause analysis, or change impact assessments.
- Prepare for technical questions: Be ready to discuss complex SQL queries, data lineage tracing, and JIRA ticket creation.
- Demonstrate domain expertise: Clearly articulate your understanding of banking or trading products and their financial reporting implications.
- Emphasize communication: Highlight your ability to bridge the gap between technical and business teams.
Technical preparation
Master advanced SQL: Joins, Window Functions, Case Logic.,Practice data profiling and large dataset comparison.,Familiarize with JIRA for ticket management.,Understand data lineage and source-to-target mapping.
Behavioral questions
Describe a complex data issue you resolved.,How do you analyze upstream system change impacts?,How do you communicate technical findings to non-technical teams?,How do you prioritize tasks when handling multiple issues?
Frequently asked questions
- What are the key technical skills required for the Regulatory Data Impact Analyst role at Citi Mumbai?
- The Regulatory Data Impact Analyst role at Citi Mumbai requires advanced SQL skills for complex querying and data profiling, along with strong data analysis capabilities to compare large datasets and identify variances. Familiarity with JIRA for defect tracking and requirements management is also essential.
- What kind of financial domain knowledge is expected for this role?
- For the Regulatory Data Impact Analyst position at Citi Mumbai, a strong understanding of either Banking Book products (Lending products, Deposits, General Ledger) or Trading Book products (Capital Markets products, trade lifecycles) is expected. You should understand how product data translates to financial reporting.
- How important is experience with specific financial regulations for this Regulatory Data Impact Analyst job?
- While not strictly required, experience with specific regulations like FR Y9C, FFIEC 031, CCAR, or LCR is highly preferred for the Regulatory Data Impact Analyst role at Citi Mumbai. This knowledge demonstrates a deeper understanding of the regulatory reporting landscape.
- What is the typical experience level sought for the Regulatory Data Impact Analyst at Citi?
- Citi is looking for candidates with 1 to 6 years of experience for the Regulatory Data Impact Analyst role in Mumbai. This range allows for both early-career professionals and those with a few years of relevant experience.
- Does Citi Mumbai offer opportunities for growth in data analytics or regulatory reporting?
- Yes, the Regulatory Data Impact Analyst role at Citi provides a unique opportunity to work at the intersection of Technology and Finance. This position can lead to career growth in specialized areas of data analytics, data governance, and regulatory reporting within Citi.
- What are the primary responsibilities of a Regulatory Data Impact Analyst at Citi?
- The primary responsibilities include proactive impact analysis of upstream system changes on regulatory reports and reactive root cause analysis of data anomalies. You will also be involved in translating findings into JIRA tickets and managing stakeholder communication.
- Is Python scripting a requirement for the Regulatory Data Impact Analyst role?
- Python scripting skills are considered a preferred qualification for the Regulatory Data Impact Analyst role at Citi Mumbai. While not a mandatory requirement, it can be beneficial for automating data comparison tasks.
- What does Citi look for in a candidate for the Regulatory Data Impact Analyst position?
- Citi looks for technical problem-solvers who are fluent in SQL and have a solid understanding of financial products. Key attributes include strong analytical skills, attention to detail, good communication, and the ability to manage JIRA tickets and stakeholder expectations.