Snowflake Data Analytics Architect - Platform & Automation

STATE STREET CORPORATION; Quincy (MA); On-site; USD 90,000 - 158,000; Full time

Job summary

State Street Corporation is seeking a Snowflake Technical Engineer AVP to join the Data Platform Engineering team in the US. You will design, build, and maintain a resilient Snowflake-based data platform supporting self-service analytics and integrated data flows.

You will lead end-to-end Snowflake implementations on AWS/Azure, optimize performance, and implement CI/CD automations with Terraform, Ansible and Python. Strong SQL, security controls and data modeling are essential.

Qualifications

• 5+ years of Data Analytics & Integration experience.
• End-to-end Snowflake cloud data warehouse implementation on AWS and Azure.
• Deep expertise in Snowflake features: resource monitors, RBAC, warehouse sizing, performance tuning, zero copy clone, time travel, cost governance.
• Experience with CI/CD pipelines using Git and IaC (Terraform, Ansible, Python).
• Experience with data migration from RDBMS to Snowflake and data security/access controls.

Responsibilities

• Plan, design, develop and maintain data architecture, models and best practices for Snowflake deployments.
• Incorporate new features and ensure subject areas modelled to integrate with existing structures.
• Document deployments and best practices for data architectures, data flows and models.
• Develop automation to enable self-service and platform management.
• Collaborate across onshore/offshore teams and provide design guidance.

Skills

Snowflake

Data modeling

Time Travel

RBAC controls

Query tuning

CI/CD pipelines

Terraform

Python

SnowSQL

Databricks

Education

Snowflake Architect Certification

Tools

Terraform

Ansible

Python

SnowSQL

SnowPipe

GoldenGate

Git

Databricks

S3

ADLS

Job description

State Street Corporation is seeking a Snowflake Technical Engineer AVP to join the Data Platform Engineering team in the US. You will design, build, and maintain a resilient Snowflake-based data platform supporting self-service analytics and integrated data flows.

You will lead end-to-end Snowflake implementations on AWS/Azure, optimize performance, and implement CI/CD automations with Terraform, Ansible and Python. Strong SQL, security controls and data modeling are essential.