Senior Snowflake Data Analytics Engineer

State Street; Quincy (MA); On-site; USD 90,000 - 158,000; Full time

Benefits offered by this job

401K with company match

Insurance coverage (medical/dental/vis

Paid time off and family care

Employee Assistance Program

Job summary

State Street is seeking an experienced Snowflake Technical Engineer (AVP) to join our Data Platform Engineering team. You will plan, design, and maintain Snowflake-based data architectures and models across analytics projects, delivering self-service data capabilities to product teams.

You will lead documentation, automation, and DevOps for IaC deployments, ensuring security and compliance while collaborating with a global team on complex use cases.

Qualifications

• Experience with Snowflake cloud data warehouse implementations on AWS and Azure, and optionally GCP.
• Deep expertise in Snowflake features like resource monitors, time travel, zero copy clone, and cost governance.
• Proficiency in data modelling, ELT using Snowflake SQL, and complex stored procedures.

Responsibilities

• Plan, design, develop, and maintain data architectures, models and best practices in Snowflake.
• Create and enhance documentation for deployments, data flows and models; develop automation for self-service and management.
• Lead end-to-end provisioning and operational support, including DevOps for IaC deployments (Terraform, Ansible, Python).
• Ensure enterprise security/compliance standards are enforced and provide guidance on best practices.

Skills

Snowflake architecture

Data modeling

SQL tuning

CI/CD pipelines

Terraform

Python scripting

RBAC controls

Security/compliance

Education

Bachelor's degree in a technical field

Tools

SnowSQL

Terraform

Git

Databricks

GoldenGate

Job description

State Street is seeking an experienced Snowflake Technical Engineer (AVP) to join our Data Platform Engineering team. You will plan, design, and maintain Snowflake-based data architectures and models across analytics projects, delivering self-service data capabilities to product teams.

You will lead documentation, automation, and DevOps for IaC deployments, ensuring security and compliance while collaborating with a global team on complex use cases.