Description

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

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 (in French/English) 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).

Key Skills

Education

Any Gradute