Snowflake Developer - R01568220

Brillio; Maharashtra; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

Brillio Bengaluru is seeking a senior data engineer to design and lead Snowflake-based data platforms, building scalable pipelines and modern architectures. You will migrate legacy databases to Snowflake and implement ELT patterns with DBT, while orchestrating workflows with Airflow.

Responsibilities include designing data models (Star/Snowflake schemas), developing ingestion pipelines for structured and semi-structured data, and optimizing Snowflake objects such as warehouses, materialized

Qualifications

• Experience designing Snowflake data architectures and pipelines.
• Proficiency with Airflow for workflow orchestration.
• Strong knowledge of DBT and ELT patterns.

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.

Skills

Snowflake

Airflow

DBT

Job description

Project Type: L3 Support

Flexibility to shift working is Mandatory.

• 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
• Materialized Views
• Streams & Tasks
• Dynamic Tables
• Develop technical design documents and migration runbooks.
• Perform code reviews and enforce engineering best practices.

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.