Staff Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Define the architectural framework and technical strategy for Coalition’s enterprise Data & Analytics platform.

• Construct reliable and scalable data infrastructure for cybersecurity, insurance exposure analytics, BI, actuarial workflows, and AI/ML products.

• Establish architecture and engineering standards for Snowflake, dbt, orchestration, streaming, batch ELT, and infrastructure-as-code.

• Design governed Medallion pipelines and domain-focused data models.

• Create reusable data products, contracts, feature stores, and semantic models for BI, actuarial, AI/ML, and operational users.

• Implement observability, quality, lineage, security, and incident-management practices.

• Develop foundational platform elements for feature engineering, embeddings, vector search, and retrieval-augmented AI applications.

• Collaborate with engineering, product, underwriting, actuarial, security, and business teams to ensure architectural alignment with outcomes.

⛳️ Requirements

• 9–12 years of experience in building and managing production data platforms, with a proven track record of owning architecture for complex or high-scale systems.

• Extensive expertise in Snowflake and dbt, including performance optimization, incremental processing, warehouse cost management, testing, and deployment practices.

• Strong programming and data modeling capabilities in Python and analytical SQL, with experience in designing dimensional models and/or Data Vault 2.0 architectures.

• Proven experience in constructing reliable batch and streaming pipelines using modern orchestration and ingestion technologies such as Airflow, Dagster, Prefect, Kafka, Kinesis, Snowpipe Streaming, or Dynamic Tables.

• Experience in establishing data products, data contracts, domain ownership, SLAs, access controls, lineage, and quality standards across various teams.

• Background in building feature engineering infrastructure or AI data systems, including feature stores, embeddings, vector search, or RAG pipelines.

• Hands-on experience with Looker and LookML, including governed semantic models and centralized metrics for self-service analytics.

• Proven ability to influence architecture across teams, mentor engineers, communicate trade-offs, and establish durable engineering standards.

• Experience in modeling insurance domains such as underwriting, claims, reinsurance, policy exposure, loss runs, or loss triangles.

• Familiarity with tools like Snowflake Cortex, Feast, DataHub, Atlan, OpenLineage, Elementary, dbt-expectations, or Evidently AI.

• Experience in implementing RBAC hierarchies, row-level policies, column masking, PII tokenization, audit logging, or regulated-data controls.

• Experience managing Snowflake environments using Terraform and CI/CD tools such as GitHub Actions.

• Familiarity with AI-assisted development tools such as Cursor or GitHub Copilot.

🏝️ Benefits

• 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 such as One Medical, Headspace, Wellhub, and more!

• Competitive compensation and opportunities for advancement.

• Remote-first culture.