Freelancer profile translated to English.
Back to original languageAbout Lucas
Hello!
Do you want to build reliable pipelines and clear analytical models?
Speed up your daily processing and reduce your costs?
I can help you with the entiredatavalue chain.
Data Engineerspecializing in **Analytics Engineering**, I can assist you with the following topics:
•ETL/ELTdata pipelines (design, optimization, orchestration withAirflowordbtCloud)
• data transformation and analytical modeling with dbt (Data Vault V.2, star schema)
• modern data warehouses and migration to a Modern Data Stack (Snowflake, Databricks)
•SQLperformance optimization and automation, to save time and resources
• data quality and governance (automated tests, documentation, process implementation...)
• support and training for business teams in the use of data products (setting upworkshops, self-service approach)
• implementation of agent systems (Github Copilot CLI) — operational process automation, autonomous monitoring, reduction of manual interventions
• platform operational maintenance, including bug fixes and hotfixes
•web scraping (data collection automation) for competitive intelligence purposes
Highly impact-oriented, I have, for example, generated a daily saving of 10% in resources for my last client by optimizing theirdbtmodels, or saved a startup's data team 5 days per month by rethinking their data extraction procedures.
Technical Stack:
SQL • Python • Bash • Snowflake • dbt • Power BI • Linux • Azure • Airflow
Methodologies:
• Agile (Scrum / SAFe)
• CI/CD
• Test Driven Development
Experience in Supply chain & luxury in startups, and large groups (Geopost).
Former military — I bring rigor, clarity, direction, and the ability to deliver under pressure.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 20km)
Experience
- PickupAnalytics EngineerLOGISTICS AND SUPPLY CHAINSeptember 2024 - Today (1 year and 11 months)Saint-Ouen, France- Development and architecture of dbt models (Data Vault 2.0, star schema, SQL, CI/CD) on Snowflake — optimizations that generated -10% resources/day- Creation and maturation of Streamlit applications (Python) to offer business teams autonomy in configuring their key indicators- Automation of our platform monitoring process using a Linux pipeline (Bash script on Raspberry using Python scripts), allowing continuous monitoring and tracking of key indicators- Training and support for business teams on our data products and SQL, facilitating the adoption of a self-service approach- Migration of the legacy system to Snowflake, improving governance and pipeline performance- Advanced debugging and incident resolution on production data pipelines (Snowflake, dbt)- Semantic modeling and creation of Power BI reports for business teams- Integration and processing of geospatial data (shapefiles, H3) to optimize the strategic grid for relay point recruitment and locker installation- Implementation of an agent system with Github Copilot CLI to automate a functional role, saving my team 40 minutes per dayTechnical Stack: SQL, dbt, Snowflake, Python (Streamlit, Pandas, Snowpark), Linux, Power BI
- Data&Data - The intelligence of luxuryData EngineerLUXURY GOODSJune 2023 - September 2024 (1 year and 3 months)Paris, France- Development of a REST API with FastAPI (Python) and deployment on Azure with Docker, allowing our clients to access the data they need more quickly- Development of web scraping solutions with Selenium and Python to allow our clients to track the evolution of parallel markets- Workflow orchestration with Airflow, to automate repetitive processes- Conducting code reviews and mentoring junior developers- Optimization of data extraction processes, resulting in a saving of 5 days per month for my team- Strategy analysis to help our clients position themselves in the second-hand market- Implementation of Dashboards with Power BI and customer support in product usageTechnical Stack: Python (Selenium, Pandas, FastAPI), SQL, Linux, Azure, Airflow, Docker, Power BI
- Upwork & DolthubData EngineerENTERTAINMENT AND LEISURENovember 2022 - November 2023 (1 year)Paris, France- Technical contribution to the writing of a puzzle book on chess (scripted analysis of 67,000 chess games)- Development of an AI-powered web application for musicians- Collaboration on the open-source project payless-health (Dolthub); database enrichment, web scraping, exchange with the platform's developers to allow users to pay the least amount possible for their medical care- Optimization of a schedule within the framework of a contest- Development of a financial dashboardTechnical Stack: Python (Selenium, Dash), SQL
Recommendations
Be the first to recommend Lucas
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
- Professional data scientist , Data scienceDATACAMP2023Professional data scientist , Data science
- Data scientist developer (RNCP level 6), Data scienceJedha Bootcamp2023Concepteur / développeur en science des données (RNCP niveau 6), Data science