About Ancelin
French
Native or bilingual
English
Fluent
Experience
- Credit Agricole Consumer FinanceData Engineer / Project Manager | Snowflake | Talend | Power BIBANKING AND INSURANCEJuly 2024 - Today (1 year and 11 months)Roubaix, France→ Mission Objective:Implement and industrialize reliable data pipelines for new Sofinco applications as part of a migration of **all data to Snowflake**.→ Achievements:Designed integration workflows withTalend / DBT and SQLto automate flows, improve data quality, and reduce processing times.Modeled and created data structures inSnowflaketo enhance performance, ensure scalability, and make the data architecture reliable.Coordinated and managed data projects to align stakeholders, secure deadlines, and maximize the business impact of deliverables.→ Technical Stack:Snowflake, Talend, DBT, SQL, Python
- NorautoData Engineer | Snowflake | Semarchy xDi | DBTTECHJanuary 2024 - July 2024 (6 months)Lille, France→ Mission Objective:Design and optimize reliable data pipelines to improve the quality, availability, and utilization of business data in reports on Tableau Software.→ Achievements:Deployed integration flows with Stambia and SQL to centralize data, reduce silos, and improve the speed and reliability of processing.Optimized data structures in Snowflake to increase query performance and reduce access times to strategic information.Created dynamic dashboards with Tableau Software to accelerate decision-making and provide better business visibility.Developed Python code for Snowflake procedures for certain processes where Stambia usage was not optimal.→ Technical Stack:Snowflake, Stambia, SQL, Python, Tableau Software
- CreditsafeData Engineer / Project Manager | Snowflake | Semarchy xDi | Power BIBANKING AND INSURANCEFebruary 2022 - December 2023 (1 year and 10 months)Roubaix, France→ Mission Objective:Lead data development activities, from tool standardization to team management, to build and optimize a robust and high-performing decision-making ecosystem.→ Achievements:Led the development team (2 interns): defined standards, code reviews, and project management to structure and ensure the quality of deliverables.Designed and automated complex data flows with Stambia to consolidate information from heterogeneous sources (databases, APIs, files).Managed various client extractions done via SQL / Stambia and created via a generalized template developed by myself (+400 client extractions).Modernized task scheduling and monitoring by integrating Python and Airflow into the data ecosystem.Created Power BI reports to transform raw data from the data warehouse into visual and actionable analyses for business teams.Benchmarked different databases with a view to migrating to a database better suited to various business needs (Snowflake).→ Technical Stack:Snowflake, Stambia (xDi), Power BI, Python, Airflow, Aurora MySQL, Oracle, Redshift
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Computer Science and StatisticsPolytech Lille2017Informatique et Statistiques
- Mathematics and PhysicsInstitut Emmanuel d'Alzon, Nîmes2014Mathématiques et Physique