BNP Paribas Looking for Data Analyst – Global Market Regulatory IT at Mumbai, Maharashtra Full Time

Job Description – Technical Lead – Global Markets Regulatory IT

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 24×7 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 :
Global Markets

The Global Markets business of BNP Paribas helps its corporate and institutional clients leverage capital markets across the globe for their financing, risk management and investment needs. This encompasses a wide range of financial products ranging from Foreign exchange to complex Equity Derivatives that are traded in financial markets across the globe 24/7. IT systems are integral to the business and are a key part of the value proposition to clients. These IT systems range from industry standard products for standard process automation to internally developed, often, market leading IT applications. The IT teams owning these IT systems are made up of functions that include Technical and Application production support, Business Analysis & Project Management, Development & Maintenance and Quality Control. BNP Paribas India Solutions is an equal partner in these IT functions along with colleagues in other locations including Paris, London, New York, Tokyo, Singapore & Hong Kong. This partnership ranges from sharing the IT work load, executing global strategy to owning global applications offshore. The technology and engineering landscape is wide, encompassing almost all techniques and platforms. It continues to evolve and transform with the market with the business continuing to invest in it.

Regulatory IT

Regulatory IT comprises of software systems which manage reporting to Regulators in the Americas, EMEA and APAC regions. These systems

1) Manage the generation of real time reports to Regulators

2) Control and monitor trades, positions and breaks for report accuracy

3) Make Pre trade regulatory checks and alert compliance violations.

Job Title:
Technical Lead

Date:
12 March 2019

Department:
Global Markets Regulatory IT

Location:
ISPL Mumbai

Business Line / Function:
Global Markets IT

Reports to:
(Direct)

Sandip HULMUKHE

Grade:
(if applicable)

(Functional)

Mathieu MASSON

Number of Direct Reports:
Directorship / Registration:
NA

Position Purpose

ODIN is a datawarehouse application and it is changing its overall architecture and migrating to new efficient data model, Also few of the technical upgrade are due in this year. To cope up with increase in reporting demands we need to design new analytical CUBES. It demands senior technical expertise in the team, who can take up the responsibility to do overall architectural, design decisions, and can speed up the BAU as well as contribute to build the overall skills of the team to face the new challenges.

Responsibilities

Direct Responsibilities & Contributing Responsibilities

Participate in technical planning & requirements gathering phases including design, coding, testing, troubleshooting, and documenting the application.

Interface with key stakeholders to define, analyze, and deliver requirements that reflect the needs of the business, and translate to detailed design specifications

Lead in the creation, development, implementation, configuration, maintenance, and support of data models for databases, data marts, and data warehouses

Develop methods to store, organize, and report data and incorporate development operations automation where appropriate

Identify potential design, process and/or system changes to optimize performance, and mitigate risks

Study data, identify patterns, make sense out of it and convert it to algorithms.

Designs and plans BI, and other Visualization Tools capturing and analyzing data from multiple sources to make data-driven decisions, as well as debugs, monitors, and troubleshoots solutions.

Carry out exploratory development to integrate new components into existing software.

Propose new technical solutions and best practices, discuss and present their ideas in detail to stakeholders

Prepare diagrams and exhibits to explain proposed system to managers and users in a clear format.

Identify performance bottlenecks, profile applications & tune SQL queries.

Contribute to Architecture standards and best practices.

Setup new / enhance the existing processes and create SOP.

Contribute to the Release and Sprint planning.

Technical & Behavioral Competencies

Mandatory Technical expertise required:
Oracle (+++) / T-SQL (+++) (preferably) – including optimization of stored procedures, queries

Python

Exposure to any ETL Tool (++)

Nice to have Technical skills:
MS BI 2008 R2/2012

SSIS (++)

SSRS (++) including MDX (+)

SSAS 2008 R2/2012 (+) including MDX (+) and optimization of cube process performance

Shell script (++)

Subversion (+)

Angular JS

C#.net

Behavioral Skills

Curiosity and analysis skills and willingness to learn.

Good Communication skills.

Quality-focused with a good eye for detail.

Capacity to work in a high-pressure environment.

Must be able to work closely with distributed team, users and business analysts.

Willing to share knowledge and skills with other developers within the team.

Whilst able to work independently, should be a true team player.

Creativity and Problem solving attitude.

Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Decision Making

Ability to deliver / Results driven

Critical thinking

Active listening

Transversal Skills: (Please select up to 5 skills)

Ability to develop and adapt a process

Ability to anticipate business / strategic evolution

Ability to develop others & improve their skills

Ability to set up relevant performance indicators

Ability to manage / facilitate a meeting, seminar, committee, training…

Education Level:
Bachelor Degree or equivalent

Experience Level

At least 7 years

Other/Specific Qualifications (if required)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Decision Making

Ability to deliver / Results driven

Critical thinking

Active listening

Transversal Skills: (Please select up to 5 skills)

Ability to develop and adapt a process

Ability to anticipate business / strategic evolution

Ability to develop others & improve their skills

Ability to set up relevant performance indicators

Ability to manage / facilitate a meeting, seminar, committee, training…

Education Level:
Bachelor Degree or equivalent

Experience Level

At least 7 years

Other/Specific Qualifications (if required)