El Houssine T.-Senior Data Analyst — Power BI • SQL • ETL • Web Analytics
Check rate
Experience
Data / BI Consultant
Ashfield Pharma
- Designed and delivered end-to-end Power BI reporting for Commercial, Supply Chain and Quality / Regulatory teams — semantic models in Direct Lake mode with advanced DAX measures — cutting reporting turnaround from days to hours (-70%).
- Built the upstream data preparation and orchestration layer using Dataiku (Flow, visual recipes) and Microsoft Fabric (Dataflows Gen2, Lakehouse / OneLake, Medallion Bronze / Silver / Gold), integrating ERP, CRM, LIMS and pharmacy / hospital sales data.
- Integrated web analytics data from Google Cloud Platform (GCP) and Piano Analytics to analyze audience behavior, engagement and content performance, supporting business teams in identifying high-value segments and optimizing digital performance.
- Defined, documented and validated KPIs with business owners: sales by molecule and market, stock-out rate, forecast accuracy, DSO, regulatory compliance rate.
- Ran requirements gathering directly with client stakeholders, led UAT and functional testing of data flows through to production release.
- Optimized refresh performance (query folding, scheduled refresh), reducing time-to-insight by 40%; ensured traceability and governance (GxP, MHRA, GDPR).
Power BI Consultant
Capgemini
- Designed and deployed the full Power BI reporting layer for the Security Operations Center (SOC): MTTD, MTTR, compliance rate and vulnerability-management KPIs, contributing to a 30% reduction in security incident MTTR.
- Ran requirements workshops with SOC managers, CISO and compliance stakeholders to translate security-monitoring needs into an agreed KPI framework and documented report specifications.
- Built and optimized the Power BI semantic models: star-schema data modeling over incident, asset and vulnerability data, with advanced DAX measures (rolling MTTD / MTTR, SLA attainment, severity-weighted backlog) and time-intelligence patterns.
- Developed Power Query (M) transformations and integrations with Microsoft Fabric and Databricks; tuned the refresh strategy and query folding, improving refresh times on critical reports by 40%.
- Implemented Row-Level Security by entity and perimeter, managed users, groups and workspace access, and configured on-premises / VNet gateways for secure connectivity to internal sources.
- Automated security log processing and data quality checks in Python (Pandas) — completeness, duplicate and threshold controls — and reconciled dashboard figures against source ticketing and scanning tools before each release.
- Produced technical and functional documentation and trained SOC analysts and CISO teams on the new reports, driving adoption and self-service usage.
Power BI Consultant | HR Data & Reporting
Société Générale
- Owned the full migration of the group's HRIS reporting suite — Evaluation, Talent, Diversity, Turnover and Absenteeism — from Tableau to Power BI, serving HR Business Partners and HR management in France and international entities.
- Modeled core HR data sourced from the group's HR information systems (HRIS) — headcount and organizational structure, employee master data, evaluation cycles, absence records — into a single governed golden source, replacing divergent country-level reporting.
- Rebuilt the Power BI semantic models from the ground up: star-schema data modeling and advanced DAX measures (FTE headcount, turnover and absenteeism rates, period-over-period and rolling comparisons), with entity- and region-level Row-Level Security so each subsidiary accessed only its own population.
- Reverse-engineered legacy Tableau workbooks and ran alignment workshops with HR stakeholders to reconcile conflicting business rules into one agreed definition per KPI — translating sensitive HR requirements into a maintainable BI solution.
- Led the Tableau / Power BI parallel-run: measure-by-measure reconciliation and validation against source systems before decommissioning, guaranteeing figure-for-figure accuracy on confidential HR indicators.
- Prepared and consolidated HR datasets using Dataiku (data preparation, joins, quality checks), reviewed existing Alteryx workflows to understand ETL logic during migration activities, and leveraged Dataflows Gen2, PySpark notebooks on Microsoft Fabric and SQL preparation layers.
- Supported functional testing and UAT with HR users, produced documentation and delivered end-user training to drive adoption.
Power BI / Tableau Performance Analyst
SNCF FRET
- Designed and delivered 4 Power BI dashboards (Train Performance, Penalties, Project Performance, Reciprocal Situations) and 2 Tableau reports for Operations, project and management teams.
- Gathered requirements from operational and finance stakeholders and translated them into functional specifications and an agreed KPI framework covering punctuality, penalty exposure and project delivery performance.
- Built the underlying data models — relationships, hierarchies (site / region / period), DAX measures for performance ratios and period-over-period comparison — with per-site Row-Level Security so each site accessed only its own perimeter.
- Automated ETL processes in Power Query (M) and SQL, replacing manual Excel consolidation and standardizing scheduled refreshes.
- Validated and reconciled reported figures against operational source systems, and trained business users on Power BI best practices to build reporting autonomy.
Data Analyst / Data Scientist
AttijariWafa Bank
- Detected behavioral banking fraud through biometric analysis of keystroke dynamics on the online banking platform.
- Developed unsupervised anomaly-detection models (Isolation Forest, clustering) in a Hadoop / Spark environment, with the data preparation pipeline in Python (Pandas, NumPy): cleansing, feature engineering and quality controls over high-volume session data.
- Integrated GCP and Piano Analytics web data with banking transaction and behavioral data to analyze user session patterns, detect anomalies and strengthen behavioral fraud detection models.
- Deployed real-time preventive security mechanisms (alerts, progressive blocking) with no impact on legitimate user experience.
Data Analyst (Internship)
RMA Assurance
- Produced portfolio and claims reporting for business teams, consolidating policy, premium and claims data from core insurance systems into analysis-ready datasets.
- Automated recurring reporting and data quality controls, and supported business users on the definition and interpretation of their indicators.
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Transportation, Pharmaceutical, and Information Technology.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, and Marketing.
Summary
Senior data analyst with 5 years' experience turning business requirements into reliable, decision-ready data products. Hands-on across the full chain — data preparation and ETL flows in Dataiku, advanced SQL, and the semantic modeling and visualisation layer on top. Delivered reporting side by side with HR, Operations, Commercial and Finance stakeholders — including 24 months owning the HRIS reporting suite of a global banking group (headcount, employee data, talent, turnover, absenteeism) across France and international entities. Rigorous on data validation, reconciliation and quality control before any figure reaches a business user. PL-300 certified, English C2 / French C1, immediately available.
Skills
Power Bi & Semantic Modeling
- Advanced Dax
- Star-Schema Data Modeling
- Power Query (M)
- Power Bi Desktop / Service / Report Builder
- Row-Level Security (Rls)
- Direct Lake
- Performance Tuning
- Deployment & Governance
Sql & Data Preparation
- Ms Sql Server / T-Sql (Advanced)
- Snowflake
- Bigquery
- Ssis / Ssas / Ssrs
- Python (Pandas, Numpy, Scikit-Learn) For Data Preparation And Automation
Data Validation & Quality Control
- Source-To-Report Reconciliation
- Parallel-Run Validation
- Automated Quality Checks And Anomaly Detection
- Functional Testing Of Data Flows
- Uat And Production Release
Workflow Orchestration & Cloud
- Dataiku (Flow, Visual Recipes, Data Preparation, Workflow Automation)
- Alteryx (Workflow Review, Etl Logic Analysis)
- Power Automate (Process Automation, Approval And Notification Flows)
- Microsoft Fabric (Dataflows Gen2, Pyspark Notebooks, Lakehouse / Onelake)
- Azure
- Google Cloud Platform (Gcp)
- Databricks
- Hadoop / Spark
- Git / Github / Bitbucket
- Jira
Web & Audience Analytics
- Piano Analytics
- Gcp Web Data Integration
- Audience Behavior And Engagement Analysis
- Content Performance
- User Segmentation
Business Analysis & Project Management
- Requirements Gathering
- Functional & Technical Specifications
- Solution Design Workshops
- Gap And Impact Analysis
- Kpi Definition
- Project Planning And Delivery Tracking
- Workstream And Stakeholder Management
- Uat Coordination
- User Training And Change Management
- Agile (Scrum) And V-Model
Business Domains
- Banking & Financial Services
- Insurance
- Finance & Controlling Kpis
- Hr & Hris Reporting (Employee Data, Headcount, Absence, Talent)
- Operations & Performance
- Commercial & Supply Chain
- Digital & Web Audience
Languages
Education
IA School
Master of Artificial Intelligence and Management, Data Science · Artificial Intelligence and Management · Boulogne-Billancourt, France
Université Paris 12
Bachelor's · Mathematics & Statistics · Créteil, France
Preparatory Classes for Grandes Écoles (MP)
Certifications & licenses
DP-600 — Microsoft Fabric Analytics Engineer Associate (in preparation)
PL-300 — Microsoft Power BI Data Analyst Associate
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
El Houssine is based in Paris, France.
El Houssine speaks the following languages: English (Advanced), French (Advanced), German (Elementary).
El Houssine has at least 5 years of experience. During this time, El Houssine has worked in at least 5 different roles and for 5 different companies. The average length of individual experience is 1 year. Note that El Houssine may not have shared all experience and actually has more experience.
Based on recent experience, El Houssine would be well-suited for roles such as: Data / BI Consultant, Power BI Consultant, Power BI Consultant | HR Data & Reporting.
El Houssine's most recent position is Data / BI Consultant at Ashfield Pharma.
In recent years, El Houssine has worked for Ashfield Pharma, Capgemini, Société Générale, and SNCF FRET.
El Houssine is most experienced in industries like Banking and Finance, Transportation, and Pharmaceutical. El Houssine also has some experience in Information Technology.
El Houssine is most experienced in business areas like Business Intelligence, Information Technology, and Marketing.
El Houssine holds a Master in Artificial Intelligence and Management from IA School and a Bachelor in Mathematics & Statistics from Université Paris 12.
El Houssine has 2 certificates. These include: DP-600 — Microsoft Fabric Analytics Engineer Associate (in preparation) and PL-300 — Microsoft Power BI Data Analyst Associate.
El Houssine will be available full-time from November 2026.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 22 Oct 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Marco S.
Eric B.
William N.
German P.
Simon S.
Pierre-Jean A.
Deepa F.
Petru K.
Eduard V.
Olivier H.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data / BI Consultant
Rami K.
Mario T.
Amit M.
Fares H.
Paulo M.
Ymène B.
Achim G.
Hervé T.
Sofian M.
Andreas F.
Nearby freelancers
Professionals working in or nearby Paris, France
Marc C.
Rim Z.
Bhuvanesh D.
Éric G.
Adel G.
Andon M.
Aakash P.
Fatima B.
Hervé H.
François G.
