Snowflake Data Engineer

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