Open to opportunities

abdellah azzal

@abdellahazzal

Message

Data engineer and analyst with expertise in ETL and data visualization.

Morocco

Message

What I'm looking for

I seek a collaborative environment that fosters innovation and growth in data analytics.

I am a dedicated data engineer and analyst with a strong background in data management and business intelligence. With an engineering degree in E-Management and Business Intelligence from Rabat National School of Computer Science, I have honed my skills in designing and managing data architectures, particularly using Snowflake and Power BI. My experience includes developing ETL/ELT pipelines, optimizing SQL queries, and implementing security controls to ensure data integrity and accessibility.

Throughout my career, I have successfully contributed to various projects, including the launch of Power BI report optimizations and the development of complex SQL queries for analytical reporting. My role at Bouygues Construction IT has allowed me to automate data processes using Python and Apache Airflow, while also monitoring performance issues to enhance operational efficiency. I am passionate about leveraging data to drive insights and support decision-making processes.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Bouygues Construction

Jan 2024 - Present (1 year 4 months)

Currently working as a Data Analyst, responsible for designing and managing Snowflake schemas, developing ETL/ELT pipelines, optimizing queries, and implementing security controls. Additionally, I automate data processes using Python and Apache Airflow, and monitor Snowflake resources.

Snowflake ETL SQL Python Apache Airflow Data Modeling Power BI Git Data Warehousing Performance Tuning

Data Consultant

Groupe Label'Vie

Jan 2022 - Dec 2023 (1 year 11 months)

Worked as a Data Consultant, setting up ETL pipelines to load data into Snowflake and implementing role-based access control mechanisms. Developed Power BI reports and dashboards, ensuring optimized access for stakeholders.

ETL Snowflake Power BI SQL Python Data Modeling RBAC Data Warehousing Data Analysis Cloud Technologies

EPM/BI Consultant

Viseo - Louis Vuitton

Sep 2020 - Dec 2021 (1 year 3 months)

Served as an EPM/BI Consultant, focusing on ticket processing within the Data Factory and maintaining Power BI reports. Created stored procedures in SQL Server and set up reports in Power BI.

Power BI SQL Server Data Factory Data Visualization Reporting Data Management

Education

Degrees, certifications, and relevant coursework

Rabat National School of Computer Science and Systems Analysis

Engineering Degree, E-Management and Business Intelligence

2016 - 2020

Pursued an Engineering Degree in E-Management and Business Intelligence, focusing on integrating technology with business strategies and data management.

Faculty of Sciences Ben M’sik - Hassan II University

General University Studies Diploma, Applied Mathematics and Computer Science

2014 - 2016

Completed a General University Studies Diploma (DEUG) in Applied Mathematics and Computer Science, emphasizing mathematical principles and computational techniques.