BPCE SI Finance & Risque Senior Data Engineer DH037162

Lisbon, Portugal; Porto, Portugal

Specialist (5+ Years)

Hybrid

English Required

Key Responsibilities:

Design, develop, and implement complex ETL/ELT solutions to extract, transform, and load data from various sources into our data warehouses and data lakes.
Develop and optimize advanced SQL queries for data analysis, manipulation, and validation.
Utilize and master major ETL tools such as Informatica PowerCenter, ODI (Oracle Data Integrator), Talend, Stambia to build and maintain data flows.
Ensure the quality, reliability, and performance of data flows, implementing quality controls and error detection mechanisms.
Collaborate closely with Data Analysts, Business Analysts, and other technical teams to understand business requirements and translate them into technical data solutions.
Participate in data modeling and database schema design.
Automate data loading and processing processes.
Document data architectures, ETL flows, and technical specifications.
Ensure data security and compliance.
Stay up-to-date with emerging technologies and best practices in Data Engineering.
What We're Looking For:

Minimum of 5 years of professional experience as a Data Engineer or in a similar role, with a strong track record in designing and developing ETL solutions.
In-depth mastery of SQL for querying, manipulating, and optimizing relational databases.
Significant experience with at least one of the following ETL tools: Informatica PowerCenter, ODI, Talend, Stambia.
Solid knowledge of relational databases (Oracle, SQL Server, PostgreSQL, etc.) and/or NoSQL databases.
Understanding of data modeling principles (star schema, snowflake schema, etc.).
Ability to work independently and collaboratively within a team, with excellent problem-solving skills.
Good communication skills and the ability to explain technical concepts clearly.

We connect IT professionals with projects that match their skills, professional experience, and goals, then we offer a career progression program, delivered by in-house specialists - our People Experience Partners - to guide them through our journey with us.

What we offer:

A project that matches your skills and ambitions, as well as your preferences for working policies and culture.
A competitive salary with awesome benefits and opportunities to leverage your knowledge and network to earn additional income.
An empowering and respectful work culture enriched with social and learning events.
A People Experience Partner specially assigned to you - your go-to career guide, responsible for supporting your growth, facilitating training, and ensuring your work-life balance at KWAN.

At KWAN, they make sure that I feel comfortable with the client I’m working for and that what I’m doing aligns with my career aspirations.

Luis Caldeira, DevOps @ KWAN

At KWAN, I’m given the space to be myself and do what I love. I have control over the projects I work on, as well as the direction of my career.

Pedro Fonseca, Front End Developer @ KWAN

I see my People Experience Partner as someone who is always available to provide me with motivation and constant feedback, which helps me be sure that I am in the right place.

Josimar dos Reis, Software Developer @ KWAN

I know that I’ve contributed to the growth of a company that truly values a “people first culture”, because my ideas, experiences, and individuality were always appreciated.

João Nascimento, Software Developer (KWAN Alumni)

My two years at KWAN were an incredible experience! From the start, I was welcomed into a warm and collaborative environment where I felt truly supported.

Laís Ortiz, Software Developer @ (KWAN Alumni)

Grab this opportunity, apply now!