Senior Specialist - Architecture

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