Senior Data Engineer (Snowflake & Matillion)

Job Title: - Senior Data Engineer (Snowflake & Matillion)

Shift Timing – 1:00 PM IST – 10:00 PM IST

Work Mode-Remote

Experience: 8–10+ Years

Job Description:

Role Overview

We are seeking a Senior Data Engineer (Snowflake & Matillion) with deep Snowflake expertise to support and enhance our cloud data platform. This role demands advanced SQL proficiency, hands-on experience with Snowflake data warehousing, and strong capability in building, optimizing, and maintaining ELT pipelines using Matillion.

The ideal candidate must be comfortable handling intermediate to complex data transformations independently, optimizing performance at scale, and driving best practices across the data layer.

Core Technical Responsibilities

• Advanced SQL Development

Design and implement complex SQL transformations using:

• CTEs, subqueries, window functions, analytical functions

• Query refactoring for performance and readability

• Optimize SQL for large-volume datasets and high-concurrency workloads

• Perform query performance tuning and troubleshooting in Snowflake

• Review and refactor existing SQL logic to improve efficiency and maintainability

Snowflake Data Engineering

• Develop and manage Snowflake objects, including:

• Schemas, tables (transient, temporary), views, materialized views

• Stages, file formats, internal/external storage integrations

• Implement and optimize:

• Snowflake virtual warehouses (size, auto-suspend/resume, cost optimization)

• Clustering and micro-partition awareness

• Apply best practices for:

• Data loading and unloading (COPY INTO, Snowpipe – if applicable)

• Secure data access using roles and privileges

• Monitor and improve Snowflake query and storage costs

Matillion ELT Development

• Design, develop, and maintain Matillion pipelines for ELT workflows

• Implement parameterized, reusable, and scalable job designs

• Manage job dependencies, orchestration, and error handling

• Optimize ELT workflows for performance and reliability in Snowflake

• If interested, please share your resume on shivam.gaurav@programmers.ai