Freelancer profile translated to English.
Back to original languageAbout Olivier
Geomatician and geographer by initial training, I acquired about twenty years of experience (tourism and territorial marketing, urban planning, economic development, maritime economy) before developing my freelance activity in 2023.
Thanks to recognized expertise in SQL and DBA, knowledge in data engineering (acquisition, data quality, ETL and pipelines) and data science (machine learning), I can integrate into complex projects and intervene on your entire data exploitation chain.
But my favorite area is data analysis: giving meaning, contributing to strategic decisions, providing concrete solutions to teams!
My strengths:
• My technical expertise and versatility particularly suited to SMEs and mid-sized companies
• A dual Data and Geodata skill set ideal for your geomarketing approaches
• A client & solution-oriented project management approach, without unnecessary complexity: understanding your needs to offer you simple, effective solutions that are easy for your teams to adopt
• My skills as a facilitator and educator (teaching, training, coaching, and tutoring)
✨ Seize the essential challenge of your data quality by entrusting me with the acquisition, preparation, and cleaning of your data
⚙️ Optimize your database organization, automate everything possible by leveraging the full power of SQL
📊 Improve your reporting and decision support system with customized KPIs and dashboards. Publish quality dataviz, infographics, and maps
🔎 Discover what your data can teach you: market research and exploratory studies, data mining, machine learning, business insights, predictive models, GIS processing
🧑🏼🎓Develop your team's Data skills! Training, coaching, and consulting in data strategy, GDPR compliance
French
Native or bilingual
English
Fluent
Can work on-site
Quimper (up to 50km), Brest (up to 50km), Lorient (up to 50km)
Experience
- TyDataData AnalystCONSULTING AND AUDITSSeptember 2023 - Today (2 years and 9 months)Quimper, FranceData strategy, data solutions, data culture serving SMEs & mid-sized companies, local authorities, and associations
- Support for local authority Data / GIS teams in data-driven management (automations, permanent diagnostics, maintenance, asset management) of sewage networks: data engineering (PostgreSQL, DBT), machine learning (Python), business dashboards
- Marketing studies and analyses with a strong data component (NLP verbatim analysis, segmentation, etc.)
- Development and deployment of business-oriented data tools and solutions for SMEs
- Coaching and training of data teams (SQL, Python, DBT, GIS)
- Finistère 360°Data Analyst - Head of Observation, Studies, and Prospective DesignPUBLIC SECTORApril 2018 - August 2023 (5 years and 5 months)Quimper, FranceDepartmental Tourism Committee (8th largest department in France by tourist attendance) and Attractiveness Agency. Management of a team of 4 people responsible for observation (dashboards, dataviz, infographics, mapping) and consulting for professionals (tourism, nautical activities, local authorities). Management of numerous studies and projects including:
- Management of thefirst comprehensive study of brand awareness and image for a territoryin France
- A pool of 3marketing studiesconducted with Kantar, Altimax, and TMO Régions, utilizingconversion funneldata (awareness, attractiveness, intention, consumption, recommendation) with innovative methodologies (including machine learning) to provide tourism professionals with quality insights on their target audiences (profiles, expectations, behaviors), refine positioning, communication strategies, go-to-market plans, and identify early opportunities for new product development
- Deployment of astrategic watch ecosysteminvolving 16 collaborators (internal training and coaching, query optimization, sourcing and curation coordination)
- Several studies aimed at improving the **customer journey and experience at various tourist sites in the department**, using service design methods enriched with data approaches (e-reputation analysis, etc.)
- Nautisme en FinistèreObservatory Project ManagerPUBLIC SECTORSeptember 2012 - March 2018 (5 years and 7 months)Quimper, FrancePublic establishment responsible for the departmental nautical and maritime policy. My role included managing:
- The design, implementation, and exploitation (publications, datamarts) of a **unique territorial observation system for nautical activities in Europe**, allowing for fine-grained monitoring, through surveys, collation of various data sources, automated watch, and machine learning processes, of the evolution of nautical practices of the local population and tourists, and the economic activity of over 300 nautical centers, clubs, and similar entities, 500 companies in the nautical sector (boat building, equipment manufacturers, retail, service providers, training organizations, etc.), and 250 marinas and mooring areas.
Recommendations
Be the first to recommend Olivier
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
- Master's in Geomatics and Project ManagementUniversity of Avignon2006Formation double compétence géomatique (SIG, bases de données, algorithmique, statistiques) et projets de territoires (aménagement, développement local, stratégies territoriales, développement économique, infrastructures)
- Master Engineer's Degree - Tourism & PlanningUniversity of Toulouse II2002Gestion des structures touristiques (comptabilité, gestion, analyse financière, droit, anglais) Ingénierie de projet (gestion de projet, ingénierie financière, marketing, statistiques et observation, communication, projets web, éditions) Aménagement et développement local (géographie, économie, développement local)