Snowflake Data Architect

RapidBrains; Pune District; On-site; INR 2,500,000 - 5,200,000; Full time

Job summary

RapidBrains is seeking an experienced Snowflake Data Engineer / Data Architect with 8+ years of overall data engineering experience and at least 6 years hands-on Snowflake work. The role focuses on Snowflake architecture, data modeling, and end-to-end data pipelines using SQL, Python, dbt, Airflow, and ADF.

We expect expertise in Snowpipe, Streams, Tasks, and Time Travel, plus governance, security, and data quality.

Qualifications

• 8+ years of overall experience in data engineering, including a minimum of 6 years hands-on Snowflake experience.
• Strong expertise in Snowflake architecture, administration, implementation, optimization, and troubleshooting.
• Proficiency in SQL, Python, dbt, Airflow, and Azure Data Factory (ADF) or similar orchestration tools.
• Hands-on experience with Snowpipe, Streams, Tasks, Materialized Views, Clustering, Time Travel, and workload management.
• Strong knowledge of data modeling, Medallion Architecture, data governance, and data quality.
• Experience with Snowflake Data Sharing, Snowflake Marketplace, and enterprise data integration.
• Experience integrating REST/SOAP APIs and connecting Snowflake with Salesforce, SAP, CRM/ERP, and SaaS platforms.
• Strong exposure to Azure or AWS cloud data services and cloud-native data engineering solutions.
• Familiarity with CI/CD, Git, automated deployments, and DevOps best practices.
• Experience in the financial domain is preferred but not mandatory.
• Snowflake certification, such as SnowPro Core or Advanced Data Engineer, is preferred.

Responsibilities

• Design, implement, and manage Snowflake databases, schemas, virtual warehouses, RBAC, and workload management.
• Develop and optimize data pipelines using Snowflake, dbt, Python, Airflow, and Azure Data Factory (ADF).
• Configure and maintain Snowpipe, Streams, Tasks, Materialized Views, Clustering, and Time Travel.
• Design and implement dimensional and normalized data models, with Medallion Architecture (Bronze, Silver, Gold).
• Perform Snowflake performance tuning, cost optimization, and troubleshooting.
• Implement data quality, governance, security, and access control practices.
• Integrate Snowflake with REST/SOAP APIs, Salesforce, SAP, CRM/ERP systems, and other enterprise apps.
• Work with Snowflake Data Sharing, Marketplace, and cloud-native services for data ingestion/storage.
• Implement CI/CD pipelines, Git workflows, automated deployments, and code review processes.
• Collaborate with architects, analysts, and stakeholders to translate business requirements into scalable data solutions.
• Troubleshoot production issues, maintain pipeline reliability, and provide end-to-end support.
• Develop technical documentation, reusable components, and engineering best practices.

Skills

8+ years of experience in data eng

Snowflake experience

Education

Bachelor's or Master's in CS/IS or related

Tools

Snowflake

SQL

Python

dbt

Apache Airflow

Azure Data Factory (ADF)

REST/SOAP APIs

Salesforce

SAP

CRM/ERP integration

Git

Job description

We are looking for an experienced Snowflake Data Engineer / Data Architect with strong expertise in Snowflake and modern data engineering technologies, with 8+ years of experience, including a minimum of 6 years of dedicated Snowflake experience. The ideal candidate will have hands‑on experience in Snowflake architecture, SQL, Python, dbt, Apache Airflow, and cloud data services, along with expertise in designing, developing, optimizing, and managing enterprise‑scale data pipelines and solutions.

Key Responsibilities

• Design, implement, and manage Snowflake databases, schemas, virtual warehouses, RBAC, and workload management.
• Develop and optimize data pipelines using Snowflake, dbt, Python, Apache Airflow, and Azure Data Factory (ADF).
• Configure and maintain Snowpipe, Streams, Tasks, Materialized Views, Clustering, and Time Travel.
• Design and implement dimensional and normalized data models, along with Medallion Architecture (Bronze, Silver, and Gold layers).
• Perform Snowflake performance tuning, cost optimization, and troubleshooting using the Snowflake portal and console.
• Implement data quality, governance, security, and access control practices.
• Integrate Snowflake with REST/SOAP APIs, Salesforce, SAP, CRM/ERP systems, and other enterprise applications.
• Work with Snowflake Data Sharing, Snowflake Marketplace, and cloud-native services for data ingestion, storage, and integration.
• Implement CI/CD pipelines, Git workflows, automated deployments, and code review processes.
• Collaborate with architects, business analysts, and stakeholders to translate business requirements into scalable data solutions.
• Troubleshoot production issues, maintain pipeline reliability, and provide end‑to‑end support with minimal supervision.
• Develop technical documentation, reusable components, and engineering best practices.

Skills and Requirements

• 8+ years of overall experience in data engineering, including a minimum of 6 years of hands‑on Snowflake experience.
• Strong expertise in Snowflake architecture, administration, implementation, optimization, and troubleshooting.
• Proficiency in SQL, Python, dbt, Apache Airflow, and Azure Data Factory (ADF) or similar orchestration tools.
• Hands‑on experience with Snowpipe, Streams, Tasks, Materialized Views, Clustering, Time Travel, and workload management.
• Strong knowledge of data modeling, Medallion Architecture, data governance, and data quality.
• Experience with Snowflake Data Sharing, Snowflake Marketplace, and enterprise data integration.
• Experience integrating REST/SOAP APIs and connecting Snowflake with Salesforce, SAP, CRM/ERP, and SaaS platforms.
• Strong exposure to Azure or AWS cloud data services and cloud-native data engineering solutions.
• Familiarity with CI/CD, Git, automated deployments, and DevOps best practices.
• Experience in the financial domain is preferred but not mandatory.
• Bachelor's or master's degree in Computer Science, Information Systems, or a related field.
• Snowflake certification, such as SnowPro Core or Advanced Data Engineer, is preferred.
• Excellent problem‑solving, communication, and stakeholder management skills, with the ability to work independently.