BSFreelancer profile translated to English.
Back to original languageAbout Bamogo
Confirmed Data Engineer & Data Analyst BI with solid experience in data engineering, business intelligence, and data quality, particularly in complex HR and business environments. I work across the entire data chain: ingestion, transformation, and modeling (Python, SQL, Snowflake, dbt), datamart creation, and BI reporting development (Power BI). Accustomed to collaborative environments, I combine technical expertise, business understanding, and data project management to deliver reliable, useful, and decision-oriented solutions.
French
Native or bilingual
Can work on-site
Vélizy-Villacoublay (up to 50km)
Experience
- Nestlé France - Equipe People Analytics-Confirmed Data Engineer & Data AnalystSeptember 2023 - August 2025 (1 year and 11 months)92130 Issy-les-Moulineaux, France
- Design and optimization of ETL/ELT pipelines (SAP, SuccessFactors, SharePoint, semi-structured files) with workflow automation and data quality control
- Cloud integration of pipelines with Snowflake (staging, transformations, streams/tasks) and AWS (S3, Lambda)
- Construction and maintenance of analytical pipelines for datamarts and Power BI datasets: dependencies, parameterized artifacts, refresh optimization
- Design of Power BI dashboards connected to Snowflake: gathering business requirements, KPI definition, modeling, and visualization
- Development and optimization of data transformation and validation algorithms (imputation, checks, anomalies, matching, aggregation, standardization) implemented in Snowflake (Tasks, UDF, scaling)
- Deployment of predictive models (Python & SQL): automated feature engineering, orchestration (AWS Lambda / Snowflake Tasks), inference tables, and BI exposure
- Data & BI RUN Management: pipeline monitoring, refresh supervision, incident management, performance optimization
- Orchestration and documentation of Data Engineering workloads: versioning, CI/CD, best practices, technical documentation, and DataOps compliance
- Contribution to the Data ecosystem: batch scripts, automation, refactoring, Snowflake optimization, continuous improvement (Jira, Confluence)
- CNRS - Equipe Projet POLECOWWIIData EngineerApril 2023 - September 2023 (5 months)Lille, France
- Development of automated ETL pipelines for extracting and transforming textual data from the BnF
- Design of Python scripts for structuring, normalizing, cleaning, and converting data into standardized formats
- Implementation of advanced Data Cleaning & Data Quality procedures: consistency checks, data validation, deduplication, harmonization via fuzzy matching
- Centralization and consolidation of data into a unified dataset for statistical analysis of the research project
- Construction of SQL tables (SQLite) and generation of structured CSV files to facilitate reuse and analysis
- Complete documentation of data ingestion, transformation, and quality control processes
- Close collaboration with the interdisciplinary research team to ensure the quality, reliability, and usability of historical data
- Delivery of final datasets in SQL and CSV formats, accompanied by detailed technical documentation
- Université Clermont AuvergneDATA ENGINEER & ANALYSTJanuary 2023 - March 2023 (2 months)Clermont-Ferrand, France
- Development of an automated ETL/ELT pipeline for collecting, transforming, and structuring Hacker News data via web scraping
- Automation of continuous extraction of articles, votes, scores, and user profiles (Scrapy, Requests, BeautifulSoup)
- Cleaning, normalization, deduplication, consistency checking, and data quality improvement
- Modeling and optimization of SQL tables (SQLite) and export of consolidated datasets in CSV format
- Construction of analytical tables serving as a basis for statistical analyses and visualizations
- Performing statistical analyses: user activity, temporal trends, vote dynamics, time to appear on page 1, post rotation time
- Anomaly detection and analysis of article trajectories (score variations, persistence, double submission)
- Production of analytical visualizations for exploring and interpreting results
- Technical stack: Python (Pandas, NumPy, Scrapy, Requests), SQL (SQLite), ETL/ELT, CSV, Matplotlib, Seaborn
Recommendations
Be the first to recommend Bamogo
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 of Data ScienceUniversité Clermont Auvergne2023Master Sciences des Données
- Bachelor of Computer Methods Applied to Business ManagementUniversité Clermont Auvergne2021Licence Méthodes Informatiques Appliquées à la Gestion des Entreprises