Freelancer profile translated to English.
Back to original languageAbout Hafid
Freelance Data Engineer with proven expertise in cloud data architecture, I help companies transform their raw data into reliable and actionable strategic assets.
I intervene end-to-end: from cloud architecture design (GCP, Azure) to the delivery of Power BI reports in production, including data warehouse modeling and setting up robust ELT pipelines with DBT and Airflow.
What I concretely bring:
My missions cover the design and deployment of scalable data warehouses on BigQuery and Azure Synapse, the creation of maintainable ELT/ETL pipelines (DBT, Airflow, SSIS), the industrialization of Power BI reports with model governance (TMDL, DAX, RLS), the implementation of data CI/CD (Gitlab, Argo CD, Terraform), as well as data governance and data exposure via Analytics Hub.
I work on both greenfield projects and complex cloud migrations.
Sectors & references:
I have supported demanding clients in regulated environments: pharma (Servier) and banking-insurance (BPCE, Natixis). These contexts have instilled in me a rigor for data quality, documentation, and compliance.
My approach:
I don't just deliver code or dashboards. I ensure that teams take ownership of the solutions: sharing best practices, usable documentation, skills development integrated into each mission.
Technical Stack:
Cloud & Infrastructure: GCP (BigQuery, Dataflow, Analytics Hub), Azure (Synapse, Data Factory), Terraform, Gitlab CI/CD, Argo CD
Data Engineering: DBT, Apache Airflow, SSIS, Python, SQL, T-SQL
Business Intelligence: Power BI (TMDL, DAX, RLS, Fabric), SSRS
Governance & Quality: automated tests, technical documentation, pipeline monitoring
French
Native or bilingual
English
Fluent
Can work on-site
Paris 12e Arrondissement (up to 50km)
Experience
- Servier MondeSenior Data Analytics EngineerPHARMACEUTICALS INDUSTRYSeptember 2023 - Today (2 years and 9 months)Creation and optimization of Power BI reports, including data analysis and modeling, as well as automation of data flows.Automation of processes for detecting broken visuals in reports, using scraping scripts and alerts, to ensure dashboard reliability.Continuous deployment and migration of Power BI datasets from Azure to GCP, with robust CI/CD management, using GitLab and Argo Workflow for optimized efficiency.Exposure of data to all subsidiaries via Analytics-Hub, allowing them to access datasets automatically and securely. Complete project documentation.Tech Env: GCP, DBT, Terraform, K8s, Argo, Python, Gitlab CICD, Power BI (DAX, MDX, TMDL), skills=[]
- Groupe BPCETech Lead MSBIBANKING AND INSURANCEOctober 2022 - September 2023 (11 months)Paris, FranceMission 1: Project to provide an employee rating tool and a Power BI Report for the Customer Relations Call department.• Development of a rating tool• Technical and functional acceptance testing• Creation of Power BI report• Implementation of Row-Level Security (RLS)• Deployment and availability of the Power BI report in the cloud• Writing a user manualTools: SQL Server, Power-BI, SharePointMission 2: Project to provide a reporting and visual management tool for the Complaints department.• Requirements gathering• Data analysis, qualification, restructuring, and validation• Development and automation of SSIS package• Automation of data file transfer and directory update• Creation of Power BI report• Deployment and availability of the Power BI report in the cloudTools: SQL Server, Power-BI, SSIS, Power AutomateMission 3: Project to retrieve and report all telephone and written activity for the Customer Relations department.• Requirements gathering• Writing the interface contract• Analysis, qualification, restructuring of data from Salesforce CRM and Diabolocom call center software• Creation of Power BI report• Implementation of Row-Level Security (RLS)• Deployment and availability of the Power BI report in the cloudTools: SQL Server, Power-BI, SSISMission 4: Project to create a comprehensive and synthesized report of all activities of the expertise and customer relations center for senior management.• Requirements gathering• Writing the specifications• Creation of queries on existing reports and relevant Datamarts• Automation and orchestration of data flows (Power-Automate)• Data pooling• Creation of Power BI reportTools: SQL Server, SSIS, Power-Automate, Power-BI, skills=[SkillTranslatableContent(id=PowerBI, type=GLOBAL, name=PowerBI), SkillTranslatableContent(id=Microsoft SSIS, type=GLOBAL, name=Microsoft SSIS), SkillTranslatableContent(id=SQL Server, type=GLOBAL, name=SQL Server), SkillTranslatableContent(id=Salesforce, type=GLOBAL, name=Salesforce)])
- NatixisBI EngineerBANKING AND INSURANCESeptember 2019 - October 2022 (3 years and 1 month)Paris, FranceMission 1: Project to analyze the digitalization rate of BPCE group establishments.• Assistance with relational modeling and creation of a DataMart (SQL Server)• Data analysis, qualification, and restructuring.• Development and automation of an ETL and integration rules (SSIS)• Creation of an OLAP Cube (SSAS) and implementation of measures using MDX language• Production of a Power BI Report• Writing documentation• Writing a user manualTools: SQL Server, SSIS, SSAS, Power-BIMission 2: Project to provide an activity monitoring tool and a reporting tool for the Sensitive Cases department.• Requirements gathering• Writing the specifications• Development of an activity tracking data entry tool for the department• Creation of a Power BI report• Technical and functional acceptance testing• Creation of a deployment pipeline and availability of the Power BI report in the cloud• Writing documentation and a user manualTools: SQL Server, Power-BI, SharePointMission 3: Data Science and process mining project to calculate and predict employee performance.• Requirements gathering• Writing specifications and documentation• Data management• Data cleaning• Development of a prediction algorithm (Machine Learning)• Development of a process mining tool• Data VisualizationTools: Python 3, SQL Server, libraries: Scikit-learn, numpy, pandas, matplotlib, pm4py (process mining 4 python), skills=[]
Recommendations
Be the first to recommend Hafid
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 of Data Engineer | ScienceYnov InformatiqueMaster Data Engineer, Science des données
- Bachelor's degree, Web and Mobile Application Programming / DesignIPI Institut Poly InformatiqueLicence, Programmation /Conception application web et mobile
Certifications
- DP-203: Microsoft Azure Data Engineer AssociateMicrosoft2022