Freelancer profile translated to English.
Back to original languageAbout Otmane
Data Analyst specializing in automation, data quality, and the creation of reliable pipelines. I help companies collect, clean, structure, and analyze their data to make better decisions and reduce manual work.
With a hybrid background (clinical, retail, freelance projects), I work across the entire data cycle:
- Automation via Python, API, LLM, VBA
- Advanced SQL analyses (BigQuery)
- Performance-oriented Power BI dashboards
- Data quality & validation (rules, checks, Pydantic)
My approach: understand business needs, simplify workflows, ensure data reliability, and deliver actionable results quickly.
French
Native or bilingual
English
Conversational
Arabic
Native or bilingual
Remote only
Primarily works remotely
Experience
- Hospices Civils de LyonData Manager & Data Analyst in Clinical ResearchMEDICALSeptember 2025 - Today (11 months)Lyon, FranceDesign and optimization of data collection and management systems in a regulated environment.Creation of complete eCRFs (REDCap, Ennov) and implementation of consistency rules to ensure data quality.Automation of import and processing pipelines via VBA, Python, and REDCap API (reduction of manual processing time).Data lifecycle management: export, quality control, freeze, lock, archiving.Coordination with medical and biostatistics teams to ensure the reliability of analyses.Writing of the Data Management Plan and management of randomized studies.Key skills: automation, data quality, API, Python, VBA, workflows, data ops, regulated environment.
- FREELANCEFreelance Data AnalystJanuary 2024 - September 2025 (1 year and 8 months)Lyon, FranceEnd-to-end data project execution: collection, cleaning, automation, analysis, and visualization.Project 1 – Automated fundraising verificationWeb scraping to extract key financial data.Format normalization (dates, currencies) and advanced cleaning.Automation of checks via an LLM model (OpenAI API).Data validation with Pydantic and report generation (CSV/Excel).Implementation of a scoring system to evaluate the reliability of fundraising.Project 2 – Identifying the cheapest gas stationData collection from Data Gouv and cleaning in Google Sheets.Deployment on Google Cloud and advanced SQL analyses in BigQuery.Creation of interactive dashboards in Looker Studio to identify the most economical stations.Key skills: Python, SQL, BigQuery, Looker Studio, scraping, API, LLM, automation, data cleaning, cloud, scoring, reporting.
- Groupe CasinoStore Manager & Data AnalystRETAIL (LARGE RETAILERS)June 2018 - December 2023 (5 years and 6 months)Lyon, FranceOptimization of commercial performance through data analysis and the implementation of decision-making tools.Sales and transaction analysis via Excel and SQL to improve stock forecast accuracy (+40%) and reduce stockouts.Design of Power BI dashboards to track store performance, margins, inventory, and operational KPIs.Publication and automation of reports via Power BI Service to facilitate daily decision-making.Collaboration with regional teams to identify improvement levers and optimize operations.Key skills: Advanced Excel, SQL, Power BI, stock forecasting, operational optimization, commercial analysis, automated reporting.
Recommendations
Be the first to recommend Otmane
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
- Data Analysis TrainingWild Code School2023Formation en Data analysis
- Master in Management and Project ManagementIAE2017Master en Management et gestion de projets