Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Staff Data Engineer defining scalable data architecture for Coalition’s active cyber insurance and cybersecurity platform. Building trusted pipelines, analytics models, and AI/ML data infrastructure.

Responsibilities

  • Define the architecture and technical direction of the enterprise Data & Analytics platform
  • Build trusted, scalable data infrastructure for cyber security, insurance exposure analytics, BI, actuarial workflows, and AI/ML products
  • Set architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code
  • Design governed Medallion pipelines and domain-oriented data models
  • Build reusable data products, contracts, feature stores, and semantic models for BI, actuarial, AI/ML, and operational consumers
  • Establish observability, quality, lineage, security, and incident-management practices
  • Develop platform foundations for feature engineering, embeddings, vector search, and retrieval-augmented AI applications
  • Partner with engineering, product, underwriting, actuarial, security, and business teams to align architecture with outcomes

Requirements

  • 9–12 years of experience building and operating production data platforms, with a track record of owning architecture for complex or high-scale systems
  • Deep expertise in Snowflake and dbt, including performance optimization, incremental processing, warehouse cost management, testing, and deployment practices
  • Strong programming and data modeling skills in Python and analytical SQL, with experience designing dimensional models and/or Data Vault 2.0 architectures
  • Experience building reliable batch and streaming pipelines with modern orchestration and ingestion technologies such as Airflow, Dagster, Prefect, Kafka, Kinesis, Snowpipe Streaming, or Dynamic Tables
  • Experience establishing data products, data contracts, domain ownership, SLAs, access controls, lineage, and quality standards across multiple teams
  • Experience building feature engineering infrastructure or AI data systems, including feature stores, embeddings, vector search, or RAG pipelines
  • Production experience with Looker and LookML, including governed semantic models and centralized metrics for self-service analytics
  • Experience influencing architecture across teams, mentoring engineers, communicating tradeoffs, and creating 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 with Terraform and CI/CD tools such as GitHub Actions
  • Bonus: Experience using AI-assisted development tools such as Cursor or GitHub Copilot
  • The posting states that pay may reflect relevant education, skills, qualifications, work experience, and credentials

Benefits

  • 100% medical, dental, and vision coverage
  • Flexible PTO
  • Annual home office stipend and WeWork access
  • Mental & physical health wellness programs like Headspace, Lumino, and more!
  • Competitive compensation and opportunity for advancement

Job title

Job type

Full Time

Experience level

Lead

Salary

CA$142,600 - CA$218,000 per year

Degree requirement

No Education Requirement

Tech skills

AirflowCyber SecurityKafkaPythonSnowflakeSQLTerraformVault

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.