Software Engineering & Development, VP

State Street; Toronto; Hybrid; CAD 140,000 - 210,000; Full time

Job summary

State Street is seeking a hands-on Snowflake Lead to design, build, and maintain scalable data solutions in a cloud environment. You will own data pipelines, modeling, and governance while optimizing performance and costs.

The role requires deep Snowflake expertise, strong data engineering skills, and the ability to collaborate across multiple teams in a fast-paced setting. Hybrid work and regulatory compliance focus are expected.

Qualifications

• 12+ years of data engineering or related experience.
• Hands-on Snowflake production experience.
• Experience with complex cross-functional data ecosystems.
• Familiarity with regulatory reporting or control environments.
• Ability to work in a fast-paced environment with evolving priorities.

Responsibilities

• Design and maintain scalable Snowflake data pipelines and models.
• Optimize data ingestion, transformation, and reporting workflows.
• Ensure data quality, integrity, and consistency across platforms.
• Analyze Snowflake performance and control costs.
• Collaborate across teams to translate requirements into data solutions.
• Support production releases and ensure platform stability.
• Ensure data governance, audit, and security compliance.

Skills

Snowflake

Data modeling

SQL

Data pipelines

Azure

Analytical skills

Communication

Team collaboration

Automation

Education

12+ years of data engineering/data warehousing experience

Snowflake production experience

Experience in complex cross-functional data ecosystems

Familiarity with regulatory reporting/control environments

Production systems support and high-priority data issues

Tools

Airflow

Job description

Who We Are Looking For

You will be joining our team as a hands‑on Snowflake Lead, responsible for designing, building, and maintaining scalable data solutions. This role requires strong expertise in Snowflake, data engineering, and cloud‑based data platforms, along with a solid understanding of data governance, control environments, and regulatory requirements.

This role will play a critical role in developing and optimizing data pipelines, ensuring data quality and availability, and supporting business‑critical reporting and analytics. You will work across multiple teams to enable efficient, reliable, and scalable data processing in a fast‑paced environment. This role will also support the adoption of AI‑driven capabilities within data platforms, helping improve data quality, automation, and efficiency across business‑critical workflows.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines and data models using Snowflake
• Build and optimize workflows for data ingestion, transformation, and reporting
• Ensure high data quality, integrity, and consistency across data platforms
• Analyze and optimize Snowflake performance (query tuning, storage optimization, cost control)
• Break down complex data requirements into structured, implementable solutions
• Identify dependencies across upstream and downstream systems (e.g., source systems, reporting layers) and proactively manage them
• Troubleshoot data issues and implement durable fixes to prevent recurrence
• Develop and enhance data processes with a strong focus on automation, scalability, and reliability
• Define and track key metrics related to data pipelines, performance, and quality
• Ensure visibility into data flows, pipeline health, and processing outcomes
• Partner with business and technology teams to translate requirements into data solutions
• Clearly communicate risks, issues, and progress to stakeholders
• Support production releases, validate changes, and ensure stability of data platforms
• Ensure compliance with data governance, audit, and security requirements
• Support audit requests, controls validation, and remediation activities where needed

Skillset

• Strong expertise in Snowflake, including:
  • Data modeling (star/snowflake schemas)
  • Query optimization and performance tuning
  • Snowflake architecture and best practices
• Experience with:
  • SQL and advanced data transformation logic
  • Pipeline orchestration
  • Cloud platforms (Azure)
• Strong analytical and problem‑solving skills
• Ability to handle large‑scale data processing and troubleshoot complex data issues
• Experience working with structured and semi‑structured data
• Strong communication skills – able to explain data issues and solutions clearly
• Ability to work across teams in a matrix environment
• Proactive ownership and accountability for deliverables
• Ability to prioritize work, manage multiple deliverables, and meet tight deadlines
• Strong attention to detail and focus on data accuracy and quality
• Continuous improvement mindset with focus on automation

Education & Preferred Qualifications

• 12+ years of experience in data engineering, data warehousing, or financial services technology
• Strong hands‑on experience with Snowflake in a production environment
• Experience working in complex, cross‑functional data ecosystems
• Familiarity with regulatory reporting, financial data platforms, or control environments
• Experience supporting production systems and handling high‑priority data issues
• Ability to work in a fast‑paced environment with evolving priorities

What Success Looks Like In This Role

• Reliable, scalable data pipelines with minimal production issues
• Clear ownership of data flows and dependencies across systems
• Improved data quality and transparency for business users
• Strong collaboration across teams with no delivery gaps
• Proactive identification and resolution of issues before they impact delivery

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-792778