SC

Open to opportunities

Swarupa Chavan

@swarupachavan

Data engineer specializing in AWS ETL/ELT pipelines and analytics-ready data platforms.

What I'm looking for

I’m looking for a role where I can build scalable AWS-based ETL/ELT pipelines, strengthen data lake/warehouse architectures, and deliver reliable analytics with BI dashboards. I want ownership, measurable impact, and room to grow.

I’m a Data Engineer with 3+ years of experience designing, building, and optimizing scalable data pipelines and ETL/ELT workflows. I focus on turning raw data into reliable, analytics-ready datasets that teams can trust for decision-making.

At Smart Software Services Pvt Ltd., I designed and developed scalable ETL pipelines using Python and Apache Spark, enabling efficient ingestion and transformation of 10M+ records daily. I built and maintained AWS S3-based data lake architecture, developed complex Redshift SQL for analytics reporting, and automated workflows with AWS Lambda and CloudWatch to reduce manual effort and processing time.

I also bring practical big-data engineering experience with Apache Hadoop (HDFS, MapReduce) and strong data quality discipline through profiling, cleansing, and validation. I collaborate on data modeling and schema design, integrate third-party APIs and sources into unified analytics, and create interactive Power BI dashboards to reduce weekly manual reporting.

Experience

Work history, roles, and key accomplishments

SL

Current

Data Engineer

Current

Smart Software Services Pvt Ltd

Jun 2025 - Present (1 year)

Designed and developed scalable ETL pipelines with Python and Apache Spark, enabling ingestion and transformation of 10M+ records daily. Built AWS data lake architecture and optimized analytics in Amazon Redshift, improving storage costs by 20% and query performance by 35%, while automating workflows to cut processing time by 40% and reducing weekly manual reporting by 10 hours via Power BI dashbo

Python Apache Spark AWS S3 Amazon Redshift AWS Glue AWS Lambda AWS Cloudwatch SQL Power BI

AL

Market Research Analyst

Ameliorate Digital Consultancy Pvt Ltd

Aug 2021 - Mar 2025 (3 years 7 months)

Conducted quantitative and qualitative market research, analyzing market trends and synthesizing actionable insights for stakeholders. Trained MSc interns, managed quality control processes, and supported technical data analysis work using Python, MySQL, advanced Excel, Jupyter Notebook, and Power BI (DAX).

Market Research Quantitative Analysis Qualitative Research Data Analysis Python MySQL Advanced Excel Jupyter Notebooks Power BI

Education

Degrees, certifications, and relevant coursework

MC

MES Aabasaheb Garware College

Master of Science (MSc) in Computer Science, Computer Science

Completed an MSc in Computer Science at MES Aabasaheb Garware College in 2019.

Tech stack

Software and tools used professionally

Amazon Redshift

Apache Spark

AWS Glue

GitHub

Jupyter

NumPy

Pandas

PySpark

MySQL

PostgreSQL

Hadoop

Gmail

AWS Lambda

Airflow

Time Analytics

s3-lambda

Amazon Web Services (AWS)

SQL

Google Colab

Interested in hiring Swarupa?

You can contact Swarupa and 90k+ other talented remote workers on Himalayas.

Message Swarupa

People also viewed

View all talent

Find your dream job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!