Snowflake Data Engineer

PRI INDIA IT SERVICES PRIVATE LIMITED; Bengaluru; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

PRI INDIA IT SERVICES PRIVATE LIMITED is seeking a Snowflake Consultant in Bengaluru to design and implement scalable data engineering and analytics solutions. You will leverage Snowpark (Python) to build pipelines, transformations, and analytics directly within Snowflake, enabling in-place processing without data movement.

You will work on data modeling, optimization, governance, and advanced data processing, collaborating with cross-functional teams in an Agile setup to deliver end-to-end

Qualifications

• Strong Snowflake and Snowpark experience with Python.
• Hands-on SQL and ETL/ELT design and implementation.
• Solid understanding of data warehousing concepts and RBAC.

Responsibilities

• Design and implement scalable data pipelines in Snowflake using Snowpark.
• Develop data models and schema architecture for analytics workloads.
• Optimize performance, cost, and data governance; ensure security controls.
• Collaborate with data architects, analysts, and QA in Agile ceremonies.
• Automate workflows and integrate data from cloud storage and APIs.

Skills

Snowflake

Snowpark (Python)

Python

SQL

ETL/ELT

Data Warehousing

RBAC & Security

Agile

Data Modeling

Data Governance

Education

Bachelor's degree in Computer Science / IT

Tools

Git

Airflow

dbt

Job description

• Data Engineering & Snowpark Development

We are seeking a Snowflake Consultant to design and implement scalable data engineering and analytics solutions on the Snowflake Data Cloud. The candidate will leverage Snowpark (Python API) to build efficient data pipelines, transformation logic, and advanced analytics workflows directly within Snowflake. Snowpark enables developers to process and transform data using Python directly inside Snowflake without moving data, making this role critical for modern data platforms.

Key Responsibilities

2. Data Modeling & Optimization 3. Advanced Data Processing & Analytics 4. Integration & Automation 5. Performance Tuning & Troubleshooting 6. Collaboration & Delivery

• Data Engineering & Snowpark Development
• Design and develop data pipelines (ETL/ELT) using Snowflake, SQL, and Python (Snowpark)
• Build data transformation logic using Snowpark DataFrame API
• Develop stored procedures, UDFs, and UDTFs in Python
• Enable data processing and analytics workflows directly within Snowflake
• Design and maintain data models and schema architecture
• Optimize query performance and cost efficiency
• Implement data governance, security, and RBAC policies
• Perform large-scale data transformation and processing using Python
• Build data science/ML workflows using Snowpark where applicable
• Support feature engineering, model scoring, and analytics pipelines
• Integrate data from sources such as:
• Cloud storage (AWS S3 / Azure Blob)
• SFTP / APIs / databases
• Automate workflows using tasks, pipelines, and orchestration tools
• Monitor and resolve:
• Data quality issues
• Performance bottlenecks
• Pipeline failures
• Optimize warehouse usage and compute scaling
• Work with:
• Data architects
• Business analysts
• Engineering and QA teams
• Translate business requirements into technical solutions
• Participate in Agile ceremonies and deliver end-to-end solutions

Required Skills & Experience

Core Skills

• Strong experience in Snowflake (Data Warehousing, SQL, Performance Tuning)
• Hands‑on experience in Python (mandatory)
• Working experience with Snowpark (Python API) for data pipelines
• Expertise in ETL/ELT design and implementation
• Solid understanding of data warehousing concepts

Technical Skills

• SQL:
• Complex queries, stored procedures, optimization
• Python:
• Data processing, automation, scripting
• Snowflake:
• Data modeling, pipelines, security

Cloud & Tools

• Exposure to at least one:
• AWS / Azure / GCP
• Experience with:
• CI/CD tools, Git
• Orchestration tools (Airflow, dbt - optional)

Preferred Qualifications

• Snowflake certifications

Soft Skills

• Strong analytical and problem-solving skills
• Ability to work in cross-functional environments
• Good communication for stakeholder interaction
• Agile mindset with focus on delivery and quality

Typical Experience Range

• 4-10 years in Data Engineering / Snowflake ecosystem
• 2+ years working on Python-based data processing or Snowpark