Analytics Engineer at Coalition

San Francisco, California, United States

Apply Now

Not SpecifiedCompensation

Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

AI, TechnologyIndustries

Requirements

4+ years in a data engineering, data science, or full-stack data role
Expert SQL and strong Python (or R)
Experience with data modeling, warehouse architecture, and BI-oriented schema design
Hands-on experience with ETL/ELT tools (dbt, Airflow, Dagster, etc.)
Experience building or maintaining BI reporting (Metabase a plus)
Strong knowledge of statistics and experimentation
Based in SF or NYC

Responsibilities

Design and manage database architecture and data models
Build and maintain ETL/ELT pipelines and orchestration workflows
Create and manage new data integrations across internal and external systems
Own business reporting: datasets, dashboards, metrics, and self-serve analytics
Ensure data quality, observability, governance, and documentation

Skills

Key technologies and capabilities for this role

SQLPythondata modelingwarehouse architectureETLELTdbtAirflowDagsterBI reportingMetabasestatisticsexperimentation

Questions & Answers

Common questions about this position

What experience level is required for this Analytics Engineer role?

The role requires 4+ years in a data engineering, data science, or full-stack data role.

What are the key technical skills needed for this position?

Key skills include expert SQL and strong Python (or R), experience with data modeling, warehouse architecture, BI-oriented schema design, ETL/ELT tools like dbt, Airflow, Dagster, and building BI reporting with tools like Metabase.

Is this role remote or onsite, and where is it based?

This is an onsite role, and candidates must be based in SF or NYC.

What is the team like at Cognition?

The team is small and talent-dense, featuring world-class competitive programmers, former founders, and leaders from top AI companies like Scale AI, Cursor, Waymo, Tesla, Google DeepMind, and Nuro.

What makes a strong candidate for this Analytics Engineer position?

Strong candidates have 4+ years of relevant experience, expert SQL and Python skills, hands-on work with ETL/ELT tools and BI reporting, strong statistics knowledge, and are based in SF or NYC.

Coalition

Active insurance and cybersecurity risk management

About Coalition

Coalition provides Active Insurance, which combines insurance coverage with cybersecurity tools to help businesses prevent digital risks. Their main product, Coalition Control, is a platform that offers automated cyber alerts, expert guidance, and third-party risk management to help businesses manage potential cyber attacks. Coalition stands out from competitors by integrating insurance with proactive cybersecurity measures, rather than just offering reactive coverage. The company's goal is to empower businesses to mitigate cyber threats effectively and enhance their overall security posture.

San Francisco, CaliforniaHeadquarters

2017Year Founded

$749MTotal Funding

SERIES_FCompany Stage

Cybersecurity, Financial ServicesIndustries

501-1,000Employees

Benefits

Enjoy a highly fulfilling, mission-driven culture

Health, dental, and vision benefits for you and your family

Life insurance and disability benefits

Paid parental leave

401(k) plan

Wellness and commuter benefits

Flexible working hours

Open vacation days

We embrace distributed work; some benefits will vary by location

You are an owner. We offer stock options to each of our employees

Risks

Integration challenges from Jumbo acquisition may divert focus from core operations.

Increased competition from Hawk AI could impact Coalition's market share.

Regulatory scrutiny from insurance carrier acquisition may affect operational efficiency.

Differentiation

Coalition is the first Active Insurance provider, integrating insurance with cybersecurity tools.

Coalition Control offers automated cyber alerts and third-party risk management globally.

Coalition Security Labs provides cybersecurity education and insights to policyholders and the security community.

Upsides

Coalition raised $250 million in Series F funding, boosting growth potential.

Acquisition of Jumbo enhances Coalition's B2B cyber insurance capabilities.

Rising cyber threats increase demand for Coalition's comprehensive cyber insurance solutions.

Land your dream remote job 3x faster with AI

Try Jobo Free