Mannheim, Germany · Open to opportunities

Darpen Bhandari

Data Engineer & Analytics Engineer

Building production data systems for analytics and AI.

Around five years across financial services and healthcare—designing pipelines, models, quality workflows and analytics systems with Python, SQL, PySpark, Azure, Databricks, Delta Lake, Snowflake, dbt and Power BI.

View Projects GitHub LinkedIn Contact ↓

DATA SYSTEM / 01LIVE DESIGN

API / SOURCE

INGEST

KAFKA / ADF

DATABRICKS

DELTA LAKE

SNOWFLAKE / dbt

ANALYTICS / AI

Reliable, observable flow01.072ms

01 / ABOUT

Systems thinking for data people can trust.

I build dependable paths from operational data to decisions. My work spans financial services and healthcare: ingesting data, shaping models, validating quality and serving teams through analytics. I’m most effective where engineering reliability and reporting needs meet—turning fragmented source systems into traceable datasets, useful KPIs and repeatable workflows.

Available for Data Engineering & Analytics Engineering roles

Mannheim, GermanyEnglish — C1German — B1, progressing toward B2

SourceREST / Kafka

→

IngestPython / ADF

→

TransformPySpark / dbt

→

ModelSQL / Delta

→

ServeSnowflake / Power BI

5⁺Years experience

22Enterprise applications

6Engineers led

40^%Manual reporting reduced

02 / EXPERIENCE

Reliable delivery across complex data environments.

12/2025 — 05/2026MOST RECENT

University Hospital Heidelberg UKHD

Student Assistant · Data & System Analytics

Built REST and Kafka integrations between qTest Manager and Matrix42, loading operational data into Snowflake with Python and FastAPI.
Created incremental dbt models with merge strategies, macros and freshness tests for recurring reporting and monitoring.
Built Power BI/DAX reporting for SLA compliance, ticket volume and resolution time; established eight core KPI definitions.
Reduced manual reporting by about 40% and data discrepancies by about 20% through reconciliation, structured logging and alerts.

PythonKafkaSnowflakedbtPower BIAzure DevOps

04/2021 — 10/2023FINANCIAL SERVICES

Hexaware Technologies

Senior Software Engineer · Data Analytics

Delivered data engineering across 22 trading, portfolio and compliance applications, leading a team of six engineers.
Built Azure Data Factory and Databricks pipelines with ADLS Gen2, Delta Lake and Snowflake.
Migrated Bronze / Silver / Gold data products from Parquet to Delta Lake using PySpark.
Standardised infrastructure and deployments with Terraform and Azure DevOps CI/CD; automated recurring reporting workflows.

ADFDatabricksPySparkDelta LakeKafkaTerraform

03/2019 — 04/2021FINANCIAL SERVICES

Hexaware Technologies

Software Engineer · Data Analytics

Built Python, SQL and PySpark transformation workflows with incremental loading and failure handling.
Worked with Azure Data Factory, Kafka, ADLS Gen2, Snowflake and Azure SQL to support analytics datasets.
Implemented automated data quality checks and supplied Power BI and Tableau reporting outputs.

PythonSQLAzure SQLADLS Gen2KafkaTableau

03 / SELECTED WORK

Engineering-first portfolio work.

All projects ↗

01FEATURED CASE STUDY

DATA ENGINEERING / ANALYTICS

Service Operations Data Platform

A local-first data platform for analysing IT incidents and service requests without using confidential employer data.

Problem

Make service operations answers reproducible across ticket volume, backlog, SLA performance and resolution time.

Architecture

Python → Raw Storage → PostgreSQL → dbt → Analytics Marts → Power BI

Engineering practices

Synthetic data, recoverable ELT, quality checks, dbt, CI and safe Terraform modules.

PythonPostgreSQLdbtDockerGitHub ActionsTerraform

View repository

DATA ENGINEERING

DB Train Delay & Route Reliability

API ingestion, layered processing and dbt models for German rail reliability metrics.

API → Raw → Bronze → Silver → Gold → dbt

PythonPySparkdbtStreamlit

GitHub ↗

AI / ML

CV Optimizer

A local Streamlit tool that uses Ollama to tailor CV summaries and skills to a job description.

PythonStreamlitOllamaPDF

GitHub ↗

ANALYTICS / ML

Electricity & Renewable Energy Insights

A forecasting and visualisation solution for electricity load, renewable data and model performance.

PythonPostgreSQLStreamlitXGBoost

GitHub ↗

04 / TECHNICAL ECOSYSTEM

Tools for dependable data products.

Data engineering

PythonSQLPySparkETL / ELTdbtAirflowKafkaAvroData ModellingData Quality

Cloud & platform

Microsoft AzureADFADLS Gen2DatabricksDelta LakeSnowflakeAzure SQL

DevOps & delivery

GitGitHub ActionsAzure DevOpsDockerTerraformCI/CDMonitoring

Analytics

Power BIDAXPower QueryTableauKPI DesignReconciliation

05 / CONTACT

Let’s build reliable data systems.

Have a Data Engineering or Analytics Engineering opportunity? I’d be glad to hear from you.

darpen.bhandari@gmail.com

Mannheim, Germany