1 day ago
Toronto, CanadaSenior
Base Salary
$120k - $197k/yr
Responsibilities
- Own CDC ingestion pipelines from MySQL and Postgres into Snowflake using Airbyte, Streamkap, and other third-party sources.
- Develop and maintain layered dbt models with strong attention to history, grain, correctness, and reconciliation.
- Improve data latency through Snowflake dynamic tables, incremental dbt strategies, and orchestration redesign.
- Evolve Snowflake Secure Data Sharing and Apache Iceberg-based customer data sharing across tenants, regions, and clouds.
- Build SLA, freshness, completeness, deployment, governance, cost, and performance capabilities for the data platform.
- Participate in a full-sprint on-call rotation covering pipeline incidents, data-share fulfillment, report breakages, and data accuracy escalations.
- Support product, Finance, Customer Success, Revenue Operations, and Marketing teams with data delivery and analytics needs.
- Handle Snowflake access, roles, and governance alongside DevOps and IT.
- Write design documents, review code, mentor engineers, and make durable architecture decisions.
Requirements
- At least 5 years of data engineering experience with end-to-end ownership of production pipelines.
- Deep Snowflake experience, including warehouse sizing, performance, RBAC, and ideally data sharing, dynamic tables, or Iceberg.
- Strong dbt experience with incremental strategies, testing, layered modeling, and full-refresh judgment.
- Hands-on CDC and ingestion experience with tools such as Airbyte, Debezium, Streamkap, Fivetran, or Kafka, plus knowledge of binlogs and replication.
- Production-scale Airflow experience; MWAA experience is preferred.
- Strong SQL and Python skills and solid AWS fundamentals.
- Experience working in a multi-tenant SaaS data environment.
- Calm, methodical incident response and sound judgment about fixing problems at the appropriate layer.
- Clear written communication for design documents and nontechnical data issue explanations.
- Preferred experience includes event-sourced systems, embedded BI such as Sigma, row-level security, Terraform for data infrastructure, data catalogs, lineage, data contracts, real-time analytics architecture, and AI coding tools such as Claude Code.
Benefits
- Generous equity grant, comprehensive benefits, flexible PTO, and a one-time work-from-home allowance.
- Hybrid work schedules with hubs in Los Angeles, San Francisco, Toronto, and Raleigh; lunch is provided on in-office days.
- Company events and team-building activities are offered both in person and virtually.
- The company offers growth and career advancement opportunities.
- Applicants are welcomed across supported U.S. locations, excluding Alaska, Hawaii, Kentucky, Mississippi, Nebraska, New Mexico, North Dakota, Rhode Island, South Dakota, West Virginia, and Wyoming.
Tech Stack
Categories
Data Engineering
About BuildOps
BuildOps provides an all-in-one SaaS platform for commercial specialty contractors to manage service and project workflows—quoting, scheduling/dispatch, field mobile, inventory, invoicing, and financial reporting—in a single system. The subscription-based product integrates with accounting/ERP tools and includes an AI layer (OpsAI) for dispatch and office tasks. Founded in 2018 and headquartered in Santa Monica, CA, it serves commercial trades across North America.