Manthan Vyas

Data Engineer with 2 years of experience building and maintaining ETL/ELT pipelines and cloud-based data solutions for financial analytics and retail reporting platforms. Hands-on with Python, SQL, Snowflake, and AWS (S3, Glue, Lambda) for data ingestion, transformation, and warehousing across multi-source, production environments. Skilled in data quality validation, workflow automation, and query performance tuning, with added experience coordinating client requirements and task delivery for a financial analytics platform used by analytics and budget-holder teams.

Data Engineer - Intelyhood Technologies

(2025-06)

Opex360 Platform

• Build and maintain production ETL pipelines on the Opex360 financial analytics platform, processing operational and financial data consumed by financial analytics and budget-holder teams for reporting.
• Optimize complex SQL queries and data transformations on financial datasets, reducing report generation time by ~25%.
• Automate workflow scheduling and dependency management using Redwood RunMyJobs, improving reliability of batch processing across multi-stage pipelines.
• Perform data validation and quality checks on ingested datasets to maintain accuracy and consistency in downstream financial reports.
• Integrate data from multiple source systems (databases and flat files) into a centralized platform, implementing retry logic and structured logging to handle pipeline failures.
• Own assigned modules of the Opex360 platform end-to-end — coordinating with team members, assigning and tracking tasks, and translating business requirements from client and budget-holder stakeholders into technical implementation.

Data Engineer - FreewayWeb IT Solution

(2024-05 - 2025-05)

• Designed and developed Python-based ETL pipelines to ingest and transform structured data from 5+ sources, reducing manual data handling by ~40%.
• Built cloud data pipelines on AWS using S3, Glue, and Lambda to support scalable batch and near-real-time data processing workflows.
• Wrote and optimized SQL queries in Snowflake and MySQL for extraction, transformation, and validation, improving average query execution time by 30% through indexing and query restructuring.
• Implemented SQL transformations to compute retail KPIs — total sales, product performance, and regional trends — enabling accurate, timely business reporting.
• Designed Snowflake tables with schema and partitioning strategies, improving storage efficiency and query performance on large datasets.
• Built an automated data quality framework in Python (null checks, range validation, referential integrity checks), reducing bad data reaching downstream reports by ~60%.

B.Tech - Computer Science & Engineering - Shri Vaishnav Vidyapeeth Vishwavidyalaya (2020 - 2024)