Experienced Data Engineer / Data Consultant – Snowflake

Project overview

Our client in the Banking and Finance sector is looking for an experienced Data Engineer / Data Consultant – Snowflake H/F

Mission Description:

Context

As part of a major IT system transformation program, the data platform is being modernized, and the decision-making target is migrating to Snowflake for the French activity. Existing operational and analytical uses must be maintained during their migration, while new data and AI projects continue to emerge.

The mission involves interactions with a project manager, IT and infrastructure teams, a service center, the Data Management Office, and business departments, particularly marketing and regulatory, spread across several sites and in an international context.

Mission

Design, develop, manage, and deliver high-value business decision-making uses, participate in the migration to Snowflake, and industrialize datamarts. The consultant also contributes to defining the migration trajectory from Talend to dbt and ensures the quality, compliance, and maintainability of solutions.

Main Responsibilities

Technical Environment

Expected Deliverables

Information regarding teleworking:

Yes — 2 days/week

Offices in Roubaix

• Understand and challenge business needs, interact with users, and formalize adapted solutions
• Design technical solutions, models, flows, and data architecture patterns; identify sources, dependencies, loads, and risks
• Feed Snowflake with raw data, build decision-making datamarts, and develop new uses
• Migrate existing Talend uses to dbt and propose solutions to support this trajectory
• Develop pipelines and uses, and supervise or monitor developments carried out by the service center
• Apply best practices for quality, performance, and security
• Perform unit, integration, and acceptance testing, contribute to production deployments, and ensure post-deployment monitoring
• Produce functional and technical specifications, architecture and design documents, operational and installation documentation, as well as versioned and validated code from integration to production
• Document uses, contribute to data governance, and optimize existing solutions
• Act as a functional and technical referent for their scope, make autonomous decisions, and present them to the technical core for validation
• Report alerts with proposed solutions and maintain a watch on data tools and Snowflake
• Data and databases: Snowflake, SQL, Talend, dbt
• Real-time and integration: Kafka, REST API
• Data and monitoring tools: Control-M, Dynatrace
• Development and integration: Git, SVN, Maven, Jenkins, Sonar, Eclipse
• Architecture and infrastructures: data architectures, public cloud, IT architectures
• Delivery methods: CAPFM (V-cycle) or agile methodology depending on the projects
• Functional and technical specifications
• Architecture and design documents
• Operational and installation documentation
• Versioned and validated source code, from integration to production
• Developed, industrialized, and documented decision-making uses and datamarts

Project details

• Start: flexible
• Remote: hybrid
• Location: 59100 Roubaix, France, FR
• Rate: 66-66 EUR/h
• Languages: French