Staff Data Engineer

The posting, as Coalition wrote it

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, men

[…]
ly 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.