Senior Data Engineer Baddi

Job Description

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 robust 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

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)

Required Skills & Experience

Must-Have

8+ year Apply on Kit Job: kitjob.in/job/4mzy8t