Job Description

Role Overview

We are seeking a Senior SQL Developer 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.

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

Data Modeling & Architecture

Design and support dimensional and analytical data models (fact/dimension structures)

Handle intermediate to advanced transformation logic

Ensure data quality, consistency, and accuracy across layers

Collaborate with downstream consumers (BI, reporting, analytics teams)

Must-Have

8+ years of hands-on SQL development with proven advanced-level capability

Strong experience with Snowflake in production environments

Strong experience using Matillion for ELT development

Deep understanding of:

Data warehousing concepts

ELT vs ETL patterns

Performance tuning and optimization

Ability to work independently on complex tasks with minimal supervision

Strong debugging, problem-solving, and analytical skills

Good-to-Have

Experience with cloud platforms (AWS / Azure / GCP)

Exposure to CI/CD for data pipelines

Experience mentoring or reviewing code for junior developers

Familiarity with data governance, auditing, or data quality frameworks

Must-Have Skills

Must Have • 8+ years of hands on SQL development with proven advanced level capability • Strong experience with Snowflake in production environments • Strong experience using Matillion for ELT development • Deep understanding of: o Data warehousing concepts o ELT vs ETL patterns o Performance tuning and optimization • Ability to work independently on complex tasks with minimal supervision • Strong debugging, problem solving, and analytical skills