DWH developer

Classification : Internal
Job Title: DWH Analyst/Developer
Department: RETO SSC Data
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 Data Office 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 role will report to the Data Lead and will be primarily responsible for implementation and ongoing governance of an enterprise Business Glossary as a definitive dictionary of business terms and relationships used across the enterprise. The definitions must be designed to engender a common understanding of the term for all stakeholders involved in data governance and Regulatory reporting teams.
The position requires working in a virtual team and international environment and is multidisciplinary in nature. It involves coordination with other locations and divisions of BNP Paribas as necessary. It is important that the candidate should have strong financial products knowledge along with high analytical skills, technical expertise and attention to details.
Responsibilities
Direct Responsibilities
Perform initial of business requirements
Adopt knowledge of existing technological stack and business solutions
Develop mostly independently in SQL or Python
Manage orchestration tools such as Airflow
Execute testing of developed solutions
Support delivery in all phases of development lifecycle
Contributing Responsibilities
Verify BRD
Be familiar with design documents
Document existing and newly developed solutions
Perform Root cause analysis and other diagnostic documentation
Have a good understanding of the data flows and understand its lifecycle of source to destination
Identify risk in process and propose / implement controls Technical & Behavioral Competencies
Classification : Internal
Data Warehouse Development and Maintenance: Design, develop, and maintain scalable and efficient data warehouse solutions, ensuring high performance and reliability.
Business Intelligence (BI) Development: Collaborate with stakeholders to understand business requirements, transforming them into effective BI solutions for actionable insights.
Data Modeling and Analysis: Develop and maintain conceptual, logical, and physical data models. Perform data analysis to identify trends, patterns, and opportunities for improvement.
Enterprise Architecture Integration: Contribute to the alignment of data warehouse solutions with the enterprise architecture, ensuring compliance with standards and best practices.
Database Management: Knowledge of databases (MS SQL Server, Oracle and PostGre) and optimizing performance and ensuring data integrity and security.
ETL Processes and Automation: Design, develop, and optimize ETL processes to extract, transform, and load data efficiently into the data warehouse.
Documentation and Reporting: Create comprehensive documentation and reports to support data warehouse processes, ensuring transparency and knowledge sharing.
Specific Qualifications
Bachelor’s degree in Computer Science, Information Systems, or related field.
Proven experience 5 years in Data Warehouse development and Business Intelligence.
Knowledge of databases (MS SQL Server, Oracle and PostGre), including database design, query optimization, and performance tuning.
Expertise in Python development
Understanding of Enterprise Architecture principles and their application to data solutions.
Knowledge of an orchestration tool such as AirFlow
Experience with Cloud services and cloud operations
Strong analytical and problem-solving skills.
Excellent communication and collaboration abilities.Skills Referential (Required knowledge, skills and abilities)
Technical Skills
MS SQL, Oracle, PostGre
Python
Airflow
Cloud (good to have)
Behavioral Skills
Communication
Analytical Ability
Team Player
Education Level: Bachelor Degree or equivalent
Location: Chennai, India
Classification : Internal
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 specialized 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.
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.
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. 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.

Work arrangement
Yes