Ishan Sarkar

Data Engineer

Bengaluru, Karnataka, India1 yr 11 mos experience

Most Likely To Switch

Key Highlights

Expert in designing scalable ETL pipelines.
Proven ability to optimize data processing and query performance.
Strong mentor for interns and non-technical teams.

Stackforce AI infers this person is a Data Engineering and Analytics professional in the EdTech sector.

Contact

Skills

Core Skills

Data EngineeringData AnalyticsData AnalysisBusiness Intelligence

Other Skills

ANOVAAWS DMSAWS GlueAWS LambdaAWS QuickSightAWS RDSAmazon QuickSightAmazon RedshiftAmazon Relational Database Service (RDS)Analytical SkillsAnalyticsApache SparkBitbucketBusiness Intelligence (BI)Business Metrics

About

I’m a data engineering and analytics professional who thrives on turning complex data into clear, actionable insights. Currently at BrightChamps (a global K-12 EdTech platform), I design scalable ETL pipelines, optimize queries, and build dashboards that help founders, business heads, and investors make informed decisions. Though my title is Data Engineer, my work lives at the intersection of engineering precision and analytical thinking. From building ETLs in AWS Glue and Python, to reducing query time with smart indexing, to monitoring AWS DMS tasks and debugging with CloudWatch — I enjoy making systems faster, more reliable, and more transparent. I began my journey as a Data Analyst, where I developed KPIs, built dashboards in QuickSight and Redash, and collaborated closely with sales and finance teams to reflect the true health of the business. Over time, I grew into engineering responsibilities while keeping a sharp focus on the “why” behind the data. I also mentor interns, help non-technical teams understand data problems in plain language, and continuously expand my skills — with a growing focus on machine learning, predictive modeling, and experimentation frameworks like A/B testing. I’m always open to connect with people who love data, whether you’re building pipelines, making business decisions, or just trying to understand the story your data tells.

Experience

1 yr 11 mos

Total Experience

1 yr 11 mos

Average Tenure

1 yr 11 mos

Current Experience

Brightchamps

2 roles

Data Engineer

Promoted

Apr 2025 – Present · 1 yr 2 mos · Bengaluru, Karnataka, India · On-site

Engineered and maintained ETL pipelines using AWS Glue and Python, transforming raw data into clean, structured formats for AWS RDS and downstream analytics platforms.
Designed executive dashboards in AWS QuickSight and Metabase for metrics such as cost per deal, burn rate, revenue recognition, and business target tracking.
Optimized long-running queries by modularizing logic and introducing indexes — reducing query time from 30–40 minutes to 5–7 minutes and lowering CPU usage from 90%+ (of AWS Redshift) to ~25% (of AWS RDS).
Oversaw AWS DMS (Database Migration Service) operations: created and monitored replication tasks, investigated failures using CloudWatch Logs, and ensured data sync stability.
Collaborated with developers to resolve data inconsistencies, and with business heads to define and validate meaningful KPIs.
Mentored interns on SQL performance tuning, dashboard logic, and business workflows.
Managed CI/CD processes via Bitbucket and Jenkins, with knowledge sharing through Confluence documentation.

AWS GluePythonAWS RDSAWS QuickSightMetabaseAWS DMS+6

Data Analyst

Jul 2024 – May 2025 · 10 mos · Bengaluru, Karnataka, India · On-site

Focused on financial data analysis and reporting for the Revenue and Payment Operations team, supporting key business functions like amount collection and payment processing.
Leveraged AWS RDS and Redshift (PostgreSQL engines) to manage and analyze transactional data.
Built SQL-based queries for insights into revenue patterns, payment trends, and operational efficiency using Redash and Metabase.
Designed and delivered interactive dashboards in AWS QuickSight, enabling stakeholders to monitor key metrics.
Analyzed payment data to identify gaps, inconsistencies, or missing entries, collaborating with business heads to validate whether the business logic was correctly implemented.
Partnered with data engineers, full-stack developers, and other tech teams to address discrepancies, ensuring accurate and reliable data pipelines.
Delivered reports in formats (CSV, Excel, query links, dashboards) tailored to specific business needs.
Key Project: Streamlining ETL Pipeline
Designed and implemented an end-to-end ETL pipeline using AWS Glue to optimize data processing.
Extracted data from RDS, transformed it using PySpark, SparkSQL, and PostgreSQL, and loaded it into S3.
Automated the final step using AWS Lambda to transfer cleaned data from S3 to RDS, improving data accessibility.
Addressed issues like data sanity, privacy, and inefficient query execution by ensuring clean, structured datasets.
Developed a control and user access framework to manage data access across the organization.
Achieved improved dashboard refresh rates and significantly reduced query failures.
Implemented ETL version control using Bitbucket, enabling seamless collaboration and tracking of changes across the team.
Documented the entire ETL workflow, including troubleshooting and best practices, on Confluence to ensure transparency and knowledge sharing.

AWS RDSRedshiftSQLRedashMetabaseAWS QuickSight+4

Kulturehire

Data Analyst Intern

Feb 2024 – Apr 2024 · 2 mos · Bengaluru, Karnataka, India · Remote

Collected Data by a Survey manually (Google Form)
Performed Data Cleaning and Data Standardization/Normalization (Power Query)
Created several hypothesis questions around the business and KPI and finalized the focus areas
Created several analysis reports and found insights to bring business impact using Excel, PowerBI and SQL
Designed and Published Dashboards for presenting the Insights (Excel & PowerBI)
Presented the findings and recommendations to the business stakeholders

Google FormsData CleaningPower QueryExcelPowerBISQL+1