Note: The job is a remote job and is open to candidates in USA. Coalition is the world's first Active Insurance provider designed to help prevent digital risk before it strikes. They are seeking a Data Engineer to build their data platform across the Cyber Security value chain, focusing on transforming raw data into high-performance data products and supporting stakeholders with Cyber Security related data needs.
Responsibilities
- Design and implement robust Star Schema models within a Medallion Architecture (Bronze/Silver/Gold) to support complex Cyber Insurance and Cyber Security analytics
- Build scalable ELT pipelines using Snowflake and dbt, ensuring high data quality and observability
- Define and implement critical SLIs—specifically around data freshness, volume, and schema integrity. Build automated alerting to ensure SLOs are met
- Develop and maintain the LookML semantic layer for business stakeholders
- Implement data masking, RBAC, and secure data handling practices
- Act as a technical peer helping the team level up through Code Reviews and sharing dbt/Python best practices
- Build feature stores and data foundations for AI-driven risk scoring and automated underwriting
Skills
- Design and implement robust Star Schema models within a Medallion Architecture (Bronze/Silver/Gold) to support complex Cyber Insurance and Cyber Security analytics
- Build scalable ELT pipelines using Snowflake and dbt, ensuring high data quality and observability
- Define and implement critical SLIs—specifically around data freshness, volume, and schema integrity. Build automated alerting to ensure SLOs are met
- Develop and maintain the LookML semantic layer for business stakeholders
- Implement data masking, RBAC, and secure data handling practices
- Act as a technical peer helping the team level up through Code Reviews and sharing dbt/Python best practices
- Build feature stores and data foundations for AI-driven risk scoring and automated underwriting
- 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
Benefits
- 100% medical, dental and vision coverage
- Flexible PTO policy
- Annual home office stipend and WeWork access
- Mental & physical health wellness programs (One Medical, Headspace, Wellhub, and more)!
Company Overview
Company H1B Sponsorship