About the position
Natixis in Portugal is seeking a Data Engineer (French Speaker) to join its BPCE-SI team within the IT department. This role operates under a hybrid model in the Porto office. The primary mission is to play a key role in designing, developing, implementing, and maintaining the data warehouse. Technical expertise in ETL tools like PowerCenter, combined with proficiency in PL/SQL, is essential for ensuring data quality, reliability, and performance. Familiarity with Power BI is 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 technical expertise and potentially mentor junior team members.
Requirements
• 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).
• Fluent French, both written and spoken.
• B2 level in English.
• Autonomy, rigor, organizational skills, and problem-solving abilities.
• Ability to work in a team and communicate effectively.
Nice-to-haves
• Experience with other ETL tools will be a plus.
• Experience with Power BI for creating reports and dashboards (optional).
Benefits
• Green Transportation Budget
• electric bikes
• flexible Hybrid Work Policy
• Honolulu Wellness Club
• Prayer Room
• Lactation Room
• themed Villages that inspire creativity and collaboration.
• ESG and DEI strategies