Assistant Manager - Data Analyst (Data Quality) - Capital Markets / Corporate Banking - ISPL Data Office

About BNP Paribas India Solutions

Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.

About BNP Paribas Group

BNP Paribas is the European Union’s leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group’s commercial & personal banking and several specialised businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability

Commitment to Diversity and Inclusion

At BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, colour, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.

About Business Line/Function

The Intermediate Holding Company (“IHC”) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platform’s operating model due to the drastic changes introduced by the Enhanced Prudential Standards (“EPS”) for Foreign Banking Organizations (“FBOs”) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S Dodd-Frank Act.

The IT Transversal Team is part of the Information Technology Group which works simultaneously on a wide range of projects arising from business, strategic initiatives, regulatory changes and reengineering of existing applications to improve functionality and efficiency.

Job Title

Data Analyst

Date

11/04/2025

Department

IHC

Location:

Mumbai

Business Line / Function

CIB IT Transversal

Reports To

(Direct)

Manager

Grade

(if applicable)

NA

(Functional)

Number Of Direct Reports

NA

Directorship / Registration

NA

Position Purpose

The purpose of this position is to conduct data risk assessment, find issues in the data used for US Federal Reserve regulatory reporting, set up detective rules to catch hold of exceptions. set up controls in close coordination with business stakeholders. The person joining will assist business and regulatory reporting teams to raise issues that affects them, conduct root cause analysis and take them to effective resolution owners to get them closed.

The position also helps in identifying areas of continuous improvement and improve them thus achieving higher efficiency. Support audit queries from time to time from audit teams.

Responsibilities

Direct Responsibilities;

Data Risk Assessment – Conduct data risk assessment on data that is used, linked and moves across hobs and the risks faced.

Data Analysis – Analyze large volumes of data related to investment banking domains i.e. capital markets, corporate banking, liquidity, credit risk, market risk, client referential and securities referential and identify issues in them via data quality checks, conduct quality checks on a periodical basis as required and present results to stakeholder for corrective action and take them to closure. Prepare functional reports and assist in automating the process using tools as required. Undertake deep dive of issues affecting the business and come up with the remediation actions.

Understand how the data moves across the bank and set up data control checks based on risks. Assess the exceptions generated and share the same with Data Stewards. Understand either of the US FED reports FFIEC002, FRY-15. FFIEC-009 and understand how they are filed from an accounting basis.

Understand the gaps in coverage and check for setting up of control checks. Write medium to complex SQL queries to extract data from database for data analysis. Be able to connect the dots. Explain the functional gaps to techno functional team so that they can incorporate those checks in their systems.

Develop test cases aimed at validating development for a given functional requirement and record them in the official test management platform. Have a continuous improvement mindset.

Data Controls – Maintain an overview and inventory of controls. Conduct a review of the controls in a periodic manner with Data Stewards and business, APS and IT stakeholders. Conduct a certification assessment of the controls on a quarterly cycle.

Prefiling Analysis – Conduct a prefiling analysis to understand whether the transactions are clubbed properly and reported in the correct MDRM in specific Fed reports.

Issue Management and Remediation – Keep a list of the issues, help conduct root cause analysis. Conduct root cause analysis on the issues identified and communicated in close collaboration with data stakeholders.

Project Work – Work on creating requirements for automating processes. Test the solution as per requirement.

Audit Support – Help support audit requirements and responses under stringent timelines.

Contributing Responsibilities;

• Partner with data domain owners to develop new functional logics in existing SQL queries; which will enhance and support the goal of quality data being used for reporting purposes.
• Produce and distribute daily/weekly team Status reports and contribute to project status reporting depending on the undertaking at hand
• Understand the competitive landscape and adopt technology based solutions to drive efficiency
• Create SOP’s, perform knowledge transfer and cross training for proper backup in team
  
  

Technical & Behavioral Competencies

Able to write moderate level SQL queries in Oracle without any assistance.

• Understanding of various data model’s for extraction of required data sets to be consumed for Root cause analysis.
• Experience in one or many of these data quality tools and reporting tools/applications; Power BI, Collibra
• Proficient in MS Office applications; MS Excel, MS Word, MS Powerpoint.
  
  

Specific Qualifications (if Required)

M.Com/CA/ CFA along with 7 years of experience with all shown below:-

• Data quality area
• Data Controls & attestation expertise
• Should have supported US FED reports
• Ability to perform root cause analysis
• Business Analyst working in a financial institution and has completed multiple SDLC lifecycle.
  
  

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Attention to detail / rigor

Ability to deliver / Results driven

Active listening

Transversal Skills: (Please select up to 5 skills)

Ability to develop and adapt a process

Ability to understand, explain and support change

Analytical Ability

Ability to set up relevant performance indicators

Ability to develop and leverage networks

Education Level

Master Degree or equivalent

Experience Level

At least 5 years

Other/Specific Qualifications (if Required)

A self-starter who can take the process a level ahead and have the ability to think out of the box, suggest changes

and challenge status quo.

Ask questions and understand the larger picture for the tasks assigned.

Display a sense of curiosity, enthusiasm and eagerness to understand business constraints, environment and impact on regulation for the financial industry.

Excellent communication skills (both verbal and written)

Excellent organization, analytical and time management skills.

Ability to work under pressure and flexible to work extended hours.

Ability to work independently and become an effective team member.