About Nicolas
English
Fluent
French
Native or bilingual
Experience
- Aviv Groupe SeLogerData EngineerREAL ESTATEJanuary 2020 - Today (6 years and 5 months)Paris, FranceData Lakehouse & Cloud Architecture (IaC):
- Strategic migration of the on-premise BI ecosystem (MS SQL Server/SSIS) to AWS Cloud (RDS, S3, Lambda), improving service efficiency and scalability.
- Design and automation of Cloud Data infrastructure (Glue, EMR, S3) using Infrastructure as Code (IaC) with Terraform.
- Data Mesh/Cloud Data Warehouse Project: Participation in the initial deployment (2 months of experience) of the new Data Platform using Snowflake and the dbt (Data Build Tool) methodology for industrializing transformations and data quality tests.
- Management and administration of Data Lake tables in Apache Iceberg format for critical data and Apache Hudi format for data requiring rapid updates (Upserts).
Big Data Development (Spark) & Industrialization :- Design and industrialization of robust ETL/ELT pipelines in Scala/Spark and Python (on AWS EMR/Glue) to integrate and process complex multi-source data (Salesforce API, BigQuery, MongoDB) into Snowflake and the S3 Data Lake.
- Modeling of aggregated datasets and calculation of strategic KPIs for Finance.
Monitoring, Quality & Senior Methodology :- Implementation of service Observability and Monitoring using Datadog dashboards and metrics to monitor performance and data flow SLAs.
- Daily work in Agile methods (Scrum/Kanban) and project management via Jira.
- International collaboration (Germany, Belgium) with daily technical communication in English.
- Analytical support (Jupyterlab Notebooks) and maintenance of Tableau dashboards.
Main Stack : Spark, Scala, Python, Snowflake, AWS (Terraform, Glue, EMR, S3, Step Functions), dbt, Apache Hudi, Apache Iceberg, Airflow, Datadog, Tableau. - AutodistributionBI ConsultantAUTOMOBILEJanuary 2010 - February 2014 (4 years and 1 month)Chilly-Mazarin, France• Datamart & cube modeling• Design of feeding procedures• Development of feeding procedures (Ebook project: sales stats, product/customer files on tablets for sales representatives)• Creation of business views• Creation / Evolution of Report Studio reports (Logistics: service rate, turnover rate, depreciation; Daily/monthly sales stats)• Optimization• Writing functional documentation• Writing technical documentation• Writing the Operations Manual• Writing the User Manual
- EfidisBI ConsultantREAL ESTATEApril 2012 - May 2015 (3 years and 1 month)Paris, France• Migration of existing SAP/BusinessObjects XI R2 to SAP/BusinessObjects 4.1• Design of feeding processes• Development of feeding procedures• Creation of business views (universes)• Creation of new reports (Quality: management of requests and interventions, FOST: safety and security monitoring files)• Evolution of existing reports (Student Housing)• Writing functional documentation• Writing technical documentation• Support for deliverable acceptance testing
Recommendations
Be the first to recommend Nicolas
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 2 MIAGEESIAG - University Paris XII2009Ingénierie des Systèmes d’Information et d’Aide à la Décision
- BTS Management Information SystemsSt Gabriel High School2006
Certifications
- DAT207x: Analyzing and Visualizing Data with Power BIedX2019