ETL Data Analyst (French Speaker) | BPCE-SI

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.

Natixis is looking for a versatile professional who is comfortable both "talking to the business" and "getting their hands dirty in the data pipeline." You will be responsible for understanding business data structures, writing clear technical specifications for Data Engineers, designing reporting solutions in Power BI, and actively participating in the development of our ETL flows.

As a Data Analyst / Data Engineer in our team, you will bridge the gap between business needs, data analysis, and technical data engineering. If you have a strong analytical mindset, a love for data modeling, and hands-on experience with ETL tools, this role is for you.

Key Responsibilities

• Business Requirements & Specifications: Collaborate with business stakeholders to understand their needs and translate them into clear data models and technical specifications for the Data Engineering team.
• Data Modeling & Architecture: Design, structure, and maintain robust data models (star schemas, snowflake schemas) optimized for analysis and reporting.
• Data Governance : Ensure data quality, consistency, and clear documentation of data definitions (data lineage and data dictionary).
• ETL Development: Design, build, test, and optimize ETL/ELT pipelines to extract, transform, and load data from various sources into our data warehouse.
• Tooling (Stambia + Others): Develop ETL processes primarily using Stambia (training/adaptation can be provided if you have strong experience in other market-standard ETL tools like Talend, Informatica, SSIS, dbt, etc.).
• Data Quality Automation: Implement automated checks to ensure the reliability and integrity of the loaded data.

Hard Skills:

• Bachelor’s or Master’s degree in Computer Science, Data Science, Statistics, Finance, or a related field.
• 3+ years of experience in a similar role (Data Analyst, Analytics Engineer) with a strong dual focus on analysis and ETL development.
• Advanced SQL skills are mandatory (complex queries, joins, optimizations, stored procedures).
• Strong understanding of relational databases and data warehouse concepts (Kimball methodology).
• Direct experience with Stambia is a major asset. Otherwise, solid experience with other ETL tools (Talend, Informatica, SSIS, Data Factory, dbt) and a strong willingness to adapt to Stambia.
• Prior experience working in the banking, finance, or insurance sector (understanding of financial instruments, regulatory compliance, risk management, or retail banking data) is highly appreciated.
• Design, develop, and maintain high-performing, user-friendly Power BI dashboards and reports (including DAX formulas and Power Query/M).
• Experience with Azure, AWS, or GCP.
• Knowledge of Python or Unix/Linux scripting.
• Fluency in French and English is essential.

Soft Skills

• Excellent communication skills to bridge the gap between business users (non-technical) and pure developers (highly technical).
• Strong analytical and troubleshooting mindset.
• Ability to take ownership of projects from requirements gathering to final delivery.

We will only consider CVs in 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 commited to being inclusive, caring, and fair, ensuring every voice is heard and valued.