Solution Architect - AWS / Snowflake

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.

• 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

• 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