Open to opportunities

Ankit Kalauni

@ankitkalauni

Message

BI engineer building trusted analytics layers for fintech and banking stakeholders.

India

Message

What I'm looking for

I want to build governed, reusable analytics—turning product and client questions into trusted datasets, strong metric definitions, and self-service dashboards that improve performance and decision-making, while partnering closely across risk, product, and engineering.

I’m a BI Engineer with 4+ years across SQL, dbt, Snowflake, and AWS Redshift, focused on building trusted analytics layers for fintech and banking stakeholders. I specialize in dimensional data modeling, ELT transformations, metric/KPI delivery, and self-service dashboards.

Currently, I own HDFC-scale UPI datamart analytics (50M+ daily transactions) and partner with product and client teams to turn business questions into governed, reusable reporting. I’ve built HDFC UPI datamart on AWS Redshift, developed dbt models and Airflow-orchestrated ELT from MSSQL, S3, and MongoDB into Snowflake and Redshift, and cut pipeline processing time by 40% while mentoring 2 junior engineers.

Experience

Work history, roles, and key accomplishments

Current

Business Intelligence Engineer

Current

Zeta

Jan 2025 - Present (1 year 6 months)

Built an HDFC UPI datamart on AWS Redshift handling 50M+ daily transactions for unified banking analytics. Developed dbt models and Airflow-orchestrated ELT from MSSQL, S3, and MongoDB into Snowflake/Redshift, cutting pipeline processing time by 40% and delivering 15+ Metabase/Superset dashboards.

AWS RedShift SQL DBT Airflow ELT MSSQL S3 MongoDB Snowflake Redshift Data Modeling Metabase Superset KPI Design Dashboarding Stakeholder Management

Data Analyst

Media.net

Jan 2022 - Jan 2025 (3 years)

Performed business analysis on advertiser datasets, contributing to a 40% lift in bidding win rate. Built automated reports and alerts with scheduled SQL jobs, and improved Spark query performance by 25% using partitioning and EDA with Pandas/NumPy.

SQL Business Analysis Spark Partitioning EDA Pandas NumPy