Senior Specialist - Architecture

Vivantify Technology Solutions India Private Limited; Navi Mumbai; On-site; INR 4,000,000 - 7,000,000; Full time

Benefits offered by this job

Competitive salary and benefits

Professional growth opportunities

Collaborative work environment

Challenging projects with leading tech

Job summary

Vivantify Technology Solutions India Private Limited in Navi Mumbai seeks a Senior Specialist - Architecture to design scalable data platforms. You will work with Snowflake, Airflow, AWS, SQL and dbt to build modular, production-grade pipelines and reusable data products.

The role emphasizes high-concurrency workloads, secure data ingestion with S3, and applying modern engineering practices including version control and CI/CD.

Qualifications

• Experience in designing data architectures for modern cloud data platforms.
• Strong hands-on with Snowflake, Airflow, AWS, SQL and dbt.
• Experience implementing Medallion Architecture (Bronze/Silver/Gold).
• Proficiency in SQL and Python for data transformations and pipelines.
• Familiarity with Data-as-Code, version control, CI/CD practices.

Responsibilities

• Design scalable Data Architecture solutions using Snowflake.
• Develop high-concurrency data workflows and elastic compute usage.
• Implement Medallion Architecture to deliver reusable data products.
• Build modular SQL/dbt models with Jinja-based transformations.
• Develop production-grade, event-driven Airflow DAGs in Python.
• Secure data ingestion with AWS S3 and Snowflake stages.
• Apply Data-as-Code practices and CI/CD to data platforms.
• Optimize data pipelines for reliability and scalability.

Skills

Apache Airflow

AWS Cloud Architecture

Azure SQL

Data Architecture

Snowflake

SQL

dbt

Python

Medallion Architecture

Data-as-Code

Jenkins CI/CD

Bitbucket

Tools

Snowflake

dbt

Apache Airflow

AWS S3

Jenkins

Bitbucket

Job description

Location: Navi Mumbai

Experience: 7–11 Years

About the Role

We are looking for a Senior Specialist - Architecture with strong expertise in Data Architecture and modern cloud data platforms. The role focuses on designing scalable data solutions using Snowflake, Apache Airflow, AWS, SQL, and dbt, with an emphasis on high-concurrency workloads, reusable data products, and production-grade data pipelines.

Job Description

The role involves designing and implementing modern data platforms using Snowflake and Medallion Architecture (Bronze/Silver/Gold) to create scalable and reusable data products. The candidate will work with advanced SQL and dbt to develop modular and maintainable transformation logic.

The position also requires experience with Apache Airflow for production-grade, event-driven Python DAGs, along with AWS S3 for secure and scalable data storage and integration with Snowflake. The candidate will apply Data-as-Code practices, version control, CI/CD, and pipeline optimization to support reliable data platform operations.

Key Responsibilities

• Design and implement scalable Data Architecture solutions using Snowflake.
• Develop high-concurrency workloads and leverage elastic compute capabilities in Snowflake.
• Implement Medallion Architecture to deliver reusable and high-quality data products.
• Develop advanced SQL and dbt models using parameterized Jinja-based transformation logic.
• Build production-grade, event-driven Apache Airflow DAGs using Python.
• Implement secure and scalable data ingestion using AWS S3 and Snowflake stages.
• Apply version control, CI/CD, and Data-as-Code practices to data platform development.
• Optimize pipelines and workflows for scalable and reliable data operations.

Required Skills

• Apache Airflow
• AWS Cloud Architecture
• Azure SQL
• Data Architecture
• Snowflake
• Advanced SQL and dbt
• Python-based data pipeline development
• Medallion Architecture — Bronze/Silver/Gold
• Data-as-Code principles
• Jenkins CI/CD

Preferred / Good to Have

• Bitbucket

Mandatory Skills

• Apache Airflow
• AWS Cloud Architecture
• Azure SQL
• Data Architecture
• Snowflake

Candidate Profile

The ideal candidate should have strong experience in data architecture and cloud data platforms, with hands-on expertise in Snowflake, Airflow, AWS, SQL, and dbt. They should be capable of designing scalable data solutions and applying modern engineering, orchestration, version control, and CI/CD practices.

Benefits Package

• Competitive salary and benefits package
• Opportunities for professional growth and development
• A collaborative and inclusive work environment
• The opportunity to work on exciting and challenging projects with leading clients