Available for new opportunities

Senior Data
Engineer &
BI Architect

Cloud Analytics · Enterprise BI · Data Platform Design

Building scalable data platforms from shop-floor to cloud. Specializing in end-to-end pipeline engineering, enterprise BI migrations, and hyper-scale optimization across automotive, telecom, and manufacturing industries.

700M+
Rows Optimized
1,500+
BI Users Served
5+
Years Expertise
📊
BI & Visualization
Power BI · DAX · Cognos
Automation
Power Automate · Python · SQL
🏗️
Data Engineering
DBT · PySpark · Talend · SSIS
🔒
Governance & Security
RLS · RBAC · Azure AD
🤖
Big Data
ClickHouse · Spark · Hive
Hamza Nouri
Senior Data Engineer & BI Architect
PythonSQL Power BISnowflake AWSDAX Expert
5+
Years across
4 industries
About Me

The Builder.
The Optimizer.
The Migrator.

I'm a Senior Data Engineer and BI Architect who turns complex data challenges into clean, scalable, and profitable systems. I've delivered production platforms for global automotive groups, a major telecom operator, and industrial manufacturers — always end-to-end, always with measurable impact.

Whether you need a cloud-native pipeline, a Cognos-to-Power BI migration, or a 700M-row dataset that actually loads in under 3 seconds — I've solved it in production.

PythonSQLPower BI SnowflakeAWS LambdaDBT Power AutomateAzure SynapseClickHouse
35+
Enterprise reports migrated Cognos → Power BI
80%
Refresh time reduction on 700M-row dataset
1,500+
Daily active BI users served across 3 divisions
40%
Performance gain via DAX & VertiPaq tuning
Featured Projects

From Automation
to Hyper-Scale

Four projects spanning increasing complexity — from rapid low-code solutions to enterprise cloud architecture.

01
Industrial IoT · Cloud

iObeya Industrial Analytics & Real-Time KPI Platform

AWS LambdaSnowflakeDBTPower BIPythonREST API
The Challenge

Manufacturing teams had zero real-time visibility on T-Cards and QRCI quality workflows. Siloed data, manual aggregation, and stale dashboards were creating costly operational blind spots across the factory floor.

Solution
  • Serverless AWS Lambda extracts from iObeya REST APIs with retry logic & pagination
  • Snowflake EDW + DBT transformation layers — centralized, tested, production-grade
  • Power BI real-time dashboards: delay tracking, QRCI monitoring, resolution analysis
  • Automated orchestrators — zero manual refreshes, near-real-time sync
3
Pipelines built
0
Manual reports
Real-time
KPI visibility
02
Low-Code ETL · M365

Microsoft Planner Automation Pipeline

Power AutomateSQL ServerPower BIGraph APIDAX
Engineering Challenge

Extract 3,389 tasks from paginated Planner APIs (100-item cap per call), normalize deeply nested JSON, and build a relational SQL schema — all without traditional ETL tooling.

Solution
  • "Do Until" loops with @odata.nextLink — processed 3,389 tasks in 37 minutes
  • Star schema in SQL Server: Fact_Tasks + Dim_Plans, Buckets, Users, Dates
  • DAX time intelligence: Cette Semaine, En Retard, Semaine Prochaine
  • Delta-only incremental loads — 80% reduction in API consumption
3,389
Tasks extracted
37m
Full pipeline run
80%
API load cut
Enterprise Consulting

Senior-Level Engagements

Two flagship mandates proving execution at enterprise scale — migration strategy, RLS governance, and hyper-scale optimization.

AGC Glass Group
Senior Data Analyst · Oct 2021 – Present
35+
Reports
1,500+
Users
40%
Faster
  • 🔄Led migration of 35+ Cognos reports — Framework Manager to Power BI star schemas, zero downtime
  • 👥Served 1,500+ daily users across Manufacturing, Quality & Logistics
  • 🔒Designed hierarchical RLS security model — plant-level to executive org-wide views
  • 40%+ performance gains via VertiPaq tuning, cardinality optimization & advanced DAX
  • 🤖Power Apps integration for automated factory floor data capture
OracleSnowflakePython ETLPower BIDataflows Gen2Azure AD
Earthlink Telecom
BI Consultant · Freelance · Oct 2024 – Present
700M+
Rows
80%
Faster
<3s
Load Time
  • 📊Fixed critical failure on 700M+ row CDR dataset — refresh from 8–10 hours to under 90 minutes
  • Incremental Refresh partitioning — only 5–10M delta rows scanned daily
  • 🔍Rewrote DAX — dashboard load from 15–20s to sub-3 seconds
  • 🎓Delivered workshops on DAX & VertiPaq — built internal Centre of Excellence
  • 🏗️Written Azure Synapse vs. Power BI Premium architecture advisory
ClickHousePBI PremiumXMLATabular EditorComposite Models
Technical Proficiency

Skills Matrix

BI & Visualization5+ yrs · Expert
Power BIDAXTableauIBM Cognos
Low-Code / RPA4 yrs · Expert
Power AutomatePower AppsLogic Apps
Data Engineering4 yrs · Advanced
PythonSQLTalendSSISPySparkDBT
Cloud & Infrastructure3 yrs · Advanced
AWS LambdaSnowflakeAzure Synapse
Big Data Stack3 yrs · Proficient
SparkHiveClickHouseElasticsearch
Security & Governance4 yrs · Advanced
RLSRBACAzure ADGDPR

Capability Overview

BI & VisualizationPower BI · Cognos · Tableau
Low-Code / RPAPower Automate · Apps
Data EngineeringPython · SQL · Talend · DBT
Cloud & InfraAWS · Snowflake · Azure
Data ModelingStar Schema · Kimball · DBT
Big DataSpark · ClickHouse · Hive
Advisory & TrainingWorkshops · CoE · Architecture
🏆
IBM Big Data Developer
IBM Mastery Award
☁️
IBM IoT Cloud Developer
IBM Mastery Award
العربية
Native
Français
Fluent
English
Fluent
Academic Background

Education & Certifications

🎓
2018 – 2020 · Tetouan, Morocco
Master's in Big Data & Data Science
Université Abdelmalek Essaadi
📚
2015 – 2018 · El Jadida, Morocco
Bachelor's in Database Administration
Université Chouaib Doukkali
Work With Me

Ready to Build
Something Exceptional?

Open to data engineering mandates, BI consulting, and architecture advisory. Remote-first, available globally.

Currently available for new projects

Drop a Message 👋