Job Description
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
Job ID: R-788975
