About 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!
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- SorareSenior Analytics EngineerENTERTAINMENT AND LEISURENovember 2022 - Today (3 years and 7 months)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-COMMERCESeptember 2019 - November 2022 (3 years and 2 months)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-COMMERCEFebruary 2018 - September 2019 (1 year and 7 months)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 (+)
Recommendations
Be the first to recommend Guillaume
Help this freelancer shine by sharing your experience working together.
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
- Engineer's degree, Computer/Information Technology Administration and ManagementEISTI2012Engineer's degree, Computer/Information Technology Administration and Management