Data Pipelines
REST API ingestion, ETL/ELT workflows, Azure data layers and reliable reporting datasets.
Data Engineering
Analytics Engineering
BI Reporting
Azure & dbt Pipelines
Darpen Bhandari
Data Engineer and Analytics Engineer with strong BI reporting experience
Data Engineer and Analytics Engineer with 5 years of experience building reliable data pipelines, reporting layers and BI dashboards across healthcare IT and financial services. I work with Python, SQL, Azure, dbt, Databricks, PySpark, Power BI and DAX to turn operational data into clean datasets, KPIs and business-ready insights.
// STATUS
Germany & EU roles
Mannheim, Germany. Open to Data Engineering, Analytics Engineering and BI reporting roles.
// WHAT I BUILD
What I Build
Analytics Engineering
dbt models, reporting marts, data quality checks, KPI logic and validated business-ready datasets.
BI Dashboards
Power BI, DAX, Power Query, SQL analysis and stakeholder-facing KPI dashboards.
// EXPERIENCE
Experience
Healthcare IT Analytics
Working Student - Data and System Analytics
Universitätsklinikum Heidelberg | 12/2025 - 05/2026
- Built Python REST API ingestion pipelines between qTest and Matrix42 for incident, service request and test execution data.
- Designed ADF pipelines with parameterized triggers and incremental loads into ADLS for scheduled SLA breach monitoring.
- Created dbt staging and mart models with SQL checks, schema tests and GitHub Actions quality gates before release.
- Mapped qTest and Matrix42 source data into Power BI-ready reporting datasets, improving weekly reporting and SLA monitoring reliability.
- Defined KPI logic, validated source data and reduced manual reporting effort by combining SQL, Python, dbt and Power BI reporting layers.
Financial Services Reporting
Senior Software Engineer
Hexaware Technologies Pvt Ltd. | 03/2019 - 10/2023
- Led delivery across 22 US financial portfolio applications covering AUM, performance tracking, reconciliation analysis and SLA reporting.
- Built Azure pipeline and reporting workflows with ADF incremental loads, failure alerting, retries and DevOps monitoring.
- Automated Excel-based reporting refreshes using SQL, Python, Power Query and structured reporting layers feeding Power BI outputs.
- Worked with ADLS medallion patterns, Parquet datasets, Databricks/PySpark concepts, dbt modelling and CI/CD release checks.
- Maintained 100% SLA compliance and reduced month-end reconciliation/reporting effort through ETL/ELT automation.
// PROJECTS
Featured Projects
Data Engineering / Analytics Engineering
DB Train Delay and Route Reliability Pipeline
Built German rail route reliability metrics with API ingestion, bronze/silver/gold layers, dbt models and a Streamlit dashboard.
Data Engineering / Analytics Engineering
Smart Energy Forecasting Pipeline
Built forecasting-ready datasets for electricity, solar, weather and cost data to support energy optimization decisions.
BI Analyst / Healthcare Data Analyst
Stroke Risk Analytics Dashboard
Built Power BI views for 5,110 patient records across age, BMI, glucose, hypertension and smoking status.
Data Analyst / BI Analyst
Electricity and Renewable Energy Insights Dashboard
Created dashboard views for actual vs predicted load, renewable contribution, forecast error and model performance.
// CORE SKILLS
Core Skills
Data Engineering
- Python, SQL, REST APIs
- Azure Data Factory, Azure Data Lake, Azure SQL
- ETL/ELT, incremental loads, medallion architecture
- Databricks, PySpark, Delta Lake, Parquet
- Snowflake, Kafka, Airflow, Docker
Analytics Engineering
- dbt staging and mart models
- Star schema, facts and dimensions
- Reporting marts and KPI logic
- Data quality checks and validation
- GitHub Actions CI/CD quality gates
BI & Analytics
- Power BI, DAX, Power Query
- Tableau, Excel, KPI dashboards
- AUM reporting, SLA reporting
- Reconciliation analysis
- Ad hoc analysis and stakeholder reporting
Domains
- Healthcare IT analytics
- Finance and portfolio reporting
Soft Skills
- Stakeholder communication
- Business requirement analysis
- Problem solving
- Ownership and delivery focus
- Team leadership and coordination
Languages
- English: C1 professional working proficiency
- German: B1, actively improving toward B2
- Hindi: native / fluent