Freelancer profile translated to English.
Back to original languageAbout Oussama
Data Engineer specializing in Azure, AWS, Databricks & Snowflake, I help companies design and optimize their data platforms.
With over 10 years of experience in BI and Data Engineering, I focus on:
- Designing robust data pipelines (ETL / ELT)
- Cloud migration (Azure / AWS)
- Modernizing data architectures (Databricks, Snowflake)
- Implementing high-performance reporting solutions (Power BI)
✅ Azure Data Expertise: ADF, Synapse, Azure DevOps
✅ Data Platforms: Databricks, Snowflake
✅ BI Migration: SSAS to Power BI (Premium Gen2)
✅ Automation & Scripting: PowerShell
Microsoft Certified (DP-700, DP-600), I have assisted several companies in migrating on-premise solutions to scalable and performant cloud architectures.
👉 My goal: to help you fully leverage your data with reliable, scalable, and performance-oriented solutions.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- AIR LIQUIDESenior Data EngineerENERGY AND UTILITIESJanuary 2023 - Today (3 years and 5 months)Paris, FranceEnvironment:Azure Data Factory, DBT, SSAS tabular, Power BI Premium, Synapse SQL Pool, DAX, Azure DevOps, AWS Athena, Airflow, Python
- Design and optimization of processing pipelines under ADF and DBT to ensure reliability and speed up the data chain.
- Migration of SSAS tabular cubes to optimized Power BI Premium datasets (RLS, incremental refresh).
- Implementation of CI/CD with Azure DevOps to secure and industrialize deployments.
- Migration to an AWS Lakehouse architecture (DBT/Athena, Iceberg, Airflow).
Impact:Improved pipeline performance and maintainability, while ensuring the consistency of key indicators for business teams. - GRTgaz - DSI - Pôle TertiaireAzure Data EngineerENERGY AND UTILITIESSeptember 2019 - December 2022 (3 years and 3 months)Bois-Colombes, FranceMigration of a BI application for energy management from an on-premise Microsoft environment to Azure BI:
- Migration of databases to Synapse SQL Pool and Azure SQL DB.
- Refactoring of SSIS flows with ADF V2: ELT method for data integration, use of Pyspark with Databricks notebooks.
- Storage in a multidimensional SSAS 2017 cube (IaaS): Powershell scripts for cube processing and partition management.
- POC for migrating the multidimensional SSAS cube (1 TB size) to Power BI Premium Gen2.
- CI/CD with Azure DevOps.
- Report development with Power BI, DAX.
- MDX development.
Migration of the energy contract management application to Snowflake compute:- Implementation of incremental loads with Streams & Tasks and near real-time ingestion via Snowpipe.
- Development of ELT transformations and models with dbt on Snowflake.
- Implementation of data security and governance (RBAC, Row Access Policies, Masking Policies).
- Cost optimization and monitoring via Resource Monitors, auto-suspend / auto-resume.
- Industrialization of deployments with CI/CD and version management of Snowflake objects and dbt projects.
- Diot-SiaciTECHNICAL LEADER MSBI – TSQL – POWERBIBANKING AND INSURANCEApril 2017 - June 2019 (2 years and 2 months)Paris, FranceWithin the health and provident insurance actuarial department of SIACI, an insurance broker, as part of a 4-person project team, I was team lead for the design and development of the DWH for the French health and provident business line.Design and implementation of Data Marts for the "Benefits", "Collective Contributions", "Health Provident", and "Demographics" domains.- Facilitated business meetings and wrote functional specifications.- Design and management of the external business repository via MDS: client repository and hierarchy, health procedure repositories and hierarchy, population repository...- Migration of the client P&L VBA tool to the DWH: optimization of calculation time by keeping only the display part in the tool.- Optimization of operational reports for health claims: partitioning of the large benefits fact table, creation of indexes.- SSRS development for extractions and Power BI reports for steering.- Automatic invoicing tools for healthcare benefits for insurers.- Steering tools for the sales network, primarily based on the "collected contributions vs. paid benefits" indicator.
Recommendations
GG
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
- National Engineering Diploma in Statistics and Information AnalysisHigher School of Statistics and Information Analysis of Tunis2010Etude en informatique et statistique
Certifications
- DP-700 Microsoft Certified: Fabric Data Engineer AssociateMicrosoft2025
- DP-600 Microsoft Certified: Fabric Analytics Engineer AssociateMicrosoft2025