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.

Position Purpose

The purpose of this position is to conduct data quality 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 and work on issue root cause analysis. The person joining will assist business and regulatory reporting teams to help fill in the gaps , detect exceptions, 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 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 US FED regulatory reports on risk, liquidity, exposures 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.

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 Inter / CFA along with 3+ 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
Use technologies SQL, AI to augment the process
Business Analyst working in a financial institution and has completed multiple SDLC lifecycle.

Experience Level : At least 3 years

Associate - Data Quality - Capital Markets / Corporate Banking