At a Glance
- Tasks: Design and build innovative Snowflake solutions for data analytics and governance.
- Company: Join a leading fintech company revolutionizing data platforms.
- Benefits: Competitive pay, flexible work options, and opportunities for skill development.
- Other info: Dynamic team environment with mentorship and career growth potential.
- Why this job: Make an impact in the data world with cutting-edge Snowflake technology.
- Qualifications: Strong ETL skills, Snowflake expertise, and a passion for data engineering.
The predicted salary is between 121500 - 148500 $ per year.
We are building a modern data platform centered on Snowflake and we are seeking a Snowflake-focused data professional to design, build and operationalize Snowflake-native solutions. The role combines advanced Snowflake development (Snowpark, Streams & Tasks, Snowpipe), data architecture and platform engineering to deliver performant, secure, governed data products, developer utilities and Snowflake-based apps that enable analytics and data products across the business.
Location: Toronto, Canada
Job type: Contract
Must-Have Technologies
- Data Engineer with strong expertise in ETL development, building Snowflake data pipelines, SQL, Python, and scalable data engineering solutions.
- Look for candidates from Fintech or Payment background.
Reports To
Director, Data and AI
Responsibilities And Duties
- Lead design and implementation of Snowflake-based data architectures: schemas, data vault/house/star models, materialized views, and zero-copy cloning patterns for environments.
- Build and maintain production ETL/ELT pipelines into Snowflake using Snowpipe, Snowpark, Streams & Tasks and partner tools (Streamsets, dbt, Fivetran, Matillion, Airbyte, etc.).
- Develop Snowflake-native utilities and apps (Snowpark for Python, UDFs, external functions, and internal tools) to accelerate developer productivity and data product delivery.
- Optimize query performance and cost through clustering keys, partitioning strategies, resource monitors, warehouse sizing, and workload isolation.
- Implement data governance, security and access controls in Snowflake based on role-based access, masking policies, object tagging, data lineage and audit logging.
- Automate infrastructure and deployments leveraging IaC for Snowflake objects and cloud infra CI/CD pipelines, and automated testing for SQL/Snowpark code.
- Build observability and operational tooling by monitoring, alerting, usage/cost reporting, and incident playbooks for Snowflake workloads.
- Mentor engineers, review designs and contribute to roadmap decisions for Snowflake platform evolution.
Required Skills And Experience
- Strong hands-on experience designing and operating Snowflake in production.
- Deep experience with Snowflake features, like Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, external functions and user-defined functions.
- Hands-on ETL/ELT development experience with dbt, SQL, and one or more ingestion tools (Streamsets, Fivetran, Matillion, Airbyte, Kafka connectors).
- Proficient in Python (Snowpark/connector), SQL tuning and query optimization techniques.
- Experience with IaC and automation (Terraform, GitHub Actions, Jenkins, or equivalent).
- Strong knowledge of cloud platforms and native services (AWS, Azure or GCP) as they relate to Snowflake deployment and integrations.
- Solid understanding of medallion architecture, data modeling patterns, data governance, and secure data sharing.
- Demonstrated ability to implement CI/CD, automated testing and production operational practices for data workloads.
Preferred Qualifications
- Snowflake SnowPro Core or advanced Snowflake certifications.
- Experience with dbt (core or Cloud) for transformation and modular SQL engineering.
- Experience with data virtualization, data catalogs or data lineage tools.
- Familiarity with analytics and BI integrations (Looker, Tableau, Power BI) and building Snowflake-optimized semantic layers.
- Experience building internal developer tools or data apps using Snowpark or lightweight web frameworks.
Senior Snowflake Engineer in Toronto employer: Princeton IT Services, Inc
As a Lead Data Engineer / Data Platform Lead in Toronto, you'll join a dynamic team that values innovation and collaboration, fostering a culture where your technical leadership can shine. The company offers competitive benefits, opportunities for professional growth, and a commitment to work-life balance, making it an ideal environment for those looking to make a meaningful impact in the data engineering field. With a focus on cutting-edge technologies like GenAI and a supportive atmosphere, this role is perfect for individuals eager to drive data solutions that align with business outcomes.
Contact Details:
Princeton IT Services, Inc Recruitment Team
