Staff Data Engineer

Coalition Technologies

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

Posted 11/3/2026full-timeRemote • United StatesLead💰 $157,000 - $232,650 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates extensive expertise in building and operating production data platforms, with a focus on Snowflake and dbt for performance optimization and data modeling. Capable of establishing data governance, quality standards, and scalable infrastructure for AI/ML applications and analytics.

Highest-signal resume keywords

Snowflake ExpertiseData Modeling in PythonBuilding Streaming PipelinesProduction Experience with LookerEstablishing Data Governance

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 ArchitecturePerformance OptimizationIncremental ProcessingDimensional ModelingFeature EngineeringBatch ELTStreaming ELTAnalytical SQLData Vault 2.0RBAC Implementation

Soft Skills

Mentoring EngineersCommunicating TradeoffsInfluencing Architecture

Tools & Technologies

DbtAirflowKafkaLookerTerraformGitHub ActionsCursorGitHub CopilotSnowpipe StreamingDynamic Tables

Industry Keywords

CybersecurityInsurance Exposure AnalyticsActuarial WorkflowsAI/ML ProductsData ContractsDomain OwnershipQuality StandardsPII TokenizationAudit LoggingRegulated Data Controls

Tech Stack

Tools & technologies

AirflowCyber SecurityKafkaPythonSnowflakeSQLTerraformVault

About the role

Key responsibilities & impact

Define the architecture and technical direction of Coalition’s enterprise Data & Analytics platform
Build trusted, scalable data infrastructure for cybersecurity, 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
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

Benefits

Comp & perks

100% medical, dental, and vision coverage
401(k) retirement plan with competitive employer match
Flexible PTO
Up to 14 weeks of paid leave for birthing parents and 8 weeks of paid parental leave for non-birthing parents
Annual home office stipend and WeWork access
Mental & physical health wellness programs like One Medical, Headspace, Wellhub, and more!
Competitive compensation and opportunity for advancement
Remote-first culture