Company purpose:
Our company purpose is to contribute to a responsible and sustainable economy by financing and advising clients according to the highest ethical standards.
Our employer promise is built around three pillars:
• Being a great place to work
• Committed to sustainability and having a positive impact
• Being dedicated to the development of our people
Business area
Global Markets (GM) IT Risk and P&L development consists of approximately 300 people spread between London, Paris, New York, India and Asia, developing software to support systems for Risk, P&L and Financial Resources data for Global Markets.
Risk is a compass for many aspects of the business, and we develop systems to assess and report on this, providing risk assessment tools for all trades across all asset classes traded by a full service investment bank. These overnight or real-time tools incorporate a large element of modelling and draw on the work of our quantitative research teams. To compute all the necessary indicators, they need the huge processing power of the bank’s computation farm, one of the biggest in the industry.
Our P&L systems are designed to assess how much money the bank makes or loses, and why. We support management in analysing issues such as whether our results are due to market trends or trading strategy, or whether traders are completing a few high-risk, high-margin trades or a large volume of low-risk, low-margin ones.
Within the GM IT Risk and P&L development, the Data Services team are responsible for key systems for storing, aggregating and reporting on Global Markets Risk and P&L data.
Job purpose
We are migrating a number of our analytical databases to ClickHouse and are looking for a Data Platform Engineer to help us design, optimize and maintain our new data infrastructure.
Key responsibilities
• Help various teams within BNPP setting up their ClickHouse database environments with a focus on fault tolerance, high availability, scalability and performance.
• Develop and implement a robust disaster recovery strategy to ensure data integrity and minimal downtime.
• Develop a backup strategy to ensure that data is safeguarded and that systems can be restored in the event of failure.
• Help to support the various ClickHouse databases in the production environment, ensuring quick resolution of any production problems.
• Optimize ClickHouse database performance, including query optimization and data modelling
• Ensure data security, access controls, and compliance with industry standards
• Collaborate with development teams to optimize database schema and queries for application performance.
• Help to integrate ClickHouse into teams existing DevOps pipelines using Jenkins and Ansible.
• Help in the setup of advanced monitoring solutions using open source tools such as Prometheus and Grafana.
• Develop and maintain documentation on ClickHouse database architecture, setup, and operations within the BNPP environment
• Stay up-to-date with the latest developments in ClickHouse and related technologies, and apply this knowledge to improve our setup
• Help to train the various development teams in ClickHouse.
• Ideally, you will help in the customisation of ClickHouse which will involve building and enhancing ClickHouse with C++
Requirements
Essential
• Demonstratable experience with ClickHouse in a production environment, including knowledge of query engine, data replication and production setup.
• Proficiency in designing and implementing backup and disaster recovery strategies
• Experience with database performance optimization, including query optimization and indexing.
• Experience of data modelling techniques, particularly data warehouses / star schemas.
• Knowledge of data loading / ETL techniques to maximise load throughput.
• Strong knowledge of Linux/Unix systems
• Strong understanding of data security, access controls, and compliance requirements.
• Excellent problem-solving skills, attention to detail, and analytical skills
• Strong communication and collaboration skills, with ability to work with cross-functional teams
Preferred
• Knowledge of Grafana / Prometheus for monitoring
• Knowledge of DevOps CI/CD pipelines including Jenkins and Ansible.
• Knowledge of C# / .NET Framework or Java
• Experience of working with SQL Server databases and TSQL development
Nice to have
Knowledge of C++ for ClickHouse function implementation
And of course, we expect all our colleagues to embody and practice the Group values (alignment with the Bank’s strategy, commitment, work ethic, integrity and Code of Conduct).
A bit more about why you should join us
1. We’re a great place to work
We aim for optimal work/life balance (depending on role, this includes hybrid working, flexible working and agile)
We are proud of our award-winning flexible benefits and health & wellbeing strategy. Our flexible benefits include:
• Generous holiday allowance of at least 26 days (plus bank holidays) – with option to buy and sell holidays.
• Valuable financial plans – a 12% non-contributory pension which has been moved to sustainable investments*, life assurance*, income protection and personal accident insurance.
• Extensive wellbeing and mental health offering – one of the most advanced private medical schemes in the UK, dental cover, wellbeing app, Cognitive Behavioural Therapy support, subsidised gym memberships, bespoke health assessments including genetic testing, Private GP (including digital GP services to parents of employees), Employee Assistance Programme, menopause & fertility support (we are an accredited Menopause Friendly Employer), neurodiversity assessment and support.
• Key onsite services and facilities in London – include physiotherapy, nutrition, massage therapy, physiology, mental health first aiders, seasonal flu vaccinations and free onsite fitness centre.
• Plus, emergency back-up care for dependants, green car leasing, season ticket loan, and a range of other benefits.
* Subject to relevant caps
2. As the eurozone’s largest bank, we are committed to having a positive impact in the world.
For example, we are committed to Net Zero in all of our financing and investment portfolios by 2050. By 2030, 80% of our energy production financing will be low carbon.
But impact for us means more than climate. It means empowering our people every day. Everyone gets four volunteering days each year - in 2023, we achieved over 18,000 hours of volunteering across the UK and reaching over 4,500 young people.
3. We believe in our people
We support our people to develop skills to adapt to the ever-evolving world of work and to prepare for the jobs of today and tomorrow. We do this through a comprehensive training offering, talent programmes, mentoring, career days and inhouse career tools.
We are proud of the number of our people who progress and secure new roles internally. In fact, in 2023, nearly half of our positions in UK CIB were filled internally.
Investing in our people also means we have a collaborative and inclusive culture:
• Direct feedback from our people shows that our internal culture sets us apart from our industry peers.
• Each year, nearly 30,000 employees globally are involved in professional networks that play an active role in promoting Diversity and Inclusion within the Group. These include our:
Pride Network, Ability Network (which supports disabled employees), MixCity (gender equality network), Women in Global Markets, Women in Global Banking, Women in IT, Diversity Equity & Inclusion in Technology, Early Careers Network, Multicultural Network and Parents & Carers Network.
Equal opportunities
BNP Paribas is committed to providing a work environment that fosters diversity, inclusion, and equal employment opportunity without regard to age, disability, gender reassignment, marriage or civil partnership status, pregnancy and maternity, race, religion or belief, sex or sexual orientation, or any other legally protected status.
Adjustments
We don’t want anyone to be disadvantaged in our recruitment processes, so if you have a disability or health condition which may mean that you’d benefit from some adjustments or additional support, please let us know as early in the process as possible.
#LI-Hybrid
