Back to jobs

Staff Data Engineer

Pay
Multiple pay statements — pay source
As a remote-first organization, our compensation reflects the cost of labor across several Canadian geographic markets. In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year. For all other locations, the base salary for this position ranges from $142,600/year up to $200,000/year.
In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year. For all other locations, the base salary for this position ranges from $142,600/year up to $200,000/year. Consistent with applicable laws, an employee's pay within this range is based on a number of factors, which include but are not limited to relevant education, skills, job-related knowledge, qualifications, work experience, credentials, and/or geographic location. Your Recruiter can share more on the specific target salary range for your location during the interview process. Coalition, Inc. reserves the right to modify this range as needed.
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting

As a Staff Data Engineer on Coalition’s Data team, you will define the architecture and technical direction of the enterprise Data & Analytics platform.

  • Set architecture and engineering standards for Snowflake, dbt, orchestration and streaming

  • Design governed Medallion pipelines and domain-oriented data models

  • Build reusable data products, contracts, feature stores and semantic models

  • Establish observability, quality, lineage and security practices for regulated workflows

  • Develop platform foundations for feature engineering, embeddings and vector search

From the employer’s posting
As a Staff Data Engineer on Coalition’s Data team, you will define the architecture and technical direction of the enterprise Data & Analytics platform. You will build trusted, scalable data infrastructure for cyber security, insurance exposure analytics, BI, actuarial workflows, and AI/ML products. Your work will help Coalition make better risk decisions, deliver reliable data products, and scale its mission to Protect the Unprotected.
Set the architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code across the Data platform.
Design governed Medallion pipelines and domain-oriented data models
Build reusable data products, contracts, feature stores, and semantic models that serve BI, actuarial, AI/ML, and operational consumers.
Establish observability, quality, lineage, security, and incident-management practices that protect data reliability and support regulated workflows.
Develop the platform foundations for feature engineering, embeddings, vector search, and retrieval-augmented AI applications.

Benefits in the posting

Full benefits wording
  • 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
  • Privacy Notice
  • Coalition is committed to protecting your privacy and handling your personal information responsibly. We collect, use, and store personal information as necessary for the recruitment process and in compliance with applicable privacy laws and regulations in all regions where we operate. We want you to understand what personal information we collect, how we use it, and your rights regarding access, correction, and deletion of your data where applicable. Information submitted, collected, and processed as part of your application is subject to Coalition's Privacy Policy. For further details, please review our full Privacy Policy or contact us with any questions regarding how your information is handled.
  • Safe Hiring Notice
  • All legitimate communication from Coalition comes from @coalitioninc.com emails, and open roles are listed only on our Careers page. We never ask for payment, banking details, or personal identification before an offer is accepted through our secure systems. If you believe you’ve been a victim of fraudulent recruiting, follow guidance from the Federal Trade Commission (FTC).
  • Anti-Discrimination Notice

From the employer’s posting.

About Coalition

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

In the employer’s words · Read in context

Apply at Coalition

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 1, 202633 days ago
Recorded sightings
32
Last seen by us
Nov 4, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 33

Similar jobs usually come down between day 5 and day 54.

From 10,703 similar postings that came down. Coming down is not always a hire.

Coalition is hiring

5 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Takes jobs down at a usual pace
  • 20% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • dbt
  • Kafka
  • Looker
  • Prefect
  • Snowflake
  • Terraform
  • Airflow
  • Dagster
Where the posting names them
- 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.
Responsibilities - Set the architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code across the Data platform. - Design governed Medallion pipelines and domain-oriented data models that make complex insurance and security data reliable, discoverable, and usable.
- 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 modeling insurance domains such as underwriting, claims, reinsurance, policy exposure, loss runs, or loss triangles. - Familiarity with Snowflake Cortex, Feast, DataHub, Atlan, OpenLineage, Elementary, dbt-expectations, or Evidently AI. - Experience implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls.
- 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. - A strong technical leadership mindset, with experience influencing architecture across teams, mentoring engineers, communicating tradeoffs, and creating durable engineering standards.
- Experience implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls. - Experience managing Snowflake environments with Terraform and CI/CD tools such as GitHub Actions. - Experience using AI-assisted development tools such as Cursor or GitHub Copilot to improve code quality, testing, and documentation.

Your next step

Complete your application on www.coalitioninc.com. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Has Coalition posted this job before?

Yes. We’ve followed one other Staff Data Engineer job there since October 2026. It is still up.

  1. Place not statedStill up after 34 days, first seen Oct 1
  2. This jobUp 34 days so far, first seen Oct 1

Job description

View original posting ↗

About us

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.   

Opportunities to make an impact with bold thinking are real—and happening daily at Coalition.

About the role

As a Staff Data Engineer on Coalition’s Data team, you will define the architecture and technical direction of the enterprise Data & Analytics platform. You will build trusted, scalable data infrastructure for cyber security, insurance exposure analytics, BI, actuarial workflows, and AI/ML products. Your work will help Coalition make better risk decisions, deliver reliable data products, and scale its mission to Protect the Unprotected.

Responsibilities

  • Set the architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code across the Data platform.
  • Design governed Medallion pipelines and domain-oriented data models that make complex insurance and security data reliable, discoverable, and usable.
  • Build reusable data products, contracts, feature stores, and semantic models that serve BI, actuarial, AI/ML, and operational consumers.
  • Establish observability, quality, lineage, security, and incident-management practices that protect data reliability and support regulated workflows.
  • Develop the 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 customer and business outcomes.

