About the role
Job Description
Natixis in Portugal is currently seeking a Data Engineer (French Speaker) to join its BPCE-SI (BPCE Solutions Informatiques) team, within the IT (Information Technologies) department, to work in a hybrid model in the Porto office.
The mission, as a Data Engineer, consists in having a key role in designing, developing, implementing, and maintaining our data warehouse. A technical expertise, particularly with ETL tools like PowerCenter, combined with your proficiency in PL/SQL, will be essential in ensuring the quality, reliability, and performance of our data. Familiarity with Power BI will be considered a significant asset.
Responsibilities:
* Design, develop, test, and deploy robust and high-performing data integration solutions using PowerCenter or similar ETL tools such as Talend, ODI, Semarchy/Stambia, Oracle Exadata Database.
* Develop and optimize complex PL/SQL stored procedures, functions, and queries to support business data needs.
* Participate in the modeling and evolution of our datawarehouse, ensuring data consistency and integrity.
* Collaborate with business teams and other technical teams to understand data requirements and translate these into effective technical solutions.
* Ensure the maintenance, support, and optimization of existing data pipelines.
* Diagnose and resolve data-related and ETL pipeline issues.
* Implement and follow best practices in data quality, governance, and security.
* Participate in the design and development of dashboards and reports in Power BI, ensuring access to relevant data (PBI is a plus).
* Share your technical expertise and potentially mentor junior team members.
Qualifications
Hard skills:
* Higher education degree in Computer Science, Engineering, Applied Mathematics, or a related field.
* Significant experience (minimum 5 years) as a Data Engineer, ETL Developer, or in a similar role.
* In-depth mastery of a major ETL tool, with PowerCenter being a strong asset. Experience with other ETL tools will be a plus.
* Excellent proficiency in PL/SQL for developing and optimizing queries and scripts (Oracle is strongly recommended).
* Solid knowledge of data modeling (relational, dimensional) and data warehouse design.
* Familiarity with database management systems (e.g., Oracle).
* Experience with Power BI for creating reports and dashboards (optional).
* Fluent French, both written and spoken. B2 level in English.
Soft skills:
* Autonomy, rigor, organizational skills, and problem-solving abilities.
* Ability to work in a team and communicate effectively.
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.