Data Quality Measurement - Sr. Business Analyst
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.
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.
SR Business Analyst
Business Line / Function:
CIB IT Transversal
Number of Direct Reports:
Directorship / Registration:
Requirement gathering – Work with requirement providers and onsite team based in Montreal to gather and analyze requirements, conduct and participate in meetings / workshops to understand requirements.
Able to analyze huge data and identify any functional gaps (based on data quality exceptions generated through
Informatica Data quality tool) relating to Banking domains i.e. Capital Markets, Corporate Banking, Finance, Risk, Retail Banking etc.
Perform root cause analysis on these functional gaps, conduct / organize sessions with SME’s to discuss / brainstorm these gaps and present these functional gaps in a summarized manner to Domain SME’s
Work extensively with the Issue Management & Remediation team on identified data quality and reconciliation issues.
Coordinate with techno functional team in explaining them the logic based on which the data for specific domain needs to be extracted from Oracle.
Explain the functional gaps to techno functional team so that they can incorporate those checks in their SQL queries.
Perform reconciliation on month end data Vs tactical adjustments and generate variance analysis.
Develop test cases aimed at validating development for a given functional requirement and record them in the official test management platform.
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
- 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; Informatica, HP QC/ALM, Collibra, OBIEE, Tableau, OFSAA, Intellimatch etc.
- Proficient in MS Office applications; MS Project, MS Visio, MS Access.
- Experience in Alteryx, PowerBI will be a plus.
Specific Qualifications (if required)
Bachelor’s Degree, CA, MBA Finance or US / India CFA, or BE, along with 5 + years of experience in any of the
- Data management area related to Referential data, corporate banking or capital markets or both.
Behavioural Skills: (Please select up to 4 skills)
Communication skills - oral & written
Creativity & Innovation / Problem solving
Personal Impact / Ability to influence
Transversal Skills: (Please select up to 5 skills)
Ability to understand, explain and support change
Ability to develop and adapt a process
Ability to anticipate business / strategic evolution
Ability to set up relevant performance indicators
Bachelor Degree or equivalent
At least 3 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 or weekend working.
- Ability to work independently and become an effective team member.