Jelili Alao

Highly accomplished Senior Data Engineer and Microsoft-certified Fabric Analytics Engineer with over 15 years of experience delivering enterprise-scale data engineering, business intelligence, analytics, and data warehouse transformation programmes across NHS Trusts, national healthcare organisations, consulting firms, and commercial enterprises. Combining extensive NHS domain expertise with a proven consulting background, I have successfully led and contributed to complex data modernisation initiatives, helping organisations transform legacy reporting environments into scalable, cloud-based analytics platforms. I have extensive experience working with clinical, operational, workforce, performance, and financial datasets, enabling organisations to make informed decisions through trusted, high-quality information solutions.

Specialising in Microsoft Fabric, Azure Data Engineering, and modern Lakehouse architectures, I design and implement enterprise data platforms using Microsoft Fabric Lakehouse, Data Factory, PySpark, SQL, Delta Lake, and Power BI Direct Lake semantic models. I have a strong track record delivering Medallion architectures (Bronze, Silver, Gold), dimensional models, semantic reporting layers, and robust ETL/ELT frameworks aligned to enterprise governance standards. Throughout my career, I have worked both as an NHS data professional and as a consultant within organisations including IBM, Capgemini, and other leading delivery partners, providing strategic and technical leadership across multidisciplinary teams.

I am experienced in engaging with senior stakeholders, clinical leaders, operational managers, architects, and executive teams to translate business requirements into practical, scalable analytics solutions. I bring extensive experience in NHS Information Governance, GDPR compliance, Agile delivery methodologies, DevOps practices, technical leadership, mentoring, and engineering governance. More recently, I have adopted AI-assisted engineering practices, leveraging tools such as Microsoft Fabric Skills, GitHub Copilot, Claude AI, and Model Context Protocol (MCP) workflows to improve productivity, accelerate development cycles, enhance documentation quality, and support innovation across Microsoft Fabric and Azure data platforms.

Senior Data Engineer – Microsoft Fabric Data Platform Migration - South East Coast Ambulance Service NHS Foundation Trust (SECAmb)

(2026-03)

Leading the enterprise‑wide Microsoft Fabric migration programme, modernising legacy SQL Server, SSIS, SSAS and on‑prem reporting estates into a governed, cloud‑native analytics platform supporting mission‑critical ambulance operations.

• Architecting full Medallion (Bronze–Silver–Gold) Lakehouse models using Fabric Lakehouse, Data Factory, Delta Lake, PySpark, Shortcuts, and Mirroring, including event‑based modelling, normalisation, and reusable ingestion/processing frameworks.
• Designing enterprise‑grade dimensional and semantic models, including conformed dimensions, surrogate‑key frameworks, SCD Type 1/2 patterns, Direct Lake‑optimised datasets, and TMDL‑driven semantic layer governance.
• Implementing Delta Lake optimisation strategies (partitioning, Z‑Order, V‑Order, MERGE optimisation, schema evolution) to support high‑volume CAD, call‑handling, and operational datasets.
• Establishing Fabric governance, security, and workspace architecture, including RBAC, OneLake permissions, naming conventions, folder structures, data contracts, sensitivity labels, and capacity planning.
• Building CI/CD and DevOps automation using GitHub, Git‑enabled Fabric workspaces, and Deployment Pipelines to enforce version control, automated testing, and repeatable environment promotion.
• Developing reusable engineering assets — PySpark notebooks, ingestion templates, validation frameworks, DQ rules, mapping specifications, and documentation packs for team enablement.
• Driving AI‑assisted engineering adoption, using Github Copilot, Microsoft Fabric Skills to accelerate SQL/PySpark generation, documentation, modelling, and pipeline design, improving delivery velocity and consistency.
• Delivering end‑to‑end migration lifecycle including requirements gathering, discovery, source‑to‑target mapping, architecture design, implementation, validation, optimisation, and operational monitoring.
• Supporting Agile delivery through sprint planning, backlog refinement, stakeholder workshops, peer reviews, and iterative releases aligned with operational and BI teams.

