Staff Data Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Define the architecture and technical vision for the enterprise Data & Analytics platform.

• Develop a trusted and scalable data infrastructure for cybersecurity, insurance exposure analytics, business intelligence, actuarial workflows, and AI/ML products.

• Establish architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code.

• Design governed Medallion pipelines and domain-oriented data models.

• Create reusable data products, contracts, feature stores, and semantic models for business intelligence, actuarial, AI/ML, and operational consumers.

• Implement observability, quality, lineage, security, and incident management practices.

• Develop platform foundations for feature engineering, embeddings, vector search, and retrieval-augmented AI applications.

• Collaborate with engineering, product, underwriting, actuarial, security, and business teams to ensure architecture aligns with desired outcomes.

⛳️ Requirements

• 9–12 years of experience in building and operating production data platforms, demonstrating a history of managing architecture for complex or high-scale systems.

• Extensive expertise in Snowflake and dbt, including performance optimization, incremental processing, warehouse cost management, testing, and deployment practices.

• Strong programming and data modeling capabilities in Python and analytical SQL, with a background in designing dimensional models and/or Data Vault 2.0 architectures.

• Experience in creating reliable batch and streaming pipelines using modern orchestration and ingestion technologies such as Airflow, Dagster, Prefect, Kafka, Kinesis, Snowpipe Streaming, or Dynamic Tables.

• Proven experience in establishing data products, data contracts, domain ownership, SLAs, access controls, lineage, and quality standards across multiple teams.

• Background in building feature engineering infrastructure or AI data systems, including feature stores, embeddings, vector search, or RAG pipelines.

• Production experience with Looker and LookML, focusing on governed semantic models and centralized metrics for self-service analytics.

• Ability to influence architecture across teams, mentor engineers, communicate trade-offs, and establish durable engineering standards.

• Bonus: Experience modeling insurance domains such as underwriting, claims, reinsurance, policy exposure, loss runs, or loss triangles.

• Bonus: Familiarity with Snowflake Cortex, Feast, DataHub, Atlan, OpenLineage, Elementary, dbt-expectations, or Evidently AI.

• Bonus: Experience implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls.

• Bonus: Experience managing Snowflake environments using Terraform and CI/CD tools like GitHub Actions.

• Bonus: Experience utilizing AI-assisted development tools such as Cursor or GitHub Copilot.

• The posting indicates that compensation may vary based on relevant education, skills, qualifications, work experience, and credentials.

🏝️ Benefits

• 100% coverage for medical, dental, and vision insurance.

• Flexible paid time off (PTO).

• Annual home office stipend and access to WeWork.

• Mental and physical health wellness programs such as Headspace, Lumino, and more!

• Competitive salary and opportunities for career advancement.