Coalition
Posted 1w ago

Data Engineer, Security

Coalition
Alberta or British Columbia or Ontario or Canada or United States
$104k-$144k/yrRemoteFull Time
Responsibilities
  • designing models
  • building pipelines
  • monitoring SLIs
Requirements
  • Experience building ELT pipelines and Medallion Architecture on Snowflake using dbt
  • Looker/LookML
  • Python
  • Cybersecurity or cyber insurance experience and AI/ML data foundations
  • Strong data modeling and observability skills
Technical tools mentioned
SnowflakedbtLookerLookMLCursorPython

Job description

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

We are hiring a Data Engineer to build our data platform across our Cyber Security value chain. This includes Security and Sales management. You will be the go-to partner for Stakeholders, Research team and Data Science team requiring Cyber Security related Data.

As a Data Engineer, 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, utilizing dbt to ensure our data is clean, modeled, and ready for both business intelligence in Looker and advanced AI/ML applications.

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—specifically 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

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 $115,300/year up to $144,100/year. 

For all other locations, the base salary for this position ranges from $103,800/year up to $129,690/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 [email protected]. 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.

About Coalition

Provides cyber insurance with proactive digital risk management tools

Year founded
2017
Employees
733
Organization type
Private
Latest investment
Raised $30.00M Funding Round (2025) — led by Allianz X, Valor Equity Partners
Headquarters
US

Similar jobs

Data Engineer roles in Alberta
10h
Save
Mark Applied
Hide
Senior Data Engineer
Toronto, Ontario, Canada
$120k-$145k/yr HybridFull Time
Konrad Group
Konrad Group: Provides digital strategy, design, and software development services.
4+ YOEBachelor's degree or higher in a relevant field and 4+ years of data engineering experience. Requires SQL or Python, data platforms, pipelines, cloud services, big data technologies, and analytical skills.
Azure Fabric, Databricks, Snowflake, SQL, Python, Spark, Hadoop, Kafka, DevOps, CI/CD
18h
Save
Mark Applied
Hide
AWS Data Engineer
Mississauga or Canada
$98k-$110k/yr RemoteFull Time
Cognizant
CognizantNasdaq: CTSH: Provides IT consulting and digital business process services.
5+ YOEBachelor's degree and 5+ years of data engineering experience required, including 3+ years building Databricks solutions on AWS; strong Python, PySpark, Spark SQL, SQL, ETL/ELT, and cloud data platform skills.
Databricks, PySpark, Python, SQL, Delta Lake, AWS, Amazon S3, AWS Glue, AWS Lambda, AWS Identity and Access Management (IAM), Amazon Redshift, Amazon SNS, Amazon SQS, Amazon CloudWatch, Git, Terraform, Jenkins, Azure DevOps, Spark SQL, Unity Catalog
1d
Save
Mark Applied
Hide
Principal Data Engineer
Toronto, Ontario, Canada
$95k-$176k/yr OnsiteFull Time
BMO
BMOTSX: BMO: Provides personal and commercial banking, investment, and wealth services.
15+ YOE15+ years relevant experience, post-secondary education or equivalent, bachelor's degree in computer/data science or engineering, principal engineering experience, and expertise in data architecture, cloud, AI, security, and integration.
Python, Spark, Scala, RAG, MLOps, LLMOps
1d
Save
Mark Applied
Hide
Consultant, Data Developer
Toronto, Ontario, Canada
OnsiteFull Time
CIBC
CIBCToronto Stock Exchange: CM: Provides personal, commercial, and investment banking and wealth management.
7+ YOERequires 7+ years with Databricks, Azure Data Factory, Informatica, Oracle DB, Azure, Python, SQL, CI/CD, GitHub, batch scheduling, and SFTP; bachelor's degree or equivalent and technical leadership experience.
Databricks, Azure Data Factory, Informatica, Oracle Database, Microsoft Azure, Python, SQL, CI/CD, GitHub, AutoSys, SFTP, REST APIs, Databricks Unity Catalog, Informatica Cloud, Informatica PowerExchange
1d
Save
Mark Applied
Hide
Data Engineer
Toronto or Vancouver or Ottawa or Calgary or Halifax or St. John's or Kelowna or Prince George or Montreal or Quebec City
$83k-$93k/yr HybridFull Time
Canadian Cancer Society
Canadian Cancer Society: A national cancer organization funding research, supporting people affected by cancer, and advocating for healthier communities.
3+ YOEBachelor's or master's degree in a relevant computing or data field, 3-5 years of related experience, and proficiency with Microsoft Fabric, Apache Spark, SQL, Python, cloud data platforms, integrations, DevOps, and data governance.
Microsoft Fabric, Apache Spark, SQL, Python, Microsoft Azure, Azure DevOps, Microsoft Purview, Salesforce, Delta Lake, OneLake
1d
Save
Mark Applied
Hide
Data Engineer (270600)
Toronto, Ontario, Canada
OnsiteFull Time
Scotiabank
ScotiabankToronto Stock Exchange: BNS: Provides global personal, commercial, and investment banking services.
4+ YOERequires 4+ years in cloud, lakehouse, data platforms, ETL/ELT, and CI/CD; Azure and Databricks are required, with SQL, Python, Java, Scala, GitHub, Bitbucket, and Terraform experience.
Azure, Azure Data Factory, ADLS, Databricks, Unity Catalog, Auto Loader, SQL, Python, Java, Scala, GitHub, Bitbucket, Terraform, DevOps, Scrum, Product Teams
1d
Save
Mark Applied
Hide
Senior Data Engineer - Krembil Centre for Neuroinformatics
Toronto, Ontario, Canada
$86k-$107k/yr HybridFull Time, Contract
Centre for Addiction and Mental Health
Centre for Addiction and Mental Health: Canada's largest mental health and addiction teaching hospital.
5+ YOEMaster’s or PhD in a relevant technical discipline or equivalent experience; 5+ years in data or ML engineering; Python, SQL, production pipelines, MLOps, cloud, databases, Linux, Git, and CI/CD expertise.
Python, SQL, Docker, Kubernetes, Linux, Git, Microsoft Azure, AWS, Google Cloud, Snowflake, CI/CD, MLOps, ETL/ELT, APIs
2d
Save
Mark Applied
Hide
Senior Data Engineer
Calgary, Alberta, Canada
OnsiteContract
Boardwalk REIT
Boardwalk REITTSX: BEI.UN: Canadian real estate investment trust managing multifamily residential communities.
Expertise in Azure Data Factory, SQL Server, Azure SQL Managed Instance, BI data modeling, Power BI, hybrid networking, migration architecture, ETL optimization, monitoring, and technical leadership.
Azure Data Factory, Mapping Data Flows, Self-Hosted Integration Runtimes, Microsoft SQL Server, SQL Server 2017, Azure SQL Managed Instance, Power BI, VPN gateways, ExpressRoute, VNet