Freelancer profile translated to English.
Back to original languageAbout Fatima
Data Engineer and Analyst with 6+ years of experience on large-scale cloud projects in critical sectors - energy (Schneider Electric), rail (SNCF), automotive industry (Renault), pharma (Sanofi). Specializing in the design of robust data pipelines, multi-source integration (Salesforce API, SFTP, SMB), automated quality controls, and the delivery of cloud-native BI solutions. Proven mastery of AWS Glue, Redshift, Azure Databricks, SnapLogic, Power BI. Dual Microsoft Azure certified (AZ-900 & DP-900). Comfortable in an international environment with daily communication in English.
English
Native or bilingual
French
Native or bilingual
German
Basic
Can work on-site
Lyon (up to 50km)
Experience
- Schneider ElectricData Engineer / BI EngineerENERGY AND UTILITIESMarch 2023 - Today (3 years and 3 months)Lyon, France► Design, configuration, and maintenance of multi-source data ingestion pipelines: Salesforce API, SFTP, SMB, SAP, CSV/JSON files.► Development of ETL/ELT pipelines with SnapLogic to feed the central Data Warehouse (PostgreSQL) according to business functional specifications.► Migration of data flows to AWS Cloud: transfer to Amazon S3, analytical querying on Amazon Redshift.► Implementation of automated quality controls (Data Quality) and data flow reliability.► Development of advanced SQL queries, functions, and stored procedures on PostgreSQL for data transformation.► Automation of ETL processes: CSV/JSON/Parquet manipulation, API calls, batch orchestration.► Deployment of pipelines with CI/CD monitoring and writing release notes for each delivery.► Unit and integration tests of ETL pipelines before each deployment; anomaly monitoring, corrections, and validation in the testing environment.► Code reviews: validation of code quality, adherence to development standards, regression detection, and feedback to developers.► Development of BI and data analytics solutions for business teams.► Gathering and analysis of business needs in workshops with Product Owners; writing functional specifications and user stories.► Agile/SCRUM piloting: sprint planning, daily stand-up, retrospective, sprint review, and product demo; backlog monitoring, prioritization, and technical load estimation. SnapLogic (ETL) PostgreSQL AWS S3 Amazon Redshift Python Salesforce API SFTP/SMB Agile/Scrum ETL/ELT, Pipeline
- CapgeminiData EngineerTRANSPORTATIONJanuary 2022 - October 2022 (9 months)Lyon, France► Orchestration of rail data flows via AWS Glue: Spark jobs, crawlers, Data Catalog design, and partition management.► High-performance storage and analytical querying on Amazon Redshift: query optimization, distribution and sort key management.► Development of AWS Glue ETL jobs with CloudWatch monitoring and Spark performance optimization.► Development of Power BI dashboards directly connected to the Amazon Redshift data warehouse.► Code reviews on Git: review of ETL jobs, validation of Spark transformations, adherence to best practices.► Integration tests of AWS pipelines: end-to-end validation before each release; writing sprint release notes.► Gathering of rail business needs in collaboration with Product Owners; writing user stories and acceptance criteria.► Agile/SCRUM ceremonies: sprint planning, daily stand-up, retrospective, sprint review, and iterative deliveries. Technical AWS Glue • · Glue ◦ · ◦ · Catalog Amazon Redshift ◦ · CloudWatch ◦ · Apache Spark ◦ · Power BI ◦ · SQL ATS keywords AWS Glue, Glue Jobs, Crawlers, Data Catalog, Redshift, CloudWatch, Spark, Power BI, DAX, SQL, ETL, Pipeline, Data Engineer, Cloud AWS, Rail, SNCF, Agile, Scrum
- Volvo via CapgeminiData Analyst / Data EngineerAUTOMOBILEOctober 2022 - March 2023 (5 months)Lyon, France► Vehicle Data Warehouse modeling: star schema design, fact and dimension table definition, SCD (Slowly Changing Dimensions) management.► Development of SQL queries and Spark/SQL processes on Azure Databricks for data transformation, aggregation, and validation.► Optimization of existing Power BI reports: reduction of loading times, redesign of data models, DAX measure optimization.► Creation of new Power BI reports with vehicle KPIs, publication on Power BI Service, and access rights management.► Use of DAX Studio for performance diagnostics and complex DAX formula analysis.► Functional and technical study, conceptual modeling with SAP Power Designer.► Gathering of analytical needs from vehicle teams; writing functional specifications and user stories.► Unit tests of DAX measures and functional acceptance testing of reports; KPI validation with business users.► Writing release notes for each sprint and technical documentation of data models.► Daily, review, and report ceremonies
Recommendations
Be the first to recommend Fatima
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 MIAGEPolytech Lyon Methods IT Applied to Business Management2020Master 2 MIAGE
- Master's degree MIAGEPolytech Lyon Methods IT Applied to Business Management2019Maitrise MIAGE
Certifications
- Azure Data Fundamentals — Microsoft CertifiedMicrosoft DP-9002022