Freelancer profile translated to English.
Back to original languageAbout Johann
My approach is simple: produce useful tools, not complex projects.
I work on data & BI missions with high operational value, with a clear objective: to make data usable, understandable, and directly actionable by business teams.
I primarily work on:
• Creation and optimization of Power BI dashboards
• Decision-making and operational reporting
• Automation of data and reporting flows
• Structuring simple pipelines on GCP / BigQuery
• Usage-oriented data modeling
• Implementation of reliable and maintainable data processes
My background has allowed me to work in various contexts:
local authorities, mass retail, finance, insurance, collective catering, regulatory projects, and institutional reporting.
I prefer missions:
✔ remote
✔ short
✔ structured
✔ with clear objectives
✔ with measurable business impact
I am particularly comfortable in environments where data must serve decision-making, steering, and operations, not unnecessary technical complexity.
French
Native or bilingual
English
Conversational
Can work on-site
Lille (up to 10km)
Experience
- Ville de LilleData AnalystPUBLIC SECTORApril 2025 - Today (1 year and 2 months)Lille, FranceTasks:
- Data Creation and Analysis:
Produce and communicate dashboards and activity indicators.Analyze purchasing activity and measure its effectiveness.- Data Analysis and Exploitation:
Collect, analyze, and format data available within the department.Develop indicators for monitoring purchasing volumes, with a focus on:Sustainable, local, and conventional products.Greenhouse gas emissions (via the BEGES report).Indicators related to public procurement (Egalim, AGRIME).- Occasional Contributions:
Conduct targeted analyses such as a mapping of food consumption.Create databases to improve the monitoring of attendance and consumption.Support the implementation of optimization plans for procurement.Support the Procurement Manager:Development of market monitoring tools (sourcing, benchmark, analyses).Management of purchasing needs by supplier and product. - Drive experienceData AnalystAUTOMOBILEDecember 2024 - January 2025 (2 months)Lille, FranceTasks:
- Data Collection and Structuring: Compile historical results data and create a PostgreSQL database for its storage and management.
- Database Population Automation: Develop Python scripts for data extraction, transformation, and loading (ETL), orchestrated by Bash scripts and a scheduled task for automated updates.
- Dashboard Development: Create an interactive dashboard on Power BI for data visualization and analysis.
- AusyData ConsultantBANKING AND INSURANCESeptember 2022 - November 2023 (1 year and 2 months)Wasquehal, FranceClient: Crédit Agricole AssuranceMission Context: Application Support / Application Manager / CMA PilotTasks:
- Configuration File Integration
- Reception, diagnostics, and resolution of blocking issues
- Coordination of development, testing, and delivery teams
- Creation of schedules for testing and production deployment of requests
- Monitoring of request evolution until production deployment
- Data collection and report creation on Power BI
Recommendations
Be the first to recommend Johann
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 in Information Systems and Decision Support, Data Science trackUniversity of Lille2022
- Bachelor's degree in Applied Mathematics and Social SciencesUniversity of Lille2020