LOG IN
SIGN UP
Canary Wharfian - Online Investment Banking & Finance Community.
Sign In
or continue with e-mail and password
Forgot password?
Don't have an account?
Create an account
or continue with e-mail and password
By signing up, you agree to our Terms & Conditions and Privacy Policy.

Data Analyst – US Regulatory Reporting - Assistant Vice President

ExperiencedNo visa sponsorship
Citi logo

at Citi

Bulge Bracket Investment Banks

Posted 13 days ago

No clicks

**Data Analyst – US Regulatory Reporting - Assistant Vice President** Analyze and protect regulatory data in this crucial role. Monitor upstream system changes for potential impact on reporting (Proactive Impact Analysis). Investigate data anomalies and root causes (Reactive Root Cause Analysis). Essential skills include advanced SQL, financial products knowledge, and JIRA experience. 6-8 years of experience needed.

Compensation
Not specified

Currency: Not specified

City
Mumbai
Country
India

Full Job Description

Data Analyst US Regulatory Reporting - Assistant Vice President

Apply (opens in new window)
Save

Job Req Id:

26939372

Location(s):

Mumbai, Maharashtra, India

Job Type:

On-Site/Resident

Posted:

Feb. 18, 2026

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, youll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

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
1. 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.
2. 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.
3. Testing Strategy & Requirements Management
    Translate findings into actionable JIRA tickets. Clearly define:
o    The Change: What is changing upstream?
o    The Impact: Which report cells are affected?
o    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.
4. 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")
1. 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.
2. 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).
3. Process & Tools
    Experience with JIRA for defect tracking and requirements management.
    Ability to read and interpret Data Mapping Documents (Source-to-Target mappings).


4. Education
    Bachelors 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 6 - 8 years

------------------------------------------------------

Job Family Group:

Finance

------------------------------------------------------

Job Family:

Regulatory Reporting

------------------------------------------------------

Time Type:

------------------------------------------------------

Most Relevant Skills

Business Acumen, Change Management, Constructive Debate, Data Analysis, Financial Acumen, Internal Controls, Issue Management, Process Execution, Regulatory Management, Regulatory Reporting.

------------------------------------------------------

Other Relevant Skills

Communication, Problem Solving.

------------------------------------------------------

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 (opens in new window).

View Citis EEO Policy Statement (opens in new window) and the Know Your Rights (opens in new window) poster.

Apply (opens in new window)
Save

Data Analyst – US Regulatory Reporting - Assistant Vice President

Compensation

Not specified

City: Mumbai

Country: India

Citi logo
Bulge Bracket Investment Banks

13 days ago

No clicks

at Citi

ExperiencedNo visa sponsorship

**Data Analyst – US Regulatory Reporting - Assistant Vice President** Analyze and protect regulatory data in this crucial role. Monitor upstream system changes for potential impact on reporting (Proactive Impact Analysis). Investigate data anomalies and root causes (Reactive Root Cause Analysis). Essential skills include advanced SQL, financial products knowledge, and JIRA experience. 6-8 years of experience needed.

Full Job Description

Data Analyst US Regulatory Reporting - Assistant Vice President

Apply (opens in new window)
Save

Job Req Id:

26939372

Location(s):

Mumbai, Maharashtra, India

Job Type:

On-Site/Resident

Posted:

Feb. 18, 2026

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, youll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

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
1. 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.
2. 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.
3. Testing Strategy & Requirements Management
    Translate findings into actionable JIRA tickets. Clearly define:
o    The Change: What is changing upstream?
o    The Impact: Which report cells are affected?
o    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.
4. 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")
1. 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.
2. 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).
3. Process & Tools
    Experience with JIRA for defect tracking and requirements management.
    Ability to read and interpret Data Mapping Documents (Source-to-Target mappings).


4. Education
    Bachelors 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 6 - 8 years

------------------------------------------------------

Job Family Group:

Finance

------------------------------------------------------

Job Family:

Regulatory Reporting

------------------------------------------------------

Time Type:

------------------------------------------------------

Most Relevant Skills

Business Acumen, Change Management, Constructive Debate, Data Analysis, Financial Acumen, Internal Controls, Issue Management, Process Execution, Regulatory Management, Regulatory Reporting.

------------------------------------------------------

Other Relevant Skills

Communication, Problem Solving.

------------------------------------------------------

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 (opens in new window).

View Citis EEO Policy Statement (opens in new window) and the Know Your Rights (opens in new window) poster.

Apply (opens in new window)
Save