The bank for a changing world

We are looking for

EDM - Data Strategy

Apply REF: CIB004741

About BNP Paribas Group:

Worldwide, BNP Paribas has a presence in 74 countries with more than 190,000 employees. It has key positions in its three main activities: Domestic Markets and International Financial Services (whose retail-banking networks and financial services are covered by Retail Banking & Services) and Corporate & Institutional Banking, which serves two client franchises: corporate clients and institutional investors. In Asia Pacific, BNP Paribas is one of the best-positioned international financial institutions with an uninterrupted presence since 1860. Currently with over 15,000 employees* and a presence in 14 markets, it provides clients with product and service solutions tailored to their specific needs, and continues to develop its franchise in the region.

About BNP Paribas India Solutions:

Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas Group, a leading bank in Europe with an international reach. With delivery centers located in Mumbai and Chennai, we are a 24x7 global delivery center. We partner various business lines of BNP Paribas such as Corporate and Institutional Banking, Wealth Management, Retail Banking through three verticals - Information Technology, Operations and Finance Shared Services.

About Businessline/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.

Hence to meet the ever changing regulatory requirements – Data Management team have been setup. With core team based in Canada and offshore team in Mumbai; this team provides a pool of project managers and business analysts to drive change throughout the organization and across locations of BNP Paribas in the U.S for various work streams - which includes CCAR, IHC, Liquidity, Risk, Compliance, HR, FinReg, FP&A and Transversal. Offshore Team in Mumbai is looking to on-board a Business / Data Analysis role, who would be supporting  in Business Glossary project and Data Lineage, along with added responsibilities of working on several other projects of Data Management group. The goal of the business Glossary work stream is to create more formalized list of Data Elements and the definitions/terms associated with them. There is a need for a Business Glossary of more well-defined terms so there can be consistent language used both globally and between work streams that depend on KeyDataElemets. The goal of Data Lineage is to reflect lineage of fields / tables i.e. a 360 degree view on the lifecycle of data/specific field.

Job Title:

Business Analyst





CIB IT Transversal



Business Line / Function:

Enterprise Data Management

Reports to:


Thomas MATHEW (Manager)


(if applicable)


Number of Direct Reports:

Directorship / Registration:



Position Purpose

Data management is an administrative process that includes acquiring, validating, storing, protecting,

and processing required data to ensure the accessibility, reliability, and timeliness of the data for its users.

Data Strategy which is a sub team within Data Management is aligned with Enterprise Data Management.

It includes maintaining Key Metadata of Critical Data Elements in the firm's Tactical tool and ensuring it's correctness. It is also responsible for manual functional testing of the Data Lineage tool - Informatica /Ab-Initio.


Direct Responsibilities

•  Able to read and interpret BRD’s, Technical specs so as to perform functional testing of data Lineage.

•  Create test cases in HP ALM to perform functional testing of lineage created in Informatica Meta data manager (Knowledge on Ab-Inito would be added advantage).

•  Read various US regulatory reports / forms and able to summarize understanding for each line item in summary format for IT team to create lineage & glossary.

•  Challenge status quo and propose process enhancement ideas.

•  Able to review deliverables of Lineage created by IT department. Communicate changes to IT team for lineage and test the releases.

•  Able to extract required information from lots of excel files containing huge volume of data.

•  Able to summarize critical issues in commentary format along with charts, bar or pie diagrams and able to generate status report for senior and executive management group.

•  Create SOP’s, Procedure documents, perform knowledge transfer and cross training for proper backup in team.

•  Effective communication across multiple teams including development team (IT) and other stakeholders. Ability to translate business requirements and work with development teams throughout resolution, implementation and delivery.




Contributing Responsibilities

Technical & Behavioral Competencies

a)         Technical:-

•  Create BRD, functional specifications, flow charts, Root cause analysis and other diagnostic documentations.

•  Have a good understanding of the data flows and understand its lifecycle of source to destination.

•  Identify risk in process and propose / implement controls.

•  Able to work with large data in excel and suggest process enhancement ideas.

•  Knowledge of advanced formulas & pivot tables in excel is must.

•  HP ALM, test case management and its lifecycle etc.

•  SharePoint, MS Excel, MS Word, MS Visio & PowerPoint

b)         Behavioral:-

•  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 or weekend working.

•  Ability to work independently and become an effective team member.

 Good to have Skills:

a)         Functional:-

•  Able to understand Regulatory initiatives like – Basel II, Basel III, Dodd Frank and CCAR.

•  Fair understanding of IHC and regulatory report FRY9C etc.

•  Able to write independent queries in SQL so that can quickly extrapolate data from multiple sources including MDM and worksheets.

b)         Technical:-

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

•  Working exposure in Informatica Metadata Manager / Power center

•  Knowledge of Tableau, OFSAA, and MS Access would be added advantage.

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to collaborate / Teamwork

Attention to detail / rigor

Client focused

Creativity & Innovation / Problem solving

Transversal Skills: (Please select up to 5 skills)

Ability to develop and adapt a process

Ability to understand, explain and support change

Ability to develop and leverage networks

Choose an item.

Choose an item.

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 3 years

Other/Specific Qualifications (if required)

•     3-4 years of experience along with Bachelor’s Degree - in management, finance, science, economics, related field or equivalent experience.

•     Prior experience in similar domain.

Primary Location: IN-MH-MumbaiJob Type: Standard / PermanentJob: MISCELLANEOUSEducation Level: Bachelor Degree or equivalent (>= 3 years)Experience Level: At least 3 yearsSchedule: Full-time Behavioural competency: Attention to detail / rigorTransversal competency: Ability to inspire others & generate people's commitment