Data Engineer / Snowflake / Airflow / DBT / Tableau

Project overview

As part of optimizing and unifying its cross-functional analytical capabilities, our client is looking for an autonomous Data Analytics Engineer consultant for a mission of integration, modeling, and reporting of the group's strategic Sustainability data. This initiative aims to provide a consolidated and actionable view of key indicators from various external sources, essential for strategic and operational decision-making.

Mission Objectives

Technical Environment

Profile Sought

Important Bonuses:

• Establish and secure robust and scalable technical connections with identified source systems (Resource Advisor, Internal repositories).
• Extract and load data from key Corporate functional domains: finance, human resources, repositories, purchasing, etc.
• Design and implement reliable and efficient automated ingestion pipelines, ensuring data integrity and freshness.
• Structure and model data in a Data Warehouse (Snowflake Data Warehouse) in a logical, modular, reusable, and optimized manner for analysis and reporting.
• Implement data governance mechanisms: metadata management, refresh logic, data quality monitoring, and error management.
• Develop data views and aggregates specific to the reporting and analysis needs for the Sustainability department and its regional collaborators.
• Comprehensively document ingestion pipelines, data models (logical and physical), transformation rules, and recovery points to ensure maintainability and transferability.
• Sources: Multiple systems (Resource advisor, Internal repositories
• via APIs, exports, or native connectors).
• Destination: Snowflake (Cloud Data Warehouse).
• Orchestration: Airflow.
• Transformation: DBT Core / SQL, Python (Pandas/PySpark) or equivalent.
• Modeling: DrawIO, Lucidchart, or other free tool support.
• Visualization / Reporting: Tableau.
• CI/CD / Versioning: GitLab, GitHub.
• Documentation: Confluence, Jira, SharePoint.
• Mastery of data ingestion and transformation techniques in a cloud environment (Snowflake).
• Solid skills in analytical data modeling (dimensional models, Data Vault, medallion, or other data warehouse architectures).
• Excellent practices in data pipeline orchestration, code versioning, technical and functional documentation.
• Ability to work effectively within an Agile team, following the Scrum methodology.
• Strong ability to work autonomously, take initiative, and interact effectively with technical teams and business stakeholders.
• Ability to understand and translate complex business needs into technical data solutions.
• Knowledge of data structures and typical business processes of a large international group in hospitality or a similar sector.
• Experience in using AI, LLM Agents, in delivery whether for design, documentation, code, or tests.

Project details

• Start Date: ASAP
• Mission Duration: 2 months renewable
• Location: Issy-les-Moulineaux
• Remote Work: 2 days / week
• Start: flexible
• Duration: 1-3 months
• Remote: hybrid
• Location: Issy-les-Moulineaux, France, FR
• Languages: English, French