Senior Data Business Analyst (French Speaker) | BPCE-SI

Natixis in Portugal; Porto; Híbrido; EUR 45 000 - 65 000; Tempo integral

Resumo da oferta

Natixis in Portugal is seeking a Senior Data Business Analyst (French Speaker) to join the BPCE-SI team in Porto. The role is hybrid, bridging business requirements with the Data Engineers, BI, and Analytics teams, and involves analyzing Oracle database tables using SQL.

You will translate functional rules into technical requirements, draft source-to-target mappings, and assist stakeholders by providing a realistic view of data availability. Close collaboration with Data teams is essential.

Qualificações

• Proficiency in SQL with complex queries (JOINs, subqueries, analytics) required.
• 5+ years as a business analyst.
• Experience with Oracle databases and tools.
• French C1 level required; good English.

Responsabilidades

• Write SQL queries to query and analyze database tables.
• Explore and profile raw data to understand structure and rules.
• Translate business rules into technical requirements with Data teams.
• Draft source-to-target data mappings and specs.
• Assist stakeholders by providing a realistic view of data availability in Oracle systems.
• Design and execute functional and technical data reconciliation test plans.

Conhecimentos

SQL proficiency

Business analysis

Oracle databases

Data analysis

Data modeling

French (C1)

English communication

Ferramentas

PL/SQL Developer

TOAD

DBeaver

SQL Developer

Descrição da oferta de emprego

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.

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.