Solution Architect - AWS / Snowflake

Human Development & Research Foundation; Mumbai, Delhi, Bengaluru; Hybrid; INR 4,000,000 - 7,000,000; Full time

Job summary

Human Development & Research Foundation in Mumbai and other major Indian cities seeks a Senior Data Architect to own end-to-end data architecture on AWS and Snowflake, setting standards and guiding a team to deliver a scalable, secure data platform.

You will define data models (dimensional, data vault, medallion), architect batch and near-real-time pipelines, and lead performance optimization while ensuring governance and security across the platform.

Qualifications

• Minimum 12+ years in data engineering and architecture.

Responsibilities

• Design scalable, secure data platform architectures on AWS and Snowflake.
• Define data models (dimensional, data vault, medallion) and DBT project structure.
• Architect batch and near-real-time data pipelines, including source integration and orchestration.
• Lead performance optimization: warehouse sizing, clustering, query tuning, cost management.
• Define data governance, security, and access control patterns (RBAC, masking, row-level security).
• Review designs and code, mentor engineers, and resolve blockers.
• Partner with business stakeholders to translate requirements into technical solutions.
• Produce architecture documentation, design decisions, and reference patterns.

Skills

Data governance

End-to-end data architecture

Performance optimization

Mentor engineers

Stakeholder collaboration

Tools

AWS

Snowflake

DBT

SQL

Python

Airflow

Terraform

CI/CD

Job description

Job Summary

Own the end-to-end data architecture on AWS and Snowflake, set technical standards, and guide the team in delivering a scalable, secure, and cost-efficient data platform.

Responsibilities

• Design scalable, secure data platform architectures on AWS and Snowflake, covering ingestion, storage, transformation, and consumption layers
• Define data models (dimensional, data vault, medallion) and DBT project structure, naming conventions, and coding standards
• Architect batch and near-real-time data pipelines, including source integration, orchestration, error handling, and recovery
• Lead performance optimization: warehouse sizing, clustering, query tuning, materialization strategy, and cost monitoring
• Define data governance, security, and access control patterns (RBAC, masking, row-level security, encryption)
• Review designs and code, mentor engineers, and resolve technical blockers
• Partner with business stakeholders, product owners, and delivery leads to translate requirements into technical solutions
• Produce architecture documentation, design decisions, and reference patterns

Ideal Candidate

• Strong Solution Architect Profile with AWS/Snowflake background and end-to-end data architecture experience
• Mandatory (Experience 1): Must have minimum 12+ years of experience in data engineering and architecture
• Mandatory (Experience 2): Must have experience designing scalable, secure data platform architectures covering ingestion, storage, transformation, and consumption layers
• Mandatory (Experience 3): Must have experience defining data models (dimensional, data vault, medallion) and architecting batch/near-real-time data pipelines
• Mandatory (Tech skill 1): Must have hands‑on AWS (S3, IAM, Glue, Lambda, Kinesis/MSK, Step Functions, CloudWatch)
• Mandatory (Tech skill 2): Must have hands‑on Snowflake (architecture, RBAC, Snowpipe, Streams, performance tuning, cost management)
• Mandatory (Tech skill 3): Must have hands‑on DBT (Core/Cloud), SQL, and Python
• Mandatory (Tech skill 4): Must have experience with Airflow (or equivalent), Terraform, and CI/CD for data platforms
• Mandatory (Skill 1): Must be able to define data governance, security, and access control patterns (RBAC, masking, row-level security)
• Mandatory (Skill 2): Must be able to lead performance optimization, mentor engineers, and partner with business stakeholders
• Preferred (Certification): SnowPro Advanced certification (Architect)
• Preferred (Experience 1): Experience with Data catalog and lineage tools (Collibra, Alation) and Snowflake Cortex

Location -

Mumbai, Delhi / NCR, Bengaluru , Kolkata, Chennai, Hyderabad, Ahmedabad, Pune,All India ,Hybrid working