Sr Data Modeler

August 21, 2024

Sr Data Modeler

ReferenceBNP025016

  • Permanent
  • IN-Maharashtra-Mumbai
  • INFORMATION TECHNOLOGY
Apply for this job

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 24×7 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 Businessline/Function :

CIB Client Engagement and Protection IT having focus on applications servicing Client Lifecycle management, Due Diligence /KYC , Customer Relation Management,  Service Request Management, Referential and Data Quality, PreTrade Transaction Screening, Data and Document platforms and Anti-Money Laundering.  Technologies being used include Java, .NET, Angular, Informatica, sharepoint, Python, Scala, Spark, PowerBI, Fenergo, Siebel, Actimize, Camunda, Drools on private cloud infrastructure. Agile and DevSecOps practices are widely used. Landscape includes projects that are a mix of established and some under transition to new platforms.

Job Title:

Senior Technical Lead / Technical Specialist

Date:

23-May-24

Department:

CEP IT

Location:

Mumbai

Business Line / Function:

Data & Document platform

Reports to:

(Direct)

Grade:

(if applicable)

Sr Tech Lead

(Functional)

Number of Direct Reports:

N/A

Directorship / Registration:

NA

Position Purpose

Overall 10+ years of experience, adept in software engineering and data analysis. Skilled in Python, SQL, and data visualization, have a passion for aligning data insights with strategic goals. Committed to continual learning and delivering high-quality results. Implement data strategies, build data flows, and develop conceptual/logical/physical data models. To be able to provide CIB’s business line with IT services enabling them by industrializing the processes for Enterprise Content Management

..

The Data Modeler should have key skills as mentioned below:

1- Strong experience to manage the end to end cycle, knowledge on Financial Market is an advantage

2 Good experience in the areas of Python, SQL server, Oracle, ETL, BI, Statistical Analysis, Data Warehousing.

3- Sound knowledge of Agile (Scrum/Kanban)

Responsibilities

Direct Responsibilities

  • Represent CEP IT at local and global CIB Forums on Data Design/Modelling subjects.
  • Propose / Review/ Challenge Application/database Architecture and Design.
  • Guide/Review Technology Obsolescence Management plan for CEP teams.
  • Lead automation and guide teams to align with shift left and shift right strategy by encouraging a mindset for automation first and reduce recursive manual efforts
  • Goto person to find solutions to any technical challenges in the domain.
  • Hands on and lead by example.
  • Review Performance test reports and propose preventive measures to be undertaken.
  • Take ownership of POCs and technical feasibility studies.
  • Keep up-to-date with latest technologies, trends and provide inputs, expertise and recommendations.
  • Owner for few technical improvement projects including planning, tracking and implementation.

Contributing Responsibilities

  • Contribute towards innovation (e.g. AI/ML); suggest new technical practices for efficiency improvement.
  • Contribute towards recruitment.
  • Level-up of members in the vertical.

Technical & Behavioral Competencies

  • Provide technical Leadership. Ability to communicate his/her ideas to the team and management. Inspire commitment of team members to deliver.
  • Resourceful to quickly understand complexities involved and provide the way forward.
  • Understanding Application’s Dataflow Architecture, Entity Relationship (ER), Cardinality and Technique for Normalizing Database.
  • Experience in Requirement Gathering to implementation of Effective Data Model, Designing Conceptual, Logical and Physical Data models using Modeling Tools [Erwin] and Database Normalization.
  • Working knowledge of Collaborative Design tools and Real-time collaboration, Forward and Reverse engineering in Data Modelling and Schema synchronization.
  • Strong knowledge about design patterns and development principles.
  • Strong Hands-on experience in SQL, RDBMS(PL/SQL,Data Architecture, stored procedures) , Data modelling tools, Data warehouse, ETL, Data visualization.
  • Good Knowledge and experience on projects related to Data Modelling, System/Data analysis, design and development for both OLTP and OLAP environments.
  • Experience in Security topics such as IDP, SSO, IAM and related technologies.
  • Good knowledge on Linux/Unix environment (basic commands, shell scripting, etc.), testing phases, documentation, production support and new framework.
  • Good experience of working with Data Modelling tools like Erwin, ETL tools, Database tools.
  • Knowledge of Agile, Scrum, DevOps.
  • Development experience in Data Engineering team.
  • Ability & willingness to learn & work on diverse technologies (languages, frameworks, and tools).
  • Self-motivated, good interpersonal skills and inclination to constantly upgrade on new technologies and frameworks.
  • Good communication and co-ordination skills.

Nice to have Skills:

  • Experience in Cloud Architectures.
  • Knowledge/experience on Dynatrace, Splunk, Python, Spark and Pyspark.

·       Knowledge/experience on No SQL databases (MongoDB, Cassandra), Kafka.

  • Some exposure to Caching technologies like Redis or Apache Ignite.

·       Experience in Agile – SCRUM and DevSecOps

·       Exposure to Client Management or financial domain.

·       Data Modelling certification.

Specific Qualifications (if required)

                                                     

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Ability to synthetize / simplify

Personal Impact / Ability to influence

Attention to detail / rigor

Ability to deliver / Results driven

Transversal Skills: (Please select up to 5 skills)

Analytical Ability

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

Ability to inspire others & generate people’s commitment

Ability to develop and leverage networks

Ability to anticipate business / strategic evolution

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 10 years

Other/Specific Qualifications (if required)

Offers you may be interested in