Required skills
- Data Engineering
- Data Integration
- Data Modeling
- Data Warehousing
- Snowflake
- ETL
- ELT
- SQL
- Python
- Pandas
- PySpark
- Airflow
- DBT
Languages: French
Job description
A large international group is looking for an autonomous Data Analytics Engineer for a mission focused on integrating, modeling, and reporting strategic Sustainability data. The goal is to provide a consolidated and actionable view of key indicators from various external sources.
Project overview
Context
As part of optimizing and unifying its cross-functional analytical capabilities, a large international group is seeking an autonomous Data Analytics Engineer consultant for a mission to integrate, model, and report 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.
Missions
Technical Environment
Working Conditions
- 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.
- Start Date: ASAP
- Mission Duration: 2 months, renewable
- Remote Work: 2 days / week
- Languages: English / French
Project details
- Start: flexible
- Remote: onsite
- Location: Paris, France, FR
- Languages: French
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on collective.work