Open to opportunities

marwan Abdelhalim

@marwanabdelhalim

Senior Business Intelligence and Analytics Engineer specializing in cloud data warehousing, ETL/ELT, and executive dashboard delivery.

United Kingdom

Message

What I'm looking for

I’m looking to deliver end-to-end cloud BI and analytics platforms—dimensional modeling, reliable ETL/ELT, and executive dashboards—by partnering with senior stakeholders on KPIs, enforcing data quality automation, and enabling scalable self-service reporting.

Senior Business Intelligence / Analytics Engineer with 16+ years of experience designing and delivering cloud-based BI, data warehousing, and ETL/ELT solutions across AWS, Azure, and GCP. I build dimensional data models and executive dashboards (Power BI, Tableau, Amazon QuickSight) that enable KPI reporting and data-driven decision-making for global organisations including Amazon, Google, Oracle, and The Walt Disney Company.

I partner with senior stakeholders to define metrics and reporting standards, while improving data quality and performance in large-scale environments. From delivering end-to-end BI solutions at Amazon to building ELT pipelines into Snowflake and optimising Azure Synapse and Power BI refresh performance, I focus on automated validation, reliable reporting, and scalable self-service analytics.

Experience

Work history, roles, and key accomplishments

Senior Business Intelligence Engineer

Amazon

Oct 2025 - Mar 2026 (5 months)

Delivered an end-to-end BI solution for EU CF Operations using AWS, supporting leadership reporting across multiple EU markets. Designed and optimised ETL/ELT pipelines and automated data quality checks to improve dashboard reliability and reduce manual investigations.

AWS S3 AWS Glue AWS Lambda Amazon Redshift Amazon Quicksight SQL Python ETL KPI Design

BI / Data Engineer

Scripta Insights

Sep 2024 - Jul 2025 (10 months)

Built ELT pipelines moving data from AWS S3/Redshift into Snowflake using Python and AWS services. Extended Snowflake dimensional models with SCD Type 2 and developed Tableau dashboards with scheduled refresh and automated alerting.

AWS S3 Amazon Redshift Snowflake AWS Glue AWS Lambda AWS Fargate Python Dimensional Models Tableau

Business Intelligence Engineer

Spafax

Aug 2023 - Jun 2024 (10 months)

Designed and built analytical schemas in Azure Synapse Analytics to support reporting on migrated Cosmos DB data. Developed Power BI dashboards with DAX/Power Query and automated refresh via Power Automate, optimising SQL and data models to reduce refresh times.

Azure Synapse Azure Cosmos Power BI Power Query Power Automate SQL Data Modeling Performance Optimization Dashboards

Business Intelligence Engineer

Isometrix

Oct 2022 - Jun 2023 (8 months)

Migrated transactional data into Snowflake using Azure Data Factory and Snowpipe to enable centralised reporting and analytics. Supported enterprise Power BI dashboards, including dataset design, DAX measures, and row-level security (RLS), while improving self-service BI through requirements collaboration.

Snowflake Azure Data Factory Snowpipe Power BI DAX

Business Intelligence Consultant

The Walt Disney Company

Feb 2018 - Aug 2022 (4 years 6 months)

Designed and delivered Snowflake data warehouses and data marts for licensing analytics, integrating data from multiple internal and external sources. Managed ELT pipelines with Azure Data Factory and Snowpipe and built executive Power BI dashboards to support multiple business units and reduce manual reporting.

Snowflake Data Warehousing Azure Data Factory Snowpipe Power BI DAX Data Marts