Job Summary
We are looking for an AVP - Data Pipeline, Integration & Snowflake Administration Engineering to own and support large-scale data ingestion, replication, and Snowflake platform administration.
This role will focus on GoldenGate-based replication, cloud-native pipelines, Snowflake data platform engineering
& administration, Databricks BAU support, and production issue triage.

Key Responsibilities

Data Engineering & Pipeline Ownership

Own and support data ingestion and replication pipelines using GoldenGate (GG), DMS
Design, build, and support data pipelines and integrations on Snowflake
Provide BAU support for pipelines (ReplHub, GG, DMS, Snowflake, etc.)
Develop and maintain data processing components using Python
Support and enhance Databricks pipelines and workloads

Snowflake Administration

Administer and manage Snowflake accounts, warehouses, databases, implementation ci/cd deployments and schemas

Implement and manage role-based access control (RBAC), user provisioning, and security policies
Monitor and optimize Snowflake performance, query tuning, and workload management
Manage compute/storage cost optimization strategies (auto-suspend, scaling policies)
Handle data sharing, replication, failover, and disaster recovery configurations
Ensure data governance, masking, encryption, network policies and compliance controls
Manage Snowflake upgrades, configurations, and platform health monitoring
Integration of SSO for Snowflake, key management
DR, failover and replication capabilities for Snowflake

Operations & Reliability

Lead production support, troubleshooting, and root cause analysis for pipeline and platform issues
Coordinate with cloud teams for performance, scalability, and reliability improvements
Monitor pipelines and Snowflake workloads for SLAs and operational health
Support testing, validation, and release activities across environments
Collaborate with application/business teams for pipeline enhancements and issue resolution

Required Skills & Experience

Strong, hands-on experience with Snowflake (MANDATORY) including administration and platform management
Proven experience in Snowflake administration:

RBAC, security, data governance
Performance tuning and query optimization
Warehouse and cost management
Backup, replication, and DR setup

Strong experience with GoldenGate (GG) and DMS
Hands-on experience with Python
Experience supporting Databricks in production environments
Strong understanding of AWS/Azure cloud services
Experience building and managing data warehouse/lakehouse architectures
Proven ability to triage and resolve production issues in large-scale data platforms

Preferred Qualifications

Experience with enterprise-grade Snowflake platform administration at scale
Knowledge of data security, governance, lineage, and auditing frameworks
Familiarity with monitoring/observability tools (e.g., Snowflake Resource Monitors, Query History, etc.)
Experience in financial data domains and regulatory environments
Exposure to data quality, reconciliation, and operational monitoring frameworks

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you'll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement