Rahul Pathak
Gurugram
Summary
Engineering Specialist with 12+ years of experience in Data Engineering, Analytics, Business Intelligence, and AI-powered data solutions, specializing in Snowflake, DBT, SQL, Python, PySpark, Databricks, and Tableau. Proven expertise in designing and delivering scalable data pipelines, governed Data Products, and enterprise data platforms. Hands-on experience with Snowflake GenAI capabilities, including Cortex Analyst, Cortex Search, semantic modeling, and natural language analytics, enabling business users to interact with governed enterprise data through AI-driven insights. Exposure to Machine Learning workflows, complemented by experience in Data Governance, data modeling, and stakeholder collaboration, delivering trusted, analytics-ready solutions that improve data quality and enable data-driven decision-making.
Overview
1
1
Certification
13
13
years of professional experience
Work History
Engineering Specialist
Ness Digital Engineering
2025.04 - Current
- Owned the end-to-end development of a domain-specific Golden Source of Truth (GSOT) Data Product using Snowflake, DBT, SQL, and Python, delivering a centralized, governed, analytics-ready data foundation for enterprise reporting and analytics.
- Designed and implemented scalable ELT pipelines to ingest data from multiple sources into Snowflake, leveraging modular DBT models, reusable macros, and optimized transformation workflows.
- Partnered with Data Governance team to deliver certified Data Product through implementation of enterprise data quality rules, metadata management, data lineage, and stewardship workflows.
- Led the design and development of enterprise Data Quality applications by architecting backend data models and implementing role-based access control (RBAC) to enable secure, governed access to enterprise data assets.
- Built and deployed Snowflake Cortex Analyst agent by designing semantic models and business-friendly data definitions, enabling users to query governed enterprise data using natural language for accurate, context-aware insights.
- Collaborated with business stakeholders, data owners, and data stewards to standardize KPI definitions, validate source systems, and transform business requirements into trusted, reusable data products.
- Leveraged AI-assisted development tools, including GitHub Copilot, Cursor, Claude, ChatGPT Enterprise, and Visual Studio Code Copilot, to accelerate software development, improve code quality, automate repetitive tasks, and enhance solution design and developer productivity.
Senior Software Engineer
S&P Global
Gurugram
2023.12 - 2025.04
- Developed data pipelines for ingesting and transforming data from Amazon S3 into Snowflake, enhancing analytics and reporting capabilities.
- Optimized data loading and transformation workflows to improve pipeline performance and data reliability.
- Built SQL-based transformation logic using CTEs, joins, window functions, and stored procedures to prepare analytics-ready datasets.
- Delivered curated datasets for Tableau dashboards, empowering business users to perform self-service analytics efficiently.
- Collaborated with cross-functional teams to validate data quality, troubleshoot production issues, and support reporting requirements.
- Worked with Snowflake features including COPY INTO, Snowpipe, Streams & Tasks, Time Travel, and Secure Data Sharing to support scalable and governed data engineering solutions.
Staff Engineer
Nagarro Software Pvt. Ltd.
2021.05 - 2023.12
- Developed business intelligence solution for rail transport company, improving visibility into operational and financial performance.
- Used Snowflake as the centralized data warehouse to store and manage data from multiple systems (e.g., ticketing, scheduling, GPS tracking, maintenance, customer feedback).
- Performed data transformations using SQL to clean, enrich, and prepare datasets for reporting.
- Designed and published Tableau dashboards, facilitating data-driven decisions across operations, planning, and customer service departments.
- Project Overview (Rail Transport KPI Reporting System)
- Tech Stack: Snowflake, Tableau
Business and Programming Analyst
American Express
gurugram
2019.10 - 2021.05
- Led project focused on developing key risk indicators for dispute management.
- Supported UAT phases by identifying core issues in KRIs and refining testing processes for optimization.
- Collaborated with cross-functional teams to test transformation solutions and automate testing processes.
- Empowered business users with self-service capabilities by developing advanced MIS reporting, reducing manual effort.
- Fostered relationships across diverse teams to enhance global initiatives and improve solution delivery.
- Leveraged technologies including Hadoop, Hive and Pyspark.
Business Analyst (AM)
EXL Service Inductis India Pvt. Ltd.
2015.11 - 2019.10
- Analyzed auto insurance claims data using logistic regression in Python to assess risk
- Created a summary dashboard in Tableau to visualize insurance data
- Conducted text mining analysis using SAS software to extract insights from data
Process Associate
Capgemini
2014.01 - 2015.11
- Developed SCM data validation dashboards to enhance tracking and reporting.
Education
B.Tech/B.E. - Information Science And Engineering
Visveswaraiah Technological University (VTU)
2012-06
Skills
- Data Engineering
- Snowflake
- Snowflake GenAI
- SQL
- DBT
- Databricks
- Databricks Gen AI
- AWS ( S3, lambda, glue, Athena, Redshift)
- github
- CI/CD
- Azure
- Python
- PySpark
- Data Modeling
- Data Governance
- Machine Learning
- Data Analysis
- Requirement Analysis
- Data Visualization
- Tableau
- Pandas
- Hive
- Client management
Certification
- Snowpro core COF - CO3
- Github Copilot
- Databricks Data Analyst Associate
- Databricks Data Engineering Associate
- Sql Server
- Tableau Desktop Associate
- Python by hackerrank
Languages
- English
- Hindi
Timeline
Engineering Specialist
Ness Digital Engineering
2025.04 - Current
Senior Software Engineer
S&P Global
2023.12 - 2025.04
Staff Engineer
Nagarro Software Pvt. Ltd.
2021.05 - 2023.12
Business and Programming Analyst
American Express
2019.10 - 2021.05
Business Analyst (AM)
EXL Service Inductis India Pvt. Ltd.
2015.11 - 2019.10
Process Associate
Capgemini
2014.01 - 2015.11
B.Tech/B.E. - Information Science And Engineering
Visveswaraiah Technological University (VTU)