Freelancer profile translated to English.
Back to original languageAbout Mohamed Ali
Data/Analytics Engineerconfirmedspecializing in the design of cloud-native pipelines onAWSand **PostgreSQL**.
5 years of experienceon high-volume projects (healthcare, energy, real estate), with strong expertise inSQLand **DBT**.
I have solid experience in creating, managing, and optimizing data pipelines to transform raw data into actionable insights.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- Emeria TechnologiesFreelance - Data EngineerREAL ESTATEJuly 2025 - Today (11 months)Paris, France
- Development and optimization of a large-scale real estate data migration and integration platform,
- consolidating data from recently acquired firms.
- Design and maintenance of an internal ETL in Go, orchestrated via GitLab CI/CD, based on a multi-staging architecture.
- Manipulation and transformation of complex data in PostgreSQL CTE, JSONB, window functions, SQL macros.
- Continuous improvement of SQL performance and integration processes, with a strong business focus (real estate,
- rental management).
- Analysis and correction of business anomalies in migrated and integrated data.
- Code review, active participation in CI/CD tests, and technical validation of developments.
- Integration and cleaning of data from multiple source software Esset, TTW, Krier, Immopen, etc.) into the new ERP
- Millennium.
- Creation of business alerts in JSONB for data quality monitoring (budgets, IBAN, surface anomalies, etc.).
- Air LiquideCDI - Analytics EngineerHEALTH AND WELLNESSSeptember 2023 - February 2025 (1 year and 5 months)Bagneux, France
- Development ofcomplex SQLqueries andPythonscripts for data processing and manipulation.
- Ingestion of multi-source data (SAP, Salesforce, MDM) toAWSusing Python, **Glue**, and **Lambda**.
- Storage and modeling of structured data inRedshiftand **Iceberg**.
- Development and automation of pipelines with dbt-Glue and continuous integration via **Git CI/CD**.
- Processing of identifiable health data on certified HDS machines in accordance with GDPR standards.
- Implementation ofData Vault 2.0modeling and themedallion architecture(Bronze, Silver, Gold).
- Creation of dbtmacrosto standardize processes and reduce code redundancy.
- Close collaboration with GDO and Data Office teams to ensure traceability, resilience, and scalability of analytical models.
- eni gas & power FranceCDI - Data EngineerENERGY AND UTILITIESSeptember 2020 - September 2023 (3 years)Levallois-Perret, France
- Design, development, and maintenance of over 50 data pipelines for ETL/ELT processes and business analyses.
- Processing of large data volumes withPySpark**, optimizing storage on **PostgreSQLand **Cassandra**.
- Improvement of workflow execution speed by40%through partitioning and parallelism.
- Complete automation of workflows withAirflowand **Jenkins**, ensuring real-time monitoring of processes.
- Design of dashboards on **Tableau Desktop / Cloud**, for monitoring churn, sales, and digital channels.
- Cross-functional collaboration with Marketing, Sales, and Collections teams to define tailor-made analytical needs.
- Implementation of analytical governance and security onTableau Cloud(MFA, Licenses, access by department).
Recommendations
Be the first to recommend Mohamed Ali
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's degree, Data scientistParis Ynov Campus2020Master's degree, Data scientist
- Licence, Informatique de gestionInstitut Supérieur de Gestion de Tunis2019Licence, Informatique de gestion
Certifications
- AWS Certified Cloud Practitioner (Validation number : TSM163MD1FE4Q9CM)AMAZON WEB SERVICE2021