Sumit Kashyap

About Sumit Kashyap

I am a Senior Data Engineer with 7+ years of experience in Business Intelligence, Data Engineering, and Automation. My expertise lies in database management, ETL development, data transformation, reporting solutions, and cloud technologies.Over the years, I have worked extensively with AWS (Redshift, S3, Glue), Databricks, Snowflake, Power BI, SQL, and Python, helping organizations build scalable data solutions and optimize business processes. My experience spans designing complex data pipelines, automating workflows, and developing interactive dashboards to turn raw data into actionable insights.Currently, at E2 Consulting Engineers, Inc, I lead data automation initiatives, manage data pipelines, and develop BI solutions that support critical business decisions. I also mentor junior engineers and collaborate with cross-functional teams to improve data accuracy, governance, and system efficiency.I am AWS and Microsoft Power Platform certified, always looking for ways to enhance data-driven decision-making through automation, AI, and analytics.I enjoy solving complex data challenges and creating solutions that drive efficiency and impact. Let’s connect and talk about data engineering, automation, or BI strategies!

Experience

1. Senior Data Engineer

   E2 Consulting Engineers, Inc.

   Nov 2024 — Present

   Management & Technical Development- Lead technical calls on data initiatives, automation, and system enhancements- Gather business and technical requirements, defining development roadmaps and tracking progress- Develop and execute project implementation plans, identifying necessary tools, timelines, and resources- Collaborate with managers, engineers, and stakeholders to acquire essential data, system access, and process insights- Document data architecture, ETL logic, transformation methods, and dashboard development to ensure transparency and scalability- Mentor other engineers and analysts on best practices, troubleshooting, and performance optimization.• Technology & Systems ManagementAmazon Redshift – Co-Administrator & Technical Developer- Manage user access control for internal and external stakeholders- Maintain and enhance SQL scripts, ensuring data integrity across 30+ external data sources and 20-30 tables- Create custom scripts for QA and auditing, delivering accurate data to managers.Smartsheet – Admin & Data Integration Specialist- Oversee access management and permissions for stakeholders- Design and implement custom ETL workflows to integrate external data sources- Develop complex Smartsheet solutions with advanced logic and calculations.Power BI – Admin & Dashboard Architect- Manage user access and permissions for internal and external teams- Oversee and maintain 20+ dashboards, ensuring optimal performance and business relevance- Develop new interactive dashboards integrating SharePoint, Smartsheet, Redshift, and email data sources.• ETL Development & Data Automation- Design, develop, and maintain end-to-end ETL pipelines using Python, SQL, and Power Automate- Implement automation solutions to reduce manual workload and improve operational efficiency- Build automated data movement workflows, such as email-to-SharePoint-to-Smartsheet pipelines, for seamless data integration.

Education

• Maharaja Surajmal Institute Of Technology

  Bachelor's Degree

  2012 — 2016

• Northeastern University

  Master's degree

  2017 — 2019