À propos de Guillaume
Data Project Manager with 13 years of experience, I support companies in implementing data solutions and optimizing the use of their data. Specializing in modern technologies such as Snowflake, DBT, Tableau, and Looker, I have led numerous complex projects aimed at transforming raw data into actionable strategic insights, while improving data quality and delivering decision-making dashboards.
My expertise enables me to manage teams and oversee the entire lifecycle of data projects, from requirements gathering to the delivery of concrete solutions, with a constant focus on performance and business impact. I am particularly attentive to the quality of results and ensuring that projects are aligned with the strategic goals of the business. Moreover, my ability to facilitate effective communication between developers and business stakeholders enhances my capacity to drive impactful outcomes for your company.
In my spare time, I developed a fully automated cryptocurrency trading bot, based on a VPS, a personal database, and various APIs. This project reflects my interest in innovation and my ability to handle large volumes of data to extract valuable insights. If you are looking for an expert to lead your data projects or optimize your analytical processes, I would be happy to discuss your needs and help you achieve your goals.
Let's connect!
Français
Bilingue ou natif
Anglais
Capacité professionnelle complète
Accepte de travailler sur site
Paris (jusqu’à 50 km)
Expériences
- SorareSenior Analytics EngineerDIVERTISSEMENTS & LOISIRSnovembre 2022 - Aujourd'hui (3 ans et 7 mois)Paris, FranceAnalytics & Reporting
- Defined and created key metrics to monitor business health.
- Main contributor and developer in Looker, creating the architecture and dashboards.
- Created scorecards for leadership, highlighting key metrics and areas for improvement.
Data Infrastructure- Developed the company's data stack using Snowflake, DBT, and Looker.
- Implemented data jobs for core concepts and main fact and dimension tables.
- Investigated technical issues with developers to improve data quality.
CRM, Marketing and SEO- Integrated AppsFlyer's data to map user acquisition and installation.
- Defined acquisition channels and user attribution systems to monitor CPA & LTV.
- Created monitoring systems for SEO engagement and brand awareness using Google Search Console.
- Partnered with the CRM manager to deliver retargeting plans and personalized emails via Braze.
- Integrated external data sources with data engineers to enhance marketing intelligence.
Technical EnvironmentSnowflake (+++), DBT (+++), Looker (+++), SQL (+++), Braze (++), Python (+) - RetailMeNot, FranceBusiness Analytics ManagerE-COMMERCEseptembre 2019 - novembre 2022 (3 ans et 2 mois)Paris Metropolitan Area, FranceIn addition to my experience as a Senior Data Analyst, I have successfully managed a team of three, including Data Engineers and Data Analysts. Our collaborative efforts have driven key projects forward, balancing business unit demands and personal development.Team Management
- Managed a team of 3 Data Engineers and Data Analysts.
- Defined objectives and OKRs, ensuring alignment with company goals.
- Conducted regular follow-ups and provided career guidance.
- Developed roadmaps based on company objectives and team input.
- Facilitated weekly discussions and prioritized tasks using JIRA/Linear.
Objectives and Career Plans- Set clear career development goals for team members.
- Provided mentorship and support for achieving career milestones.
- Encouraged continuous learning and skill enhancement.
- Fostered a culture of innovation and personal growth within the team.
- RetailMeNot, FranceSenior Data AnalystE-COMMERCEfévrier 2018 - septembre 2019 (1 an et 7 mois)Paris Metropolitan Area, FranceData Infrastructure
- Migrated the full database from Vertica to Snowflake (2nd French Customer for Snowflake)
- Developed the company's data infrastructure using Microsoft SSIS, Snowflake and Tableau.
- Technically merged our business into coupon & cashback verticals.
- Worked with engineering team to ensure data quality overtime.
Financials- Developed our yearly plans and predictions on traffic and revenues.
- Designed LTV metrics and analyzed cohorts for value, retention, and performances.
- Designed the tool and reporting monitor key metrics for the strategic committee.
CRM & Marketing- Segmented customer base for targeted CRM communication.
- Conducted ad-hoc analyses on marketing campaigns.
- Created an advanced user Engagement Scoring system.
Additional Collaboration- Created scripts to anonymize database systems based on user activity for GDPR purpose.
- Developed monthly customized reports for merchants using sales team inputs.
- Monitored AB test roadmap and results.
- Provided reporting tools for various business units.
Technical EnvironmentSnowflake (+++), Microsoft SSIS (+++), Excel (+++), Vertica (++), Tableau (++), Google Analytics (+), Python (+)
Recommandations
Soyez le premier à recommander Guillaume
Contribuez à la réussite de ce freelance en partageant votre expérience de collaboration avec lui.
Ces profils de freelance correspondent également à vos critères
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
Formations
- Engineer's degree, Computer/Information Technology Administration and ManagementEISTI2012Engineer's degree, Computer/Information Technology Administration and Management