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

Natixis in Portugal; Porto; Hybrid; EUR 38,000 - 52,000; Full time

Job summary

Natixis in Portugal seeks a Senior Data Business Analyst (French Speaker) to bridge business requirements and our Data teams in a hybrid Porto setting. You will write SQL queries, profile data in Oracle, and translate complex business needs into technical specs for data engineers.

You will collaborate with BI and Analytics, design test plans, and draft source-to-target mappings, while ensuring data quality and compliance with our Group BPCE standards.

Qualifications

• 5+ years of experience as a business analyst.
• Proficient in writing functional specifications in French.
• Strong SQL querying and data profiling skills.

Responsibilities

• Write SQL queries to access and analyze Oracle tables.
• Profile and explore raw data to understand structure and rules.
• Translate business requirements into technical data specifications with Data Engineers.
• Draft source-to-target data mappings and specifications.
• Assist stakeholders in defining data needs and validating results.
• Design and execute functional and data reconciliation test plans.

Skills

SQL

Data analysis

Business analysis

English proficiency

Tools

Oracle

PL/SQL Developer

TOAD

DBeaver

SQL Developer

Job description

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

• Full-time

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.

Natixisin 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 ourOracledatabase 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).
• 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.

Wewill only considerCVsin English.

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.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website’s terms and privacy policy apply