Data Engineer Snowflake / Data Vault 2.0 M/F
Company Description
Founded in France, Talan is today an international group that accompanies its clients in their Data & IA transformation, from end to end, by combining management consulting and technological expertise.
With more than 6,000 employees on 5 continents, we accelerate our clients' transformations through long-term partnerships, creating a measurable and sustainable impact.
Our value proposition is based on a structured innovation ecosystem: 2,500 Data & IA experts, proprietary solutions built on advanced models, and an applied research, experimental development, and innovation laboratory.
We have been translating technological innovation into competitive advantage for over 20 years in strategic sectors: banking and financial services, energy, transport and mobility, luxury and retail, healthcare.
Driven by its promise of Positive Innovation, Talan establishes itself as a leading player to meet the increasing complexity of economic, technological, and regulatory environments.
And Talan Sud-Est?
Talan Sud-Est has been present in Lyon since 2007 and has approximately 350 employees distributed between Aix-Marseille and Lyon.
In full development, our teams continue to grow to support the Data & IA transformations of our large accounts and ETI clients.
Expertise, good humor, collectivity, and an entrepreneurial spirit constitute our DNA.
Job Description
Your mission
As part of the development of our Data activities, we are looking for a Data Engineer specialized in SQL, Snowflake, and Data Vault 2.0 modeling to join our teams.
You will work on modern Data Cloud environments, particularly around the design, evolution, and industrialization of enterprise Data Warehouses.
Within a team organized in Agile/Scrum mode, you will contribute to the construction of robust, scalable Data solutions adapted to business challenges.
Your main responsibilities
Data design and integration
- Analyze business needs and understand source data flows.
- Design, develop, and maintain data ingestion and transformation pipelines.
- Guarantee data quality, consistency, and traceability.
- Collaborate with business teams to translate their needs into technical solutions.
Data Warehouse / Data Vault Modeling
- Participate in the design and evolution of data models.
- Implement Data Vault 2.0 (Hubs, Links, Satellites) modeling principles.
- Contribute to the design of Data Marts and reporting layers.
- Ensure compliance with decision-making modeling best practices.
Development and industrialization
- Develop and optimize SQL processing on Snowflake.
- Design and maintain transformations with dbt.
- Implement data quality and reliability tests.
- Participate in CI/CD processes and deployment automation.
- Contribute to the continuous improvement of performance and processing.
Maintenance and continuous improvement
- Ensure the monitoring and maintenance of existing processes.
- Identify and resolve anomalies.
- Participate in pipeline monitoring.
- Maintain technical and functional documentation.
Technical environment
You will primarily work around the following technologies:
- Data Warehouse: Snowflake
- Development: advanced SQL, Python
- Transformation: dbt, AutomateDV
- Modeling: Data Vault 2.0, Kimball
- Orchestration: Apache Airflow or equivalent
- CI/CD and DevOps: Git, GitLab, Jenkins, Docker, Kubernetes
- Methodologies: Agile/Scrum, Jira, Confluence
Qualifications
Profile sought
A graduate with a Master's degree (Bac+5) in computer science, Data, or an equivalent field, you ideally have at least 3 years of experience in Data Engineering, with solid expertise in SQL development and Data Warehouse environments.
Essential skills:
- Excellent mastery of advanced SQL: CTE, analytical functions, query optimization.
- Experience with Snowflake or an equivalent Cloud Data platform (BigQuery, Redshift, Synapse).
- Good mastery of dbt for data transformation and testing.
- Skills in Python applied to Data Engineering.
- Experience in data integration and decision-making modeling.
- Good understanding of process industrialization.
Skills that will make a difference:
- Knowledge of the Data Vault 2.0 methodology.
- Experience with AutomateDV.
- Knowledge of Data Cloud architectures and DataOps practices.
- Experience with Airflow and CI/CD environments.
Beyond your technical skills
Above all, we are looking for a person who is:
- Autonomous, rigorous, and possesses a good analytical mind.
- Capable of understanding business issues and proposing adapted solutions.
- Comfortable in exchanges with technical and functional stakeholders.
- Curious, collaborative, and sensitive to data quality and governance issues.
Professional English is indispensable to operate in an international environment.
Additional Information
What Talan Aix offers you daily
- Modern premises and a collaborative work environment.
- The possibility of teleworking, with a €100 equipment allowance.
- Health insurance covered at a minimum of 80%.
- Meal vouchers.
- Referral bonuses from €500 to €4,000.
- An employee shareholding scheme.
- A complete training offer and possibilities for mobility in France and internationally.
- A mentoring program for women.
- A disability support service dedicated to employees and caregivers.
- A corporate culture recognized as a Great Place to Work for 10 years.
- A commitment to innovation, diversity, and sustainable development.
Recruitment process
Our recruitment team is committed to offering you a smooth and transparent process:
- An initial exchange with our recruitment team to understand your background and professional project.
- A technical and operational interview with a manager.
- A managerial interview with the team leader.
Talan is a responsible company, committed to diversity and equal opportunity. Workplace adjustments can be organized to accommodate people with disabilities.
Want to contribute to ambitious Data projects? Join us!
#Talan #DataEngineer #Snowflake #DataVault #dbt #SQL #Python #DataEngineering #CDI #Marseille #AixEnProvence