Snowflake Data Engineer

Deloitte Shared Services India; Bengaluru, Delhi, Mumbai; On-site; INR 2,800,000 - 3,800,000; Full time

Job summary

Deloitte Shared Services India in Bengaluru seeks a Senior Consultant/Manager - Snowflake Data Engineer to design, develop and optimize scalable data platforms enabling data-driven decision-making across business units.

You will build end-to-end data pipelines, manage Snowflake workloads, implement RBAC, and collaborate with stakeholders using Agile methods while advancing FinOps and DevOps practices.

Qualifications

• 5-8 years of Data Engineering experience with Snowflake expertise.
• Hands-on Snowflake architecture, development, and administration.
• Proficient in SnowSQL, Snowpipe, RBAC, and virtual warehouses.
• Strong ETL/ELT development experience with SnapLogic or similar tools.
• Experience with Control-M for data orchestration.
• Strong SQL/PLSQL and Python programming abilities.
• Exposure to CI/CD and DevOps practices with Git.

Responsibilities

• Design, develop, and support data ingestion, transformation, and distribution using Snowflake.
• Build scalable, secure data pipelines and optimize SQL workloads.
• Develop ETL/ELT processes with SnapLogic and integration tools.
• Implement data orchestration with Control-M and RBAC frameworks.
• Integrate data from Oracle, REST APIs, cloud storages and flat files.
• Develop data warehousing models and dimensional schemas.
• Monitor Snowflake workloads, storage, and query performance; fix issues.
• Support data lineage, metadata management, and governance in Snowflake ACCOUNT_USAGE.
• Build Streamlit apps and dashboards for data consumption and monitoring.

Skills

Data Engineering

Snowflake

SQL

PL/SQL

Python

ETL/ELT

CI/CD

Tools

SnowSQL

Snowpipe

Control-M

SnapLogic

Git

Job description

Senior Consultant/ Manager - Snowflake Data Engineer

Job Location: Bengaluru, Delhi NCR, Pune, Delhi, Mumbai,Coimbatore, Hyderabad, Kolkata, Bhubaneshwar

What Impact Will You Make?

At Deloitte, we help clients solve their most complex business challenges through innovative technology solutions. As a Snowflake Data Engineer, you will play a key role in designing, developing, and optimizing scalable data platforms that enable data-driven decision-making and business transformation.

Work You'll Do

As part of the team, you will:

• Design, develop, and support data ingestion, transformation, and distribution solutions using Snowflake.
• Build scalable, efficient, and secure data pipelines leveraging Snowflake best practices.
• Develop and optimize ETL/ELT processes using SnapLogic and other integration tools.
• Design and implement data orchestration workflows using Control-M.
• Work with SnowSQL, Snowpipe, and Role-Based Access Control (RBAC) frameworks.
• Develop robust data integration solutions across Oracle, REST APIs, AWS S3, Azure Storage, and flat-file sources.
• Design and implement data warehousing solutions and dimensional data models.
• Develop and optimize SQL, PL/SQL, and Python-based data processing solutions.
• Monitor, troubleshoot, and optimize Snowflake workloads, warehouse utilization, and query performance.
• Implement data lineage, metadata management, and governance frameworks using Snowflake ACCOUNT_USAGE and ACCESS_HISTORY.
• Build Streamlit-based applications and dashboards for data consumption and monitoring.
• Develop cost attribution and FinOps reporting solutions within Snowflake.
• Enable DevOps best practices through CI/CD pipelines, Git-based version control, and automated deployments.
• Collaborate with business stakeholders, architects, and client teams to deliver high-quality solutions.
• Participate in Agile ceremonies and follow SDLC best practices for project execution.

The Team

Our Data & Analytics practice helps clients unlock the value of data by enabling scalable modern data platforms, cloud transformation, advanced analytics, and intelligent automation solutions.

Qualifications Required:

• 5-8 years of experience in Data Engineering with strong expertise in Snowflake.
• Hands-on experience with Snowflake architecture, development, and administration.
• Experience working with SnowSQL, Snowpipe, RBAC, Virtual Warehouses, Cloning, Materialized Views, and Snowflake data loading/unloading processes.
• Strong expertise in ETL/ELT development using SnapLogic or similar integration platforms.
• Experience designing data ingestion and orchestration pipelines using Control-M.
• Strong SQL and PL/SQL development experience.
• Proficiency in Python or similar backend programming languages.
• Solid understanding of Data Warehousing concepts and ETL/ELT design patterns.
• Experience integrating data from Oracle databases, REST APIs, cloud storage platforms, and flat files.
• Exposure to CI/CD processes, DevOps practices, and Git version control.
• Experience working within Agile project delivery environments.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and stakeholder management skills.
• Client-facing consulting experience.

Preferred:

• Snowflake Certification (SnowPro or equivalent).
• Experience in Streamlit application development.
• Knowledge of Snowflake metadata management, tagging, and data lineage frameworks.
• Experience in FinOps and cloud cost optimization initiatives.
• Exposure to Jira, Confluence, and enterprise project management tools.
• Strong business acumen and understanding of functional business processes.