Solution Architect (AWS, Snowflake)

Roles & Responsibilities

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.

Key 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

1Strong Solution Architect Profile with AWS/Snowflake background and end-to-end data architecture experience

2Mandatory (Experience 1): Must have minimum 12+ years of experience in data engineering and architecture

3Mandatory (Experience 2): Must have experience designing scalable, secure data platform architectures covering ingestion, storage, transformation, and consumption layers

4Mandatory (Experience 3): Must have experience defining data models (dimensional, data vault, medallion) and architecting batch/near-real-time data pipelines

5Mandatory (Tech skill 1): Must have hands-on AWS (S3, IAM, Glue, Lambda, Kinesis/MSK, Step Functions, CloudWatch)

6Mandatory (Tech skill 2): Must have hands-on Snowflake (architecture, RBAC, Snowpipe, Streams, performance tuning, cost management)

7Mandatory (Tech skill 3): Must have hands-on DBT (Core/Cloud), SQL, and Python

8Mandatory (Tech skill 4): Must have experience with Airflow (or equivalent), Terraform, and CI/CD for data platforms

9Mandatory (Skill 1): Must be able to define data governance, security, and access control patterns (RBAC, masking, row-level security)

10Mandatory (Skill 2): Must be able to lead performance optimization, mentor engineers, and partner with business stakeholders

11Preferred (Certification): SnowPro Advanced certification (Architect)

12Preferred (Experience 1): Experience with Data catalog and lineage tools (Collibra, Alation) and Snowflake