Senior Data Engineer – Clinical Narrative & Data Platform Modernisation - University Hospitals Bristol NHS Foundation Trust

(2025-11 - 2026-03)

Technical lead within a clinical data digitisation and narrative analytics programme.

• Designed and optimised SQL-based ELT pipelines supporting clinical and operational reporting.
• Transformed complex JSON clinical datasets into structured analytical models.
• Developed automated procedures and curated views supporting Power BI and SSRS reporting.
• Supported ECDS v4 testing, validation, and compliance activities.
• Collaborated with analysts and stakeholders to align technical solutions with reporting requirements.

Data Engineer – Azure / SQL / Power BI Data Warehouse Migration - Buckinghamshire NHS Trust / NHS Professionals

(2024-11 - 2025-10)

• Delivered large-scale Azure Data Warehouse migration initiatives supporting enterprise healthcare reporting.
• Migrated and integrated data from Careflow, RiO, Radiology, Pathology, BadgerNet, and other clinical systems.
• Developed maternity metrics data models and enterprise reporting datasets.
• Designed interactive Power BI dashboards for clinical, operational, and executive audiences.
• Supported Tendable API integrations and reporting automation initiatives.

Data Analytics Consultant – Microsoft Azure Analytics - IBM – NHS App Programme

(2023-11 - 2024-02)

• Developed operational Power BI dashboards supporting NHS App performance reporting.
• Designed Azure Data Factory pipelines for ingestion and transformation of operational datasets.
• Managed Postgres-based analytical environments supporting reporting requirements.
• Worked across Azure Synapse, Azure Data Lake Gen2, Azure Data Factory, and Power BI technologies.

Data Analytics Consultant – Azure & Power BI - VolkerWessels Ltd

(2022-11 - 2023-05)

• Delivered enterprise Power BI dashboards and analytics solutions supporting operational performance.
• Developed Azure Synapse and Azure Data Factory ingestion pipelines.
• Implemented Row-Level Security, DAX measures, and paginated reporting solutions.
• Engaged with stakeholders to translate requirements into scalable reporting solutions.

Data Engineer – Analytics & Data Platforms - ROO BP

(2021-09 - 2022-07)

• Delivered Azure and SQL-based data engineering solutions supporting finance transformation initiatives.
• Designed ETL pipelines supporting anomaly detection and machine learning use cases.
• Developed Power BI dashboards and enhanced existing reporting capabilities.
• Supported data governance and engineering best practices.

Data Engineer – Azure Analytics & Reporting - Capgemini

(2021-03 - 2021-07)

• Developed Azure Synapse and Azure Data Factory pipelines supporting strategic government reporting.
• Delivered Power BI dashboards and KPI reporting aligned to stakeholder requirements.
• Contributed to the design and implementation of scalable cloud analytics solutions.

Data Warehouse Developer – NHS England - Arden & GEM / NHS England

(2021-01 - 2021-03)

• Developed healthcare data warehouse solutions using Star Schema methodologies and SSAS multidimensional models.
• Integrated national datasets using SQL Server, Azure Data Factory, Tableau, Power BI, and ERWIN.
• Produced technical documentation supporting national reporting initiatives.

Data Engineer – Power BI & Azure Reporting - WHISHWORKS

(2020-10 - 2020-11)

• Designed and delivered end-to-end Azure reporting solutions.
• Migrated Postgres data into Azure SQL environments using Azure Data Factory.
• Developed Power BI semantic models and Dynamic Row-Level Security frameworks.
• Implemented CI/CD deployment pipelines and governance standards.

Data Engineer / Reporting Developer – Azure BI & MI Solutions - Freshfields Bruckhaus Deringer

(2018-03 - 2020-04)

Delivered enterprise reporting and analytics solutions using Azure SQL, Azure Data Factory, Azure Data Lake, Power BI.

MSc - Information Systems & Data Warehousing