Title : Snowflake Developer - Wealth Management, Asset management

Location: Toronto, ON

Position Type: Contract, FTE

Job Summary

- We are seeking an experienced Snowflake Developer with strong expertise in Wealth Management and/or Asset Management to design, develop, and maintain up-to-date cloud-based data solutions. The ideal candidate will have hands-on experience with Snowflake, SQL, ETL/ELT, data warehousing, and financial services data, with a strong understanding of investment and asset management processes.

Key Responsibilities

- Design, develop, and maintain scalable Snowflake data warehouse solutions for Wealth and Asset Management applications.
- Develop complex SQL queries, stored procedures, views, functions, and data transformations.
- Build and optimize ETL/ELT pipelines integrating data from multiple financial and enterprise systems.
- Work with investment, portfolio, client, security, transaction, and market data.
- Develop data models supporting portfolio management, performance reporting, investment analytics, and client reporting.
- Implement Snowflake Streams, Tasks, Snowpipe, Dynamic Tables, and other Snowflake capabilities.
- Perform data profiling, validation, reconciliation,



and quality checks.
- Optimize Snowflake workloads for performance, scalability, and cost efficiency.
- Work closely with Wealth Management, Asset Management, Business Analysts, Data Architects, and downstream reporting teams.
- Troubleshoot data pipeline and production issues and provide root-cause analysis.
- Implement appropriate data security, governance, roles, and access controls.
- Participate in code reviews, testing, deployment, and technical documentation.

Required Skills

- 5+ years of experience in Snowflake / Data Engineering / Data Warehousing.
- Strong hands-on experience with Snowflake.
- Advanced SQL and database development skills.
- Strong experience with ETL/ELT development.
- Experience with Snowflake Streams, Tasks, Snowpipe, Stored Procedures, and Dynamic Tables.
- Strong understanding of data modeling, dimensional modeling, fact and dimension tables.
- Experience with AWS, Azure, or GCP.
- Experience with ETL/ELT tools such as Informatica, Talend, dbt, Matillion, or Azure Data Factory.
- Strong experience working with financial services data.

📌 Snowflake developer (Toronto)
🏢 KTek Resourcing
📍 Toronto