Business Analyst w/SQL (French Speaker) | BPCE-SI

Company Description

Natixis in Portugal is a Centre of Expertise whose mission is to transform traditional banking by developing innovative solutions for the business, operations and work culture of Groupe BPCE worldwide.

As part of Groupe BPCE's international division, Natixis in Portugal designs and delivers solutions for its two core areas - Corporate & Investment Banking and Asset & Wealth Management - as well as transversal services that support all entities across the Group.
With more than 3,000 employees representing 46 nationalities, the teams work across Information Technology, Banking Support Activities, and Compliance, in an integrated, inclusive, and cross-functional way, supporting all business lines and platforms of the Group.

A disruptive mindset and a culture of proximity and agility identify Natixis in Portugal Team and reflect the company's mission to transform traditional banking at a global scale: a perfect match in the Portuguese dynamics and entrepreneurial ecosystem.

Job Description

Natixis in Portugal is currently seeking a Senior Data Business Analyst (French Speaker) / BPCE-SI to join its BPCE SI (BPCE Solutions Informatiques) team, within the IT (Information Technologies) department, to work in a hybrid work model in the Porto office, to join a data team.

In this role, you will bridge the gap between business requirements and our Data teams (Data Engineers, Data Analysts). To succeed in this mission, you will not just gather requirements: you will actively dive into the data by writing queries and analyzing our Oracle database tables to understand their structure, quality, and underlying logic.

Key Responsibilities

• Write SQL queries to directly query and analyze tables within our database.
• Explore and profile raw data to understand its structure, underlying business rules, and to identify potential anomalies.

• Work closely with Data teams (Data Engineers, BI, and Analytics) to translate functional business rules into technical requirements.
• Draft clear functional and technical specifications (source-to-target data mapping).
• Assist business stakeholders in defining their requirements by providing a realistic view of the data actually available in the Oracle systems.

• Design and execute test plans (both functional and technical data reconciliation).

Qualifications

• Proficiency in SQL (Essential): Strong ability to write complex queries (JOINs, subqueries, analytical functions, etc.) to query databases.
• 5+ years of solid experience as business analyst.
• Oracle Environment: Proven experience working with Oracle databases (using tools such as PL/SQL Developer, TOAD, DBeaver, or SQL Developer).
• Data Analysis: Ability to analyze data models (tables, views, primary/foreign keys).
• Data Modeling: Basic understanding of data architecture concepts (Data Warehouse, Data Marts).
• French: Minimum C1 level (fluent/advanced) is required, as you will interact closely with French-speaking business stakeholders and write functional specifications in French. A good level of English is also required.

We will only consider CVs in English.

Additional Information

Our workplace reflects the vibrant spirit of our locations, with initiatives such as a Green Transportation Budget, electric bikes and a flexible Hybrid Work Policy. We promote wellbeing through the Honolulu Wellness Club, a Prayer Room, a Lactation Room, and themed Villages that inspire creativity and collaboration. Through our ESG and DEI strategies, we are committed to being inclusive, caring, and fair, ensuring every voice is heard and valued.