Staff Data Engineer

Coalition Technologies

. Define the architecture and technical direction of the enterprise Data & Analytics platform .

Posted 11/3/2026full-timeRemote • CanadaLead💰 CA$142,600 - CA$218,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and operating scalable data platforms, with a focus on architecture, data modeling, and feature engineering for AI/ML applications. Proficient in establishing data governance, quality standards, and collaborating across teams to align technical solutions with business outcomes.

Highest-signal resume keywords

Snowflake ExpertiseData Modeling in PythonBuilding Streaming PipelinesLooker and LookML ExperienceData Governance Practices

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ArchitectureDimensional ModelingIncremental ProcessingPerformance OptimizationFeature EngineeringBatch ELTAnalytical SQLData Vault 2.0RBAC ImplementationIncident Management

Soft Skills

Mentoring EngineersInfluencing ArchitectureCommunicating Tradeoffs

Tools & Technologies

DbtAirflowKafkaKinesisLookerTerraformGitHub ActionsSnowpipe StreamingCursorGitHub Copilot

Industry Keywords

Cyber SecurityInsurance Exposure AnalyticsActuarial WorkflowsAI/ML ProductsData ContractsDomain OwnershipQuality StandardsPII TokenizationRegulated Data ControlsInsurance Domains

Tech Stack

Tools & technologies

AirflowCyber SecurityKafkaPythonSnowflakeSQLTerraformVault

About the role

Key responsibilities & impact

Define the architecture and technical direction of the enterprise Data & Analytics platform
Build trusted, scalable data infrastructure for cyber security, insurance exposure analytics, BI, actuarial workflows, and AI/ML products
Set architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code
Design governed Medallion pipelines and domain-oriented data models
Build reusable data products, contracts, feature stores, and semantic models for BI, actuarial, AI/ML, and operational consumers
Establish observability, quality, lineage, security, and incident-management practices
Develop 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 outcomes

Requirements

What you’ll need

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
Experience influencing architecture across teams, mentoring engineers, communicating tradeoffs, and creating durable engineering standards
Bonus: Experience modeling insurance domains such as underwriting, claims, reinsurance, policy exposure, loss runs, or loss triangles
Bonus: Familiarity with Snowflake Cortex, Feast, DataHub, Atlan, OpenLineage, Elementary, dbt-expectations, or Evidently AI
Bonus: Experience implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls
Bonus: Experience managing Snowflake environments with Terraform and CI/CD tools such as GitHub Actions
Bonus: Experience using AI-assisted development tools such as Cursor or GitHub Copilot
The posting states that pay may reflect relevant education, skills, qualifications, work experience, and credentials

Benefits

Comp & 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