AYOUB EL-OUICHOUANY

Analytics Engineer | Data Engineer

📍 Casablanca, Morocco 🇲🇦

I'm an Analytics Engineer / Data Engineer focused on building reliable data pipelines, analytics-ready data models, and BI solutions.

I work across the data lifecycle — from ingestion and transformation to dimensional modeling, orchestration, data quality, and analytics.

• 🏦 Analyzed 25M+ loan applications through an end-to-end analytics platform
• 🏗️ Built Bronze → Silver → Gold data architectures
• ⭐ Designed Star Schemas and analytics-ready fact/dimension models
• ⚙️ Orchestrated ETL/ELT workflows with Apache Airflow
• 🧪 Implemented data quality testing and validation with dbt
• 📊 Built business dashboards with Power BI & DAX

SQL Python dbt Apache Airflow ETL/ELT SQLAlchemy

Snowflake PostgreSQL Dimensional Modeling Star Schema Medallion Architecture

Power BI DAX Power Query Pandas NumPy Excel

Azure Data Factory Docker MinIO Git GitHub Actions

25M+ loan applications | Snowflake · dbt · Airflow · Power BI · Docker

Built an end-to-end analytics platform covering ingestion, transformation, dimensional modeling, orchestration, data quality, and BI.

• 2.26M accepted loan applications
• 23.23M rejected applications
• Snowflake Bronze / Silver / Gold architecture
• Star Schema with 2 fact tables + 9 dimensions
• Automated dbt data quality tests
• Airflow orchestration
• 5-page Power BI dashboard

Snowflake · dbt · Airflow · Power BI · Docker

Collaborated in a 4-person team to build a multi-country real estate data warehouse from 2,060 property listings.

• Medallion architecture
• Dimensional data modeling
• Automated dbt transformations and tests
• 5-task Airflow DAG
• 3-page Power BI dashboard

Python · Pandas · PostgreSQL · SQLAlchemy · Power BI

Built an analytics platform for 1,508 property listings across 10 Moroccan cities.

• Cleaned and retained 95.9% of source records
• Designed a Star Schema with 1 fact + 4 dimensions
• Created 7 analytical variables
• Built a 4-page Power BI dashboard

My focus is on reliable pipelines, clean data models, automated testing, and analytics-ready datasets.

CCFBS × Simplon Maghreb
Fquih Ben Salah | January 2026 – August 2026

Université Sultan Moulay Slimane
Béni Mellal | 2025 – Present

Lycée Technique El Khawarezmi
Souk Sebt Ouled Nemma | 2025

• Power BI Essential Training — LinkedIn Learning
• SQL Essential Training — LinkedIn Learning
• Intro to Snowflake for Developers, Data Scientists & Data Engineers — LinkedIn Learning
• Learning Docker — LinkedIn Learning
• Practical GitHub Actions — LinkedIn Learning
• AI Career Essentials — ALX Africa

• 🇲🇦 Arabic — Native
• 🇫🇷 French — Professional communication
• 🇬🇧 English — Professional communication

Open to opportunities in:

Analytics Engineering · Data Engineering · Data Analytics · Business Intelligence

Particularly interested in roles involving:

SQL · dbt · Data Modeling · ETL/ELT · Cloud Data Warehousing · Apache Airflow · Power BI