Snowflake Developer - R01568220

Data Specialist

Primary Skills

• Snowflake, Airflow, DBT

Specialization

Snowflake Lead Developer

Job requirements

Key Responsibilities

Project Type: L3 Support

Flexibility to shift working is Mandatory.

Development Responsibilities

• Design and develop scalable data pipelines and modern data architectures using Snowflake.

• Lead migration initiatives from legacy databases to Snowflake.

• Build and optimize ELT frameworks using DBT.

• Develop and orchestrate workflows using Apache Airflow.

• Design and implement data models, including Star Schema and Snowflake Schema.

• Develop ingestion pipelines for structured and semi-structured data.

• Create reusable frameworks for data validation, reconciliation, auditing, and monitoring.

• Optimize Snowflake objects, including:

Virtual Warehouses

Clustering Keys

Materialized Views

Streams & Tasks

Dynamic Tables

• Develop technical design documents and migration runbooks.

• Perform code reviews and enforce engineering best practices.

Migration Responsibilities

• Assess and migrate data from legacy platforms, including:

Oracle

SQL Server

Teradata

Netezza

DB2

SAP HANA

On-Prem Data Warehouses

• Perform source system analysis and database rationalization.

• Design migration strategies, including:

Full Data Loads

Incremental Loads

CDC (Change Data Capture)

Historical Data Migration

• Conduct data reconciliation and validation during migration.

• Optimize transformed workloads for Snowflake architecture.

• Execute cutover planning and post-migration stabilization.

Good to have:

AMS / Production Support Responsibilities

• Provide L3 support for Snowflake data platforms and pipelines.

• Monitor and manage production data workloads.

• Troubleshoot data failures, performance issues, and pipeline disruptions.

• Perform root cause analysis (RCA) and implement permanent fixes.

• Support incident, problem, change, and release management activities.

• Work closely with business users and stakeholders to resolve production issues.

• Ensure adherence to SLA and operational support commitments.

• Participate in production releases and deployment activities.