Senior Data Engineer (Snowflake)

Location: Toronto, Ontario, Canada, with hybrid work schedules; hubs are also available in Los Angeles, San Francisco, and Raleigh. Applicants are welcomed from across the U.S. where employment is supported, excluding Alaska, Hawaii, Kentucky, Mississippi, Nebraska, New Mexico, North Dakota, Rhode Island, South Dakota, West Virginia, and Wyoming.

Base salary: $120,000–$197,000 plus annual bonus and stock options.

Company

hirify.global develops software for commercial contractors, supporting service and project workflows and the operation of buildings, businesses, and critical infrastructure.

What you will do

• Build and scale CDC ingestion pipelines from MySQL, PostgreSQL, and third-party sources into Snowflake using Airbyte and Streamkap, including incident recovery.
• Move data delivery from batch toward near-real-time using Snowflake dynamic tables, incremental dbt models, and orchestration redesign.
• Design and maintain layered dbt models across product domains, ensuring correct history, grain, reconciliation, and performance.
• Develop multi-tenant Snowflake Secure Data Sharing and Apache Iceberg sharing across customer platforms, including tenant isolation, cross-region and cross-cloud fulfillment, and schema-change contracts.
• Harden the platform with SLA, freshness, and completeness instrumentation; improve deployments, extend Terraform coverage, and manage warehouse cost and performance.
• Participate in on-call rotations, support product and business teams, manage Snowflake access and governance, review code, write design documents, mentor engineers, and make architecture decisions.

Requirements

• 5+ years of data engineering experience with production pipelines owned end to end.
• Deep Snowflake experience, including warehouse sizing and performance and RBAC; experience with data sharing, dynamic tables, or Iceberg is preferred.
• Strong dbt experience with incremental strategies, testing, layered modeling, and full-refresh tradeoffs.
• Hands-on CDC and ingestion experience with tools such as Airbyte, Debezium, Streamkap, Fivetran, or Kafka, plus understanding of binlogs and replication.
• Production-scale Airflow experience; MWAA is a plus.
• Strong SQL and Python skills and solid AWS fundamentals.
• Experience in a multi-tenant SaaS data environment.
• Calm, methodical incident response and judgment to fix problems at the appropriate layer.
• Clear written communication for design documents and explaining data issues to non-technical stakeholders.

Nice to have

• Experience with event-sourced systems.
• Embedded BI experience with Sigma or similar tools, including row-level security.
• Terraform experience for Snowflake or other data infrastructure.
• Experience with data catalog and governance tools such as Secoda, lineage, and data contracts.
• Real-time analytics architecture experience and understanding of cost tradeoffs.
• Use of AI coding tools such as Claude Code in daily work.

Culture & Benefits

• Hybrid work schedules at hubs in Los Angeles, San Francisco, Toronto, and Raleigh.
• Generous equity grant, comprehensive benefits, flexible PTO, and a one-time work-from-home allowance.
• Lunch is provided for in-office days.
• Company events and team-building activities are held in person and virtually.
• Fast-paced, collaborative environment with opportunities for growth and career advancement.