Rachit Srivastava

Data Engineer

Gurugram, Haryana, India7 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Led development of scalable data solutions at BCG.
Expert in cloud-native data engineering practices.
Strong track record in delivering impactful BI solutions.

Stackforce AI infers this person is a Data Engineering and Business Intelligence expert in the Consulting and Healthcare industries.

Contact

Skills

Core Skills

Data EngineeringCloud SolutionsBusiness Intelligence

Other Skills

AgileAirflowBusiness Intelligence (BI)DAXDBTData AnalyticsData Build Tool (DBT)Data Digital PlatformData ModelingData ValidationData VisualizationData WarehousingDatabase Management System (DBMS)Design ThinkingELT

About

As a Data Engineer Manager with ~8 years of experience, I specialize in designing and delivering advanced data engineering solutions that adhere to industry-leading best practices in architecture, data quality, and security. I have successfully led the development of data products from concept to execution, enabling powerful analytics capabilities across diverse domains. My work has consistently enhanced organizational data strategies, driving both innovation and measurable business outcomes.

Experience

Boston consulting group (bcg)

3 roles

Data Engineer Manager

Promoted

Apr 2025 – Present · 11 mos · Gurugram, Haryana, India

Managing end-to-end data engineering initiatives to support BCG’s digital and business intelligence platforms. Designing scalable cloud-native solutions using Snowflake, Airflow, and DBT, while collaborating with global teams to drive data innovation, reporting automation, and operational excellence in a fast-paced Agile environment.
Roles and Responsibilities:
Leading development of scalable data solutions using DBT and Snowflake.
Building and maintaining ELT pipelines with Airflow for reporting needs.
Modeling efficient cloud data warehouses following Snowflake best practices.
Developing centralized BI & Analytics solutions to automate data delivery.
Driving Agile initiatives to deliver scalable digital reporting products.
Supporting BAU operations to ensure stability of cloud data systems.
Collaborating with architects, developers, and stakeholders across Agile phases.
Translating business needs into robust Snowflake models and Airflow workflows.
Researching and implementing new technologies to enhance cloud data platforms.
Designing and optimizing transformation models using DBT.
Managing complex workflows and job orchestration through Airflow.
Overseeing Snowflake warehousing including design, security, and optimization.
Participating in full Agile SDLC for data-driven cloud projects.
Leveraging Python and DataFrames for scalable data processing.
Preparing data for GenAI use cases and initiatives.
Ensuring seamless integration with BI tools like Tableau.
Communicating technical solutions clearly to business and tech teams.

SnowflakeAirflowDBTPythonTableauData Engineering+1

Senior Data Engineer

Promoted

Jun 2023 – Apr 2025 · 1 yr 10 mos · Gurugram, Haryana, India

As a Senior Data Engineer, I play a pivotal role within an Agile team, tasked with developing and deploying scalable digital reporting solutions for a global stakeholder base. My responsibilities include designing sophisticated solutions that enhance our digital product portfolio. This involves implementing best practices in data modeling, as well as developing robust and scalable Extract-Load-Transform (ELT) jobs and data pipelines to support Tableau dashboards. Additionally, I ensure continuous support for routine business operations.
Roles and Responsibilities:
As a Senior Data Engineer, my role encompasses daily collaboration with architects, other development teams, vendors, and stakeholders throughout the Agile lifecycle, including design, development, implementation, and operations of both infrastructure and business mappings. My responsibilities include:
Utilizing strong analytical abilities and engaging in creative problem-solving.
Operating independently under general guidance, adapting flexibly in a fast-paced environment.
Collaborating with project stakeholders—both technical teams and end users—to grasp business requirements and devise database solutions for various challenges.
Investigating both technical and non-technical solutions, assessing new technologies, and leading initiatives to advocate, influence, and build consensus around innovations that fulfill business needs.

TableauDBTData ModelingELTAgileData Engineering+1

Data Engineer

Dec 2021 – Jun 2023 · 1 yr 6 mos · Gurugram, Haryana, India

My Role and Responsibilities :
I am IT Business Intelligence Developer (Data Engineer) working as an integral part of an Agile team delivering scalable digital reporting solutions for global stakeholders.
With in this role I am designing optimal solutions to support and operate the Finance data warehouse employing best practices for data modelling, scalable Extract-Load-Transform jobs and data pipelines for Tableau dashboards.
Working closely with the rest of the Business Intelligence delivery teams, As IT BI Developer also working with external developers, business contacts across and outside BCG functions, DBA’s, and Infrastructure teams.

TableauData ModelingETLAgileData EngineeringBusiness Intelligence

Kpmg

Data Engineer

Jun 2020 – Dec 2021 · 1 yr 6 mos · Gurgaon, Haryana, India

My Role and Responsibilities :
I worked as BI developer and developed Stored Procedure and SSIS Package which extracted data from multiple tables and stored required and optimized data.
Created Reports and Dashboards in Power Bi which gave insightful details about critical KPI’s which helped business in taking critical decisions .
I was responsible for creating interactive and detailed HR analytics report in Power BI which helped client to identify shortage and availability of Resources across organization.
I identified key KPI’s and developed critical schemas and Stored Procedures with in very stagnant timeline.
I was responsible for designing SSIS packages to extract data from different sources like SQL server 2014,MS Excel, Flat Files.
Transformed and loaded data into Dimension and Fact tables in Data Warehouse using SSIS.
I was also involved in creating T-SQL objects like Tables, Stored Procedures, Indexes, User Defined Functions ,Common Table Expression (CTE), Temp Table, etc.

Power BISSIST-SQLData WarehousingBusiness IntelligenceData Engineering

Infosys

System Engineer

May 2018 – Jun 2020 · 2 yrs 1 mo · Pune, Maharashtra, India

My Role and Responsibilities :
I was responsible for creating interactive Sales report & dashboard for a leading Healthcare client.
I developed end to end process for Data collection, data staging, data cleaning, Business Logic Implementation and publishing BI Reports using Power BI.
Key KPIs delivered were Sales, Revenue, Gender Diversity and Profit across multiple dimension for core changes in business policies.
I worked as BI Developer and identified the new application opportunities that lead to additional data being added to customer data warehouse as high margin engagement. It helped in creating Key KPI’s.
Demonstrated ability to relate business problems to the underlying data and ability of Data Warehouse Technology to solve business problems.
I was also responsible for data modeling, creating interactive dashboards and reports using Power BI.

Power BIData ModelingSQLBusiness IntelligenceData Engineering