Skip to content

What I work on

Expertise

The four areas I spend most of my time in.

  • Cloud Data Warehousing & Lakehouses

    Designing and building modern cloud data platforms with a focus on Microsoft Fabric (Lakehouse, Delta Tables, Data Warehouse, PySpark notebooks, Semantic Link / sempy), Azure SQL Databases and embedded OLAP with DuckDB.

    • Microsoft Fabric
    • Delta Tables
    • Azure SQL
    • DuckDB

  • Data Engineering & Pipeline Orchestration

    Developing robust, version-controlled ETL/ELT pipelines with Python (Pandas, PySpark), dbt (staging, core and analytics layers) and Azure Data Factory, orchestrated with Apache Airflow and Prefect.

    • Python
    • dbt
    • Azure Data Factory
    • Airflow
    • Prefect

  • Database Engineering & SQL Performance Tuning

    In-depth optimization of complex SQL workloads (CTEs, window functions, execution plan analysis, non-clustered/clustered indexing), schema migrations (Alembic) and administration in PostgreSQL and T-SQL.

    • PostgreSQL
    • T-SQL
    • Indexing
    • Execution Plans
    • Alembic

  • Enterprise Integration, APIs & BI Reporting

    Connecting complex source systems such as SAP (SAP MM, SAP HCM, S/4HANA Finance tables like ACDOCA/ACDOCP, PA0007), REST APIs and web scraping architectures, through to visualization in Metabase, Power BI and advanced financial and data models.

    • SAP S/4HANA
    • REST APIs
    • Web Scraping
    • Power BI
    • Metabase