Key duties and responsibilities
Your mission will be to:
• Design, develop, and maintain robust ETL workflows that extract, transform, and load data from various sources into our data warehouse (Snowflake) and other storage systems;
• Integrate data from multiple heterogeneous sources, ensuring data quality, consistency, and accuracy throughout the process;
• Implement data transformation processes that convert raw data into structured and usable formats for analysis and reporting;
• Optimize ETL processes for performance, scalability, and reliability, ensuring minimal downtime and maximum efficiency;
• Develop and implement data quality checks and validation processes to ensure the integrity and accuracy of data;
• Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and ensure seamless data integration and accessibility;
• Create and maintain comprehensive documentation of ETL processes, data mappings, and workflows;
• Monitor ETL processes and resolve any issues or errors promptly to ensure smooth data operations.
Required experience & competencies
• Around 5 years of experience in a data engineering role, with a focus on ETL process development and management;
• Experience with Snowflake or another modern cloud data warehouse, and with at least one cloud platform (AWS, Azure or GCP);
• Proficiency in ETL tools and technologies (e.g., Apache NiFi, Talend, Informatica, AWS Glue);
• Strong SQL skills and experience with relational databases (e.g., MySQL, PostgreSQL, SQL Server);
• Knowledge of programming languages (e.g., Python, Java) for data processing and automation;
• Experience with data warehousing concepts and technologies, data modelling and schema design;
• Knowledge of data governance and security practices;
• Familiarity with Agile development methodologies;
• Familiarity with big data technologies (e.g., Hadoop, Spark, Kafka) and workflow orchestration tools (e.g., Airflow) is a plus;
• Excellent problem-solving skills and attention to detail;
• Strong communication and collaboration skills; ability to work independently and manage multiple tasks effectively;
• Strong command of English, both written and verbal (mandatory). French speaking skills are highly appreciated.
Required Education
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.