Description

You will design, build, and maintain data pipelines to support analytical needs.

This role is on-site.

Responsibilities

• Design, build, and maintain ELT/ETL pipelines on AWS (Redshift, RDS, S3) using dbt and Informatica.
• Write advanced SQL (CTEs, window functions, complex joins) for transformations, data quality checks, and performance tuning across Redshift, RDS, Oracle, and PostgreSQL.
• Translate business and analytics team requirements into scalable data products, providing documentation via dbt Docs.
• Manage and maintain data infrastructure using version control systems like GitHub or GitLab.

Required Skills

• 5+ years of professional experience in data engineering.
• Expert proficiency in advanced SQL, including CTEs and window functions.
• Hands-on experience with AWS services: Redshift, RDS, and S3.
• Proficiency with dbt (Core and Cloud, including dbt Docs).
• Strong experience with version control (GitHub/GitLab).
• Experience with databases, including Oracle BD and PostgreSQL.
• Familiarity with Python.
• Knowledge of data modelling concepts (Data Vault, Star/Snowflake, 3NF, data mesh).

Preferred Skills

• Fluency in French and English for requirement translation.

Key Skills

Education

Any Gradute