About the Role
This hands-on Snowflake Lead role is responsible for designing, building, and maintaining scalable data solutions. The role is critical in developing and optimizing data pipelines, ensuring data quality and availability, and supporting business-critical reporting and analytics. It also supports the adoption of AI-driven capabilities within data platforms.
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 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
Requirements
- Strong expertise in Snowflake, including data modeling (star/snowflake schemas), query optimization and performance tuning, and Snowflake architecture and best practices
- Experience with SQL and advanced data transformation logic
- Experience with pipeline orchestration
- Experience with 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
- 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
Skills
- Snowflake
- Data modeling
- Query optimization
- Performance tuning
- Snowflake architecture
- SQL
- Data transformation
- Pipeline orchestration
- Azure
- Analytical skills
- Problem-solving
- Large-scale data processing
- Data governance
- Data control environments
- Regulatory requirements
- AI-driven capabilities
Experience Level
- 12+ years of experience in data engineering, data warehousing, or financial services technology
- Strong hands-on experience with Snowflake in a production environment
Benefits
- Inclusive development opportunities
- Flexible work-life support
- Paid volunteer days
- Vibrant employee networks
About the Company
- 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.
Equal Opportunity
- 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.
