Top Talent like Kshitij are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

Kshitij Gupta

Data Engineer
New York, NY, US
Available for hire fromNegotiable
Contracts
Data Engineer | Technology Management Expert
With a robust educational background in Technology Management from Columbia University and a Bachelor's in Electronics and Communications Engineering from Manipal University Jaipur, this professional has cultivated a diverse skill set in data engineering and project management. Currently pursuing a Master of Science at Columbia Business School, they have gained valuable experience through roles at IQVIA, Mastercard, INSIA, Celebal Technologies, and Darwinbox. Notably, they have led the development of transactional ETL pipelines, automated data processes, and executed cloud-based data solutions, significantly enhancing operational efficiency and data-driven decision-making. Their expertise extends to designing data storage architectures, performing complex data analyses, and developing social media analytics pipelines. With a proven track record of increasing sales and improving forecast accuracy, they have also contributed to product training and cross-functional collaboration, demonstrating a commitment to innovation and excellence in the technology sector.

Work History

I

Project Management Intern, Data Strategy

IQVIAJun 2024 - Aug 2024 • 3 mos- Executed cloud-based data solutions for IQVIA healthcare data, designing data storage architectures to improve processing speeds by 2x. - Collaborated across teams to deliver data-driven recommendations using an internal BI tool, to generate key data reports. - Analyzed add-spend data from 2016 to 2024 for pharmaceutical drugs to deliver comprehensive data insights for go-to-market strategies. - Performed asset archetyping to segment products, resulting in an improvement of drug classification for internal data repository.
M

Data Engineer

MastercardJun 2022 - Oct 2023 • 1 yr 5 mos- Led development of 20+ transactional ETL pipelines, for Mastercard Test & Learn product, by building robust relational database models, shell scripting, and SQL programming. - Performed data analysis on 100+ GB of data, to find critical patterns in consumer buying trends, increasing sales by 35%. - Conducted data extraction on datasets exceeding 10 million records using SQL and Python, creating robust statistical models that improved forecast accuracy by 20%. - Orchestrated product training sessions for new hires and interns. Led and mentored interns, imparting knowledge on ETL processes, SQL coding practices, data architecture, and product lifecycle. - Cross-functioned with product managers, consultants, software engineers, and senior leadership, to align 100% of data delivery work.
I

Product Data Engineer

INSIASep 2020 - Jun 2022 • 1 yr 10 mos- Automated data pipeline to reduce 4-hour manual process to 5-minute automated process using Python and SQL programming. - Designed and programmed over 40 end-to-end ETL pipelines and BAU processes on the platform to reduce manual data processes by 99%. - Scripted SQL queries on ClickHouse and MySQL databases to build 350+ business-specific KPIs. - Developed Social media analytics pipeline for Facebook, Instagram, LinkedIn, and Google Ads, by processing over 1M+ data points, automated the transformation of complex JSON into structured tables using Python. - Managed platform operations for 4 partner clients, organized post-production training sessions, and resolved 50+ issue tickets. - Created 30+ video tutorials encompassing the entire analytics product from Data setup, KPI configuration, Role Based Access Control, Search driven analytics, and product functionality to help increase the adoption rate by 80%. - Collaborated with other engineers, product managers, and designers to identify and platform bugs, to successfully scale automation.
C

Data Engineer Intern

Celebal TechnologiesSep 2020 - Feb 2021 • 6 mos- Performed data analysis and built key dashboards to highlight crucial business insights using Power BI, resulting in 10% increase in revenue. - Analyzed multiple datasets, built metrics and KPIs using DAX code to accurately calculate sales, cycle time, etc. - Scripted SQL queries to automate and increase data processing speed by 1.5x.
D

Product Analyst Intern

DarwinboxJan 2020 - Aug 2020 • 8 mosDarwinbox is a leading provider of cloud-based Human Resources Management Software (HRMS). - Performed stack ranking analysis, survey analysis, and product bug trends analysis to improve platform efficiency by 15%. - Created 20+ wireframes and Implemented logical design flow for new features and modules. Resulting in saving 3-4 minutes per user. - Designed auto-regressive moving average model prototype, with 80% accuracy using time series analysis for predictive analysis. - Cross functioned with deployment & developer teams to carry out statistical analysis.

Education

C

Columbia University

Master of Science - MS, Technology Management2023 - 2024
C

Columbia Business School

Master of Science - MS, Technology Management2023 - 2024
M

Manipal University Jaipur

Bachelor of Technology - BTech, Electronics and Communications Engineering2016 - 2020
T

The Hyderabad Public School, Begumpet

High School, ICSE

How Pangea Works

Effortlessly discover top talent

We've distilled the candidate search from endless hours down to just a few minutes. Using Pangea's AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company's niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea's fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team's capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We've combined every part of the hiring process into one platform to eliminate the miscommunication that's unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call
Data Engineer | Technology Management Expert
With a robust educational background in Technology Management from Columbia University and a Bachelor's in Electronics and Communications Engineering from Manipal University Jaipur, this professional has cultivated a diverse skill set in data engineering and project management. Currently pursuing a Master of Science at Columbia Business School, they have gained valuable experience through roles at IQVIA, Mastercard, INSIA, Celebal Technologies, and Darwinbox. Notably, they have led the development of transactional ETL pipelines, automated data processes, and executed cloud-based data solutions, significantly enhancing operational efficiency and data-driven decision-making. Their expertise extends to designing data storage architectures, performing complex data analyses, and developing social media analytics pipelines. With a proven track record of increasing sales and improving forecast accuracy, they have also contributed to product training and cross-functional collaboration, demonstrating a commitment to innovation and excellence in the technology sector.

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call

Top Talent like Kshitij are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

Kshitij Gupta

Data Engineer
New York, NY, US
Available for hire fromNegotiable
Contracts

Work History

I

Project Management Intern, Data Strategy

IQVIAJun 2024 - Aug 2024 • 3 mos- Executed cloud-based data solutions for IQVIA healthcare data, designing data storage architectures to improve processing speeds by 2x. - Collaborated across teams to deliver data-driven recommendations using an internal BI tool, to generate key data reports. - Analyzed add-spend data from 2016 to 2024 for pharmaceutical drugs to deliver comprehensive data insights for go-to-market strategies. - Performed asset archetyping to segment products, resulting in an improvement of drug classification for internal data repository.
M

Data Engineer

MastercardJun 2022 - Oct 2023 • 1 yr 5 mos- Led development of 20+ transactional ETL pipelines, for Mastercard Test & Learn product, by building robust relational database models, shell scripting, and SQL programming. - Performed data analysis on 100+ GB of data, to find critical patterns in consumer buying trends, increasing sales by 35%. - Conducted data extraction on datasets exceeding 10 million records using SQL and Python, creating robust statistical models that improved forecast accuracy by 20%. - Orchestrated product training sessions for new hires and interns. Led and mentored interns, imparting knowledge on ETL processes, SQL coding practices, data architecture, and product lifecycle. - Cross-functioned with product managers, consultants, software engineers, and senior leadership, to align 100% of data delivery work.
I

Product Data Engineer

INSIASep 2020 - Jun 2022 • 1 yr 10 mos- Automated data pipeline to reduce 4-hour manual process to 5-minute automated process using Python and SQL programming. - Designed and programmed over 40 end-to-end ETL pipelines and BAU processes on the platform to reduce manual data processes by 99%. - Scripted SQL queries on ClickHouse and MySQL databases to build 350+ business-specific KPIs. - Developed Social media analytics pipeline for Facebook, Instagram, LinkedIn, and Google Ads, by processing over 1M+ data points, automated the transformation of complex JSON into structured tables using Python. - Managed platform operations for 4 partner clients, organized post-production training sessions, and resolved 50+ issue tickets. - Created 30+ video tutorials encompassing the entire analytics product from Data setup, KPI configuration, Role Based Access Control, Search driven analytics, and product functionality to help increase the adoption rate by 80%. - Collaborated with other engineers, product managers, and designers to identify and platform bugs, to successfully scale automation.
C

Data Engineer Intern

Celebal TechnologiesSep 2020 - Feb 2021 • 6 mos- Performed data analysis and built key dashboards to highlight crucial business insights using Power BI, resulting in 10% increase in revenue. - Analyzed multiple datasets, built metrics and KPIs using DAX code to accurately calculate sales, cycle time, etc. - Scripted SQL queries to automate and increase data processing speed by 1.5x.
D

Product Analyst Intern

DarwinboxJan 2020 - Aug 2020 • 8 mosDarwinbox is a leading provider of cloud-based Human Resources Management Software (HRMS). - Performed stack ranking analysis, survey analysis, and product bug trends analysis to improve platform efficiency by 15%. - Created 20+ wireframes and Implemented logical design flow for new features and modules. Resulting in saving 3-4 minutes per user. - Designed auto-regressive moving average model prototype, with 80% accuracy using time series analysis for predictive analysis. - Cross functioned with deployment & developer teams to carry out statistical analysis.

Education

C

Columbia University

Master of Science - MS, Technology Management2023 - 2024
C

Columbia Business School

Master of Science - MS, Technology Management2023 - 2024
M

Manipal University Jaipur

Bachelor of Technology - BTech, Electronics and Communications Engineering2016 - 2020
T

The Hyderabad Public School, Begumpet

High School, ICSE

How Pangea Works

Effortlessly discover top talent

We've distilled the candidate search from endless hours down to just a few minutes. Using Pangea's AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company's niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea's fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team's capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We've combined every part of the hiring process into one platform to eliminate the miscommunication that's unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call
Pangea empowers fractional work across the world for marketing and design roles.