TL;DR

Data Engineer, Security (Cybersecurity): Building a data platform across the Cyber Security value chain, transforming raw data into high-performance data products with an accent on data quality, observability, and security. Focus on designing robust Star Schema models, building scalable ELT pipelines using Snowflake and dbt, and enabling AI-driven risk scoring.

Location: Remote (Canada)

Salary: $103,800.00 - $144,100.00/year (based on location)

Company

Coalition is the world's first Active Insurance provider designed to help prevent digital risk before it strikes.

What you will do

  • Design and implement robust Star Schema models within a Medallion Architecture (Bronze/Silver/Gold).
  • Build scalable ELT pipelines using Snowflake and dbt, ensuring high data quality and observability.
  • Define and implement critical SLIs around data freshness, volume, and schema integrity; build automated alerting.
  • Develop and maintain the LookML semantic layer for business stakeholders.
  • Implement data masking, RBAC, and secure data handling practices.
  • Build feature stores and data foundations for AI-driven risk scoring and automated underwriting.

Requirements

  • Experience with Looker (LookML).
  • Active user of Cursor or other AI-assisted coding environments.
  • Prior experience in Cybersecurity or Cyber Insurance.
  • Experience building data foundations for AI Agents.

Culture & Benefits

  • 100% medical, dental, and vision coverage.
  • Flexible PTO.
  • Annual home office stipend and WeWork access.
  • Mental & physical health wellness programs.
  • Competitive compensation and opportunity for advancement.
  • Remote-first, highly inclusive culture.