Data Engineer

Job Title: SENIOR SNOWFLAKE ENGINEER

Hirematic Talent Solutions is hiring on behalf of a confidential client for an experienced Senior Snowflake Engineer to help build, enhance, and operate a modern enterprise data platform centered on Snowflake.

This role requires a highly experienced Data Engineer with strong expertise in ETL/ELT development, Snowflake data pipelines, SQL, Python, and scalable data engineering solutions. The successful candidate will combine advanced Snowflake development, data architecture, and platform engineering to deliver performant, secure, and governed data products, developer utilities, and Snowflake-based applications that enable analytics and data products across the business.

Candidates must have experience within the FinTech or Payments domain.

• Location: Toronto, Ontario, Canada (Onsite – 5 Days/Week)
• Compensation: CAD $53/hour
• Job Type: Full-Time Contract
• Experience: 10+ Years
• Reports To: Director, Data and AI

Responsibilities

• • Lead the design and implementation of Snowflake-based data architectures, including 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 such as StreamSets, dbt, Fivetran, Matillion, and Airbyte.
• • Develop Snowflake-native utilities and applications using 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 using role-based access, masking policies, object tagging, data lineage, and audit logging.
• • Automate infrastructure and deployments using Infrastructure as Code (IaC) for Snowflake objects and cloud infrastructure, CI/CD pipelines, and automated testing for SQL and Snowpark code.
• • Build observability and operational tooling, including monitoring, alerting, usage and cost reporting, and incident playbooks for Snowflake workloads.
• • Mentor engineers, review technical designs, and contribute to roadmap decisions for Snowflake platform evolution.

• Required Qualifications
• • 10+ years of relevant Data Engineering experience.
• • Strong hands-on experience designing and operating Snowflake in production environments.
• • Deep experience with Snowflake capabilities including Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, external functions, and user-defined functions (UDFs).
• • Hands-on ETL/ELT development experience with dbt, SQL, and one or more ingestion tools such as StreamSets, Fivetran, Matillion, Airbyte, or Kafka connectors.
• • Strong proficiency in Python, including Snowpark and/or Snowflake connectors.
• • Strong SQL development, tuning, and query optimization skills.
• • Experience with Infrastructure as Code and automation using Terraform, GitHub Actions, Jenkins, or equivalent technologies.
• • Strong knowledge of AWS, Azure, or GCP and native cloud services as they relate to Snowflake deployments and integrations.
• • Solid understanding of Medallion Architecture, data modeling patterns, data governance, and secure data sharing.
• • Demonstrated experience implementing CI/CD, automated testing, and production operational practices for data workloads.
• • FinTech or Payments industry experience.

• Required Skills
• • Snowflake
• • Data Engineering
• • ETL / ELT
• • SQL
• • Python
• • Snowpark
• • Snowpipe
• • Streams & Tasks
• • Data Pipelines
• • Data Architecture
• • Data Modeling
• • dbt
• • StreamSets
• • Fivetran
• • Matillion
• • Airbyte
• • Kafka Connectors
• • AWS / Azure / GCP
• • Infrastructure as Code (IaC)
• • Terraform
• • CI/CD
• • GitHub Actions
• • Jenkins
• • Data Governance
• • Data Security
• • Query Optimization
• • Secure Data Sharing
• • Observability
• • Production Data Platforms

• Preferred Qualifications
• • Snowflake SnowPro Core or advanced Snowflake certifications.
• • Experience with dbt Core or dbt Cloud for transformation and modular SQL engineering.
• • Experience with data virtualization, data catalogs, or data lineage tools.
• • Familiarity with analytics and BI integrations such as Looker, Tableau, or Power BI and building Snowflake-optimized semantic layers.
• • Experience developing internal developer tools or data applications using Snowpark or lightweight web frameworks.

• Ideal Candidate
• • Senior Data Engineer with deep hands-on Snowflake expertise.
• • Strong background building and operating production-grade Snowflake data platforms.
• • Experienced in designing scalable ETL/ELT pipelines and Snowflake-native solutions.
• • Strong Python and SQL engineering capabilities.
• • Experienced in data architecture, platform engineering, security, governance, automation, and operational reliability.
• • Able to mentor engineers, review technical designs, and contribute to Snowflake platform roadmap decisions.
• • Experienced within the FinTech or Payments domain.
• • Comfortable working onsite in Toronto five days per week.