BNP Paribas is a leading European bank with an international reach. It has a presence in 72 countries, with more than 202,000 Employees – including more than 154,000 in Europe and over 5,000 in Portugal alone.
BNP Paribas is present in Portugal since 1985, having been one of the first foreign banks to operate in the country. Today, BNP Paribas has several entities operating directly in this territory, offering a wide range of integrated financial solutions to support its clients and their businesses.
Worldwide, the Group 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. The Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporate and institutional clients) to realise their projects through solutions spanning financing, investment, savings and protection insurance.
Analytics Consulting (AC), a team within BNP Paribas to provide Business Intelligence and Artificial intelligence solutions, is looking for a Data Architect to collaborate with the team members and guide the technology solutions, ensuring that the solution design adheres to the team’s architecture.
The AC team is constituted by four communities: Data and Analytics – structured data and consulting projects; Data Platform – data services available to everyone; Application Delivery – scalable and reliable applications; and Artificial Intelligence – unstructured data projects.
A typical AC project has three phases. The team starts by taking in large data sources, typically unstructured, sometimes internal and sometimes from the Internet, and processes them using ETL techniques. Then, it extracts actionable information (predictions, recommendations, etc.) from the cleaned up data with ML and statistical tools. Finally, the team presents the information and resulting insights to the final clients using interactive dashboards or applications.
If you want to work in a challenging data engineering environment with a transversal team, supporting analytically oriented tasks, data integration or dashboarding, please apply. ROLE AND RESPONSIBILITIES
The Data Architect role is responsible for supporting the Data Scientists, Data Analysts, Data Visualization Developers and Full-Stack Developers in conceptualising data schemas. Also in managing releases and making migrations happen seamlessly, by working as a gate keeper for production like environments. Moreover, monitoring data-bases’ performance and trouble-shooting will be part of the Data Architect’s responsibilities.
Release management and coordinate with the team and with IT throughout the release cycle;
Automation of the end to end release. Using CI/CD or one click deployment to deploy different types of artefacts to different environments;
Non production environments server management;
Coordinate with IT for any non-prod server related issues or upgrades. Coordinate with different stakeholders on any issues to get it resolved;
Windows server side performance monitoring;
Give support to other team members in optimizing and publishing their dashboards, workflows and code on a stable environment;
Provide suggestions to improve the current process when needed;
Accommodate internal development procedures and handle the most common process requests;
Partner with ETL developers and other technical data warehouse team members to design high performing ETL workflows and maintain consistent development functions.
Bachelor or Master Degree with a technical major, such as engineering, computer science or related fields.
- Data architecture, modelling;
- Data warehousing design, Star Schema and Snowflakes Schema methodologies;
Knowledge on Kimball, Inmon methodologies (top-down / bottom-up approaches in Database design);
Excellent on the SQL server performance tuning aspects Database design principles;
Experience in Extract, Transformation and Load (ETL) processes and its run time efficiency;
Familiarity with data-intensive applications: distributed computing experience using tools such as Hadoop;
Comfort working with numbers: rigour, analytical mind-set, ability to interpret numbers and synthesize;
Ability to communicate complex logical constructs in simple and intuitive ways;
Strong understanding and hands on of Alteryx, tableau performance aspects;
In depth knowledge on Alteryx designer, server, gallery. Additional knowledge on any ETL, reporting tools is a bonus;
Knowledge of programming languages is a plus.
Excellent communication and interpersonal skills
Ability to work in a changing environment / Adaptability
French and Portuguese are a plus
BNP Paribas is an equal opportunity employer and proud to provide equal employment opportunity to all job seekers. We are actively committed to ensuring that no individual is discriminated against on the grounds of age, disability, gender reassignment, marriage or civil partnership status, pregnancy and maternity, race, religion or belief, sex or sexual orientation. Equity and diversity are at the core of our recruitment policy because we believe that they foster creativity and efficiency, which in turn increase performance and productivity. We strive to reflect the society we live in, while keeping with the image of our clients.
Please note that only applications submitted in English will be considered.
In case you are selected for this role, further documentation will be requested to support your hiring process.