Data Engineer, Security - Coalition

About Coalition

Coalition is the world's first Active Insurance provider designed to help prevent digital risk before it strikes. Founded in 2017, Coalition combines comprehensive insurance coverage and innovative cybersecurity tools to help businesses manage and mitigate potential cyberattacks.

About the Role

We are hiring a Data Engineer to build our data platform across our Cyber Security value chain, including Security and Sales management. You will be the go-to partner for stakeholders, research, and data science teams requiring cyber security-related data.

In this role, you will design and develop our data lifecycle, transforming raw data into high-performance data products. You will build and scale our Medallion Architecture on Snowflake using dbt to ensure data is clean, modeled, and ready for both business intelligence in Looker and advanced AI/ML applications.

Key Responsibilities

• Data Modeling & Architecture: Design and implement robust Star Schema models within a Medallion Architecture (Bronze/Silver/Gold) to support complex Cyber Insurance and Cyber Security analytics.
• Pipeline Engineering: Build scalable ELT pipelines using Snowflake and dbt, ensuring high data quality and observability.
• Monitoring & Observability: Define and implement critical SLIs around data freshness, volume, and schema integrity. Build automated alerting to ensure SLOs are met.
• BI Enablement: Develop and maintain the LookML semantic layer for business stakeholders.
• Security & Compliance: Implement data masking, RBAC, and secure data handling practices.
• Engineering Excellence & Mentorship: Act as a technical peer helping the team level up through code reviews and sharing dbt/Python best practices.
• AI Integration: Build feature stores and data foundations for AI-driven risk scoring and automated underwriting.

Skills and Qualifications

• BI Tools: Experience with Looker (LookML).
• Modern Tooling: Active user of Cursor or other AI-assisted coding environments.
• Industry Experience: Prior experience in Cybersecurity or Cyber Insurance.
• AI/ML Interest: Experience building data foundations for AI Agents.

Compensation & Benefits

Compensation

Base salary is tailored based on location in Canada:

• Alberta, British Columbia & Ontario: $115,300 - $144,100 CAD/year
• All Other Canadian Locations: $103,800 - $129,690 CAD/year

Perks & Benefits

• 100% medical, dental, and vision coverage
• Flexible PTO
• Annual home office stipend and WeWork access
• Mental & physical health wellness programs (Headspace, Lumino, etc.)
• Competitive compensation and opportunity for career advancement