ETL Data Analyst (French Speaker) | BPCE-SI

Natixis in Portugal; Lisboa; Híbrido; EUR 48 000 - 70 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid work policy

Green Transportation Budget

Wellbeing program

Prayer room

Lactation room

ESG & DEI initiatives

Resumo da oferta

Natixis in Portugal is seeking a versatile Data Analyst / Data Engineer to bridge business needs and data engineering. You will understand data structures, write technical specifications for data engineers, design reporting solutions in Power BI, and help develop ETL flows.

The role combines analytics with data pipeline work, requiring strong SQL, data modeling, and familiarity with ETL tools. Fluency in French and English is essential.

Qualificações

• Bachelor’s or Master’s degree in a related field (CS, Data Science, Statistics, Finance).
• 3+ years in a similar role with focus on analysis and ETL development.
• Advanced SQL skills for complex queries, joins and optimization.
• Strong data warehouse concepts (Kimball) and data governance.
• Direct experience with Stambia is a major asset; willingness to adapt to Stambia.

Responsabilidades

• Collaborate with business stakeholders to understand needs and translate them into data models and technical specs for the Data Engineering team.
• Design, structure, and maintain robust data models (star/snowflake) optimized for analysis and reporting.
• Ensure data quality, consistency, and documentation of data definitions (lineage and data dictionary).
• Design, build, test, and optimize ETL/ELT pipelines to load data into the data warehouse.
• Develop ETL processes using Stambia and other market-standard tools as applicable.
• Build and maintain Power BI dashboards and reports with DAX and Power Query/M.

Conhecimentos

Advanced SQL

Power BI

ETL development

Data modeling

Stambia

French & English fluency

Cloud platforms

Formação académica

Bachelor’s or Master’s degree in Computer Science, Data Science, Statistics, Finance, or related field

Ferramentas

Talend

Informatica

SSIS

Azure Data Factory

dbt

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.

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 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.

Qualifications

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.

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 commited to being inclusive, caring, and fair, ensuring every voice is heard and valued.