Skills and Qualifications

  • 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.
  • A strong technical leadership mindset, with experience influencing architecture across teams, mentoring engineers, communicating tradeoffs, and creating durable engineering standards.

Bonus Points 

  • Experience modeling insurance domains such as underwriting, claims, reinsurance, policy exposure, loss runs, or loss triangles.
  • Familiarity with Snowflake Cortex, Feast, DataHub, Atlan, OpenLineage, Elementary, dbt-expectations, or Evidently AI.
  • Experience implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls.
  • Experience managing Snowflake environments with Terraform and CI/CD tools such as GitHub Actions.
  • Experience using AI-assisted development tools such as Cursor or GitHub Copilot to improve code quality, testing, and documentation.

Compensation

As a remote-first organization, our compensation reflects the cost of labor across several Canadian geographic markets. 

In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year. 

For all other locations, the base salary for this position ranges from $142,600/year up to $200,000/year. 

Consistent with applicable laws, an employee's pay within this range is based on a number of factors, which include but are not limited to relevant education, skills, job-related knowledge, qualifications, work experience, credentials, and/or geographic location. Your Recruiter can share more on the specific target salary range for your location during the interview process. Coalition, Inc. reserves the right to modify this range as needed.

Vacancy Status: This posting is for an existing vacancy.

Use of AI: We utilize AI-assisted tools to help us organize and review the high volume of applications we receive. However, our human recruiting team makes all final hiring decisions and interview selections, valuing personal connection over algorithms.

Application Updates: Consistent with our commitment to transparency, if you are interviewed for this role, we will provide a status update on your application within 45 days of your final interview.

Perks

  • 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

Why Coalition? 

Work at Coalition is centered on the joint mission to Protect the Unprotected. We have built a remote-first, highly inclusive culture that welcomes people from diverse backgrounds. We trust each other to take responsibility, share ownership of outcomes, and put in the work together to protect businesses from digital risk. Coalition’s exceptional growth stems from its ability to address real-world problems for organizations of all sizes while remaining true to our founding values of character, humility, responsibility, purpose, authenticity, and inclusion.

We’re always looking for collaborative, inquisitive individuals to join #OurCoalition.

Visit our Newsroom > 

Privacy Notice

Coalition is committed to protecting your privacy and handling your personal information responsibly. We collect, use, and store personal information as necessary for the recruitment process and in compliance with applicable privacy laws and regulations in all regions where we operate. We want you to understand what personal information we collect, how we use it, and your rights regarding access, correction, and deletion of your data where applicable. Information submitted, collected, and processed as part of your application is subject to Coalition's Privacy Policy. For further details, please review our full Privacy Policy or contact us with any questions regarding how your information is handled.

Our Privacy Policy > 

Safe Hiring Notice

All legitimate communication from Coalition comes from @coalitioninc.com emails, and open roles are listed only on our Careers page. We never ask for payment, banking details, or personal identification before an offer is accepted through our secure systems. If you believe you’ve been a victim of fraudulent recruiting, follow guidance from the Federal Trade Commission (FTC).

Anti-Discrimination Notice

Coalition is proud to be an Equal Opportunity employer. Our policy is to provide equal employment opportunities to all individuals, without discrimination or harassment on the basis of any characteristic protected by applicable laws in each country where we operate. This commitment includes, but is not limited to, ensuring equal treatment in recruitment, selection, training, promotion, transfer, compensation, and all other aspects of employment. Coalition does not tolerate discrimination or harassment of any kind, and we are dedicated to fostering an inclusive and supportive workplace.

Accommodations

Coalition is committed to providing reasonable accommodations to qualified individuals with disabilities, including applicants and employees, in accordance with applicable laws and regulations in each country where we operate. Our policy is to support equal opportunity in the hiring process by considering qualified applicants regardless of disability or other protected characteristics, unless providing accommodation would impose an undue hardship or disproportionate burden. If you require accommodation to complete an application, interview, pre-employment testing, or participate in the selection process, please contact us at candidateaccommodations@coalitioninc.com. We also consider all qualified applicants, including those with criminal histories, in line with applicable laws and regulations in each jurisdiction.

To all recruitment agencies: Coalition does not accept unsolicited agency resumes. Do not forward resumes to our email alias, employees, or other physical or virtual organization locations. Coalition is not responsible for any fees related to unsolicited resumes.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
As a remote-first organization, our compensation reflects the cost of labor across several Canadian geographic markets. In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year. For all other locations, the base salary for this position ranges from $142,600/year up to $200,000/year.
More source context
In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year. For all other locations, the base salary for this position ranges from $142,600/year up to $200,000/year. Consistent with applicable laws, an employee's pay within this range is based on a number of factors, which include but are not limited to relevant education, skills, job-related knowledge, qualifications, work experience, credentials, and/or geographic location. Your Recruiter can share more on the specific target salary range for your location during the interview process. Coalition, Inc. reserves the right to modify this range as needed.
Location & working pattern

Any location, Canada

Compensation As a remote-first organization, our compensation reflects the cost of labor across several Canadian geographic markets. In Alberta, British Columbia & Ontario the base salary for this position ranges from $158,000/year up to $218,000/year.
More source context
Why Coalition? Work at Coalition is centered on the joint mission to Protect the Unprotected. We have built a remote-first, highly inclusive culture that welcomes people from diverse backgrounds. We trust each other to take responsibility, share ownership of outcomes, and put in the work together to protect businesses from digital risk. Coalition’s exceptional growth stems from its ability to address real-world problems for organizations of all sizes while remaining true to our founding values of character, humility, responsibility, purpose, authenticity, and inclusion. We’re always looking for collaborative, inquisitive individuals to join #OurCoalition.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.