Akshit Gangwar

Data Engineer with 3+ years of experience designing and orchestrating scalable ETL/ELT pipelines on Azure and AWS, with hands-on expertise in PySpark, SQL, Delta Lake, and Lakehouse Architecture. Proficient in Star Schema and dimensional modeling, data quality enforcement, and deploying analytics solutions on Databricks, Synapse, Redshift, and Snowflake. Experienced in delivering enterprise Power BI and Tableau dashboards, while collaborating cross-functionally with product, business, and engineering teams.

Data Engineer at MAQ Software (2025-09 – Present)

Engineered end-to-end ELT pipelines and designed scalable data models on cloud platforms

• Engineered end-to-end ELT pipelines in Azure Data Factory (ADF) to orchestrate Databricks notebooks for high-volume ingestion, transformation, and scheduled BI model refreshes.
• Designed Star Schema and dimensional data models on Delta Lake and Azure Synapse Analytics for multi-terabyte analytical workloads, establishing a single source of truth for downstream reporting.
• Reduced PySpark job execution time by 30% via code restructuring, cluster tuning, and parallelization, directly improving daily pipeline SLA adherence.
• Refactored and validated 30+ production PySpark notebooks with data quality checks during migration to a secure, Git-versioned, governance-aligned framework using Azure DevOps CI/CD.
• Enforced RBAC, PII encryption, and compliance-driven data protections, achieving 100% adherence to organizational security policies and audit requirements.

Data Analyst at LUMIQ (Crisp Analytics) (2023-01 – 2025-09)

Built enterprise Power BI dashboards and optimized ETL pipelines for multi-source data analysis

• Built and deployed enterprise Power BI dashboards with advanced DAX (MoM, YTD, variance) for 500+ users, reducing ad-hoc reporting load and accelerating decision cycles by 40%.
• Developed and optimized ETL pipelines using Python, PySpark, and AWS Glue, reducing report refresh time from 2 hours to 15 minutes through scheduled workflow automation.
• Performed multi-source SQL analysis on Redshift and Athena to standardize KPI definitions across business units, improving forecasting accuracy by 18%.
• Presented data storytelling dashboards to C-suite leadership, driving organization-wide adoption of data-driven decision frameworks and influencing quarterly planning.

Bachelor of Technology in Information Technology – IIIT Bhubaneswar (2019-07 – 2023-06)