Freelancer profile translated to English.
Back to original languageAbout Albert
Building and maintaining ETL and ELT pipelines:
- Setting up and configuring architecture with AWS Step Functions
- Monitoring and maintaining processes with AWS CloudWatch + ELK
- Structuring Python processing code through hexagonal architecture
- Industrializing Python data processing projects with Ansible and Jenkins
- Modeling multidimensional models (Facts and Dimensions)
- Creating and populating the Snowflake data warehouse (AWS Lambda + Snowflake stage bulk loading)
- Exposing Lambdas with AWS API Gateway
- Creating AWS resources with Terraform
Cloud Architecture:
- Creating and documenting the cloud architecture for various projects.
- Creating and maintaining network interactions between different services (VPC, Subnets, Security Groups, Endpoints)
Technologies:
- Various AWS services: AWS Batch, Lambda, CloudWatch, Athena, RDS, PostgreSQL, S3...
- Infrastructure as Code with Terraform.
- AWS Step Functions for batch processing
- Python programming
- Snowflake, AWS RDS, PostgreSQL, ORACLE Data Warehouses
- CI/CD Jenkins + Ansible
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- Sanofi - Digital Accelerators
On Malt
Data Engineering in Python AWS and SnowflakePHARMACEUTICALS INDUSTRYMarch 2025 - March 2026 (1 year and 1 month)Paris, France- Technical Solution Scoping
- Data Warehouse + Datamart Modeling
- ETL Implementation (Snowflake + DBT + Airflow + SQL + Python)
- AWS Infrastructure Deployment with Terraform
- Logging and Observability
- Support for GxP best practices
- Daily run of already implemented flows
- Technical and functional documentation
- Sprint monitoring and ensuring priority adherence
- Process improvement for better delivery
- Supporting teams on cross-functional data projects
- SanofiData Engineering ExpertPHARMACEUTICALS INDUSTRYOctober 2024 - February 2025 (4 months)Paris, France
- Implementation of a data warehouse on Teradata
- Design and realization of ETL pipelines (SQL, Python, Teradata)
- Data modeling
- Scoping and refinement of technical specifications
- User/Role management
- Creation and monitoring of the data catalog
- Data Lineage (Documentation of data transformation flows)
- Data Quality (Design of a test case model, definition of the validation process, design and implementation of the data quality verification flow, and definition of test levels)
- Believe SALead Data EngineerFILM AND AVFebruary 2023 - September 2024 (1 year and 8 months)Paris, FranceScope and delegate tasks to the data engineers in my team,Design and deploy data ingestion architectures,Ensure daily monitoring of flows and responsiveness in addressing production incidents,Monitor AWS and Snowflake flow costs,Ensure proper sizing of AWS Lambda execution environments,Analyze the impacts of technical debt and prioritize their correction accordingly.Design and enrich training data for data science teams,Manage the Data Engineer teams allocated to various projects,Participate in kickoff meetings with business stakeholders and analyze requirements to estimate workload, impacts, and potential dependencies.
Recommendations
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
- Engineer's degree, Ingénierie informatiqueUniversité de Technologie de Belfort-Montbéliard2019Engineer's degree, Ingénierie informatique
Certifications
- SnowPro Core CertificationSnowflake