Snowflake Data Engineer
Role Overview
“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.
WHY JOIN CAPCO?
You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.
MAKE AN IMPACT
Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.
#BEYOURSELFATWORK
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
CAREER ADVANCEMENT
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
DIVERSITY & INCLUSION
We believe that diversity of people and perspective gives us a competitive advantage.
Location - Bangalore Experience - 7+ yrs
We are seeking a Snowflake Data Engineer with hands-on Snowflake platform engineering skills to build and run scalable data pipelines and a secure, well-governed Snowflake platform on Microsoft Azure. You will combine data engineering (ingestion, transformation, modeling) with platform engineering (environment setup, security, automation, performance and cost optimization). Key Responsibilities • Design and build batch and near-real-time ELT/ETL pipelines into Snowflake from Azure sources using Azure Data Factory, ADLS Gen2, Event Grid, Databricks, Snowpipe, Streams and Tasks.
• Develop data models (raw, curated, consumption layers), Dynamic Tables, stored procedures and Snowpark transformations; optimize SQL.
• Administer and engineer the Snowflake platform: accounts, databases, schemas, warehouses, resource monitors and Dev/Test/Prod environments.
• Implement RBAC, network policies, SSO/SCIM with Microsoft Entra ID, masking and row access policies, tagging and data governance controls.
• Configure secure Azure integration: Private Link, storage integrations, Key Vault and VNet settings.
• Automate provisioning and deployments with Terraform and CI/CD (Azure DevOps or GitHub Actions, schemachange or dbt).
• Tune performance and manage cost: warehouse sizing, clustering, query profiling, caching and credit monitoring.
• Build data quality checks, pipeline monitoring and alerting using Azure Monitor, Log Analytics and Snowflake Account Usage.
• Implement data protection and recovery: Time Travel, Fail-safe, cloning, replication and failover.
• Collaborate with architects, analysts, BI and security teams; document standards and support production operations. Required Skills
• Strong hands-on Snowflake data engineering and platform administration experience.
• Advanced SQL and Python (Snowpark, SnowSQL) or equivalent scripting.
• Azure experience: ADLS Gen2, Azure Data Factory, Entra ID, Key Vault, Azure Monitor.
• Experience with Snowpipe, Streams, Tasks, Dynamic Tables and Secure Data Sharing.
• Terraform, Git and CI/CD pipeline experience. • Solid understanding of data warehousing, dimensional modeling and ELT patterns.
• Knowledge of data security, governance and compliance practices.
Key Skills for This Role
Full Job Posting
Job Title: Snowflake Data Engineer
About Us
“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount*. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.*
WHY JOIN CAPCO?
You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.
MAKE AN IMPACT
Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.
#BEYOURSELFATWORK
Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.
CAREER ADVANCEMENT
With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.
DIVERSITY & INCLUSION
We believe that diversity of people and perspective gives us a competitive advantage.
Location Bangalore
Experience - 7+ yrs
We are seeking a Snowflake Data Engineer with hands-on Snowflake platform engineering skills to build and run scalable data pipelines and a secure, well-governed Snowflake platform on Microsoft Azure. You will combine data engineering (ingestion, transformation, modeling) with platform engineering (environment setup, security, automation, performance and cost optimization).
Key Responsibilities
• Design and build batch and near-real-time ELT/ETL pipelines into Snowflake from Azure sources using Azure Data Factory, ADLS Gen2, Event Grid, Databricks, Snowpipe, Streams and Tasks.
• Develop data models (raw, curated, consumption layers), Dynamic Tables, stored procedures and Snowpark transformations; optimize SQL.
• Administer and engineer the Snowflake platform: accounts, databases, schemas, warehouses, resource monitors and Dev/Test/Prod environments.
• Implement RBAC, network policies, SSO/SCIM with Microsoft Entra ID, masking and row access policies, tagging and data governance controls.
• Configure secure Azure integration: Private Link, storage integrations, Key Vault and VNet settings.
• Automate provisioning and deployments with Terraform and CI/CD (Azure DevOps or GitHub Actions, schemachange or dbt).
• Tune performance and manage cost: warehouse sizing, clustering, query profiling, caching and credit monitoring.
• Build data quality checks, pipeline monitoring and alerting using Azure Monitor, Log Analytics and Snowflake Account Usage.
• Implement data protection and recovery: Time Travel, Fail-safe, cloning, replication and failover.
• Collaborate with architects, analysts, BI and security teams; document standards and support production operations.
Required Skills
• Strong hands-on Snowflake data engineering and platform administration experience.
• Advanced SQL and Python (Snowpark, SnowSQL) or equivalent scripting.
• Azure experience: ADLS Gen2, Azure Data Factory, Entra ID, Key Vault, Azure Monitor.
• Experience with Snowpipe, Streams, Tasks, Dynamic Tables and Secure Data Sharing.
• Terraform, Git and CI/CD pipeline experience. • Solid understanding of data warehousing, dimensional modeling and ELT patterns.
• Knowledge of data security, governance and compliance practices.
About Capco
Capco is a global management and technology consultancy dedicated to the financial services and energy industries.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Capco
Senior Analyst, Finance
Toronto, CAN
Senior Analyst - Finance Location: Toronto, Ontario (Hybrid) | Practice Area: Corporate Services | Department: Finance Make an impact where financial insight, precision and innovation come together. The Role At Capco, we
Senior Analyst, Finance
Toronto, CAN
Technical Recruiter - Energy Practice (Contract)
, USA
QA - ATP
Bengaluru, IND
Financial Analyst (F4 Analyst)
, IND
Platform consultant - BA/PM
, GBR
Executive Assistant
Edinburgh, GBR
PMO
, IND
