Freelancer profile translated to English.
Back to original languageAbout Matthias
🎯 Freelance data with 10+ years of experience, I intervene on Malt for expertise missions, SQL audit and BigQuery optimization.
Objective: reduce your cloud costs and improve your performance.
🚀 Solid experience in mass retail on critical data projects combining structuring, industrialization and business piloting (margin, sales, commercial animation, stock depreciation, revenue).
👨💼 Today Data Team Leader at Auchan Retail, I manage a strategic scope and supervise a team of 6 to 9 people.
My team has become the internal training center for new data engineers: they spend several months there to master frameworks, best practices, and standards before being deployed elsewhere.
🧠 I combine a dual role:
• Technical: data architecture, dynamic SQL, GCP, BigQuery, automation, cost/performance optimization
• Organizational: supervision, backlog, estimations, committees, business-technical coordination
🔧 Key achievements:
• Design of the stock reporting layer on Teradata and BigQuery equivalent (sales/revenue via BI Engine)
• Migration of critical domains Teradata → GCP/BigQuery
• Advanced SQL optimization (estimated recurring savings of $30–40k/year on Pilot’Ventes)
• Direct contribution to the evolution of the Pilot’Ventes tool (margin + revenue)
• Types of missions on Malt: flash SQL/BigQuery audit, cost/performance optimization week, data team support
🛠️ Stack: GCP / BigQuery / dynamic SQL / BI Engine / Teradata
👥 Methodology: Agile / Jira / backlog / estimations / committees
📈 My role: create an effective bridge between technical, business, and strategy, with a clear, structured, and results-oriented approach.
📍 Based in Hauts-de-France, open to remote, including internationally.
Spanish
Conversational
English
Fluent
French
Native or bilingual
Remote only
Primarily works remotely
Experience
- Auchan RetailData Team LeaderRETAIL (LARGE RETAILERS)April 2023 - Today (3 years and 4 months)Villeneuve-d'Ascq, France🎯 Functional scope managed• Sales Data: receipts, orders• Commercial Animation: flyers, promotions, customer benefits• Sales Margin, Revenue Reporting, Performance Indicators💼 Key Achievements• Data referent for margin, receipts, and revenue publication• Design of the sales reporting layer on BigQuery:→ Optimized dynamic SQL procedures→ Use of BI Engine to improve Pilot’Ventes performance• SQL optimization on several critical flows to reduce BigQuery costs• Participation in the modeling unit (data exposure, best practices)• Maintenance & evolution of the Pilot’Ventes application (full build & run)👥 Leadership & Cross-functional Management• Supervision of a data team (6 to 9 people): developers, data engineers, analysts• Implementation of an Agile organization adapted to delivery (rituals, Jira backlog, planning)• My team became the internal training center: onboarding and skill development for new data engineers• Coordination with business units, architecture, and production: working groups, estimations, schedules, architecture committees🛠️ Stack & MethodologyGCP · BigQuery · dynamic SQL · BI Engine · Web Backend · Jira · Agile · CI/CD · Data Architecture
- Auchan RetailData Tech LeadRETAIL (LARGE RETAILERS)June 2020 - April 2023 (2 years and 10 months)Villeneuve-d'Ascq, France🎯 Functional Scope• Sales Data: receipts, orders• Commercial Animation: flyers, promotions, customer benefits• Store Business Actions, Performance Indicators💼 Key Achievements• Technical referent for the entire chain: from data capture to exposure• Migration of critical domains from Teradata to GCP / BigQuery• Redesign of the sales margin engine for more precise and reliable calculation• Development of dynamic BigQuery SQL procedures for Pilot’Ventes• Performance optimization via BI Engine and cost rationalization• Choice of data architectures and refactoring of complex queries (retail, promotions, sales)👥 Support & Coaching• Skill development for the team (mentoring, technical support)• Monitoring of build & run developments• Active participation in structuring the current technical framework🛠️ Stack & MethodologyGCP · BigQuery · dynamic SQL · BI Engine · Web Backend · Jira · Agile · CI/CD · Data Architecture
- Auchan RetailData EngineerRETAIL (LARGE RETAILERS)January 2018 - June 2020 (2 years and 5 months)Villeneuve-d'Ascq, France🎯 Key Contributions• Participation in the strategic Pilot Auchan project (sales, stocks, promotions)• Development of aggregation scripts, stored procedures, and geospatial functions (Teradata)• Implementation of data flows and backend exposure for Pilot’Stocks, Pilot’Ventes, Pilot’Promo• Advanced SQL optimization (processing time, industrialization, automation)• Close collaboration with business units to adapt flows to concrete uses🛠️ Stack & EnvironmentTeradata · SQL · Webservices · Agile · Pilot'Apps Backend · Geospatial · Process Automation
Recommendations
Be the first to recommend Matthias
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
- DUT STID2 years University Lille 2 Law And Health, Roubaix2005
- Master in Computer ScienceUniversity Lille 1 Sciences And Technologies, Villeneuve D'Ascq2009