Software Engineer - Data

Authentic is a technology platform that supports insurance brokers in creating tailored insurance products for their clients. The Software Engineer - Data will be responsible for designing and building data pipelines, ensuring data quality, and collaborating with various teams to meet data needs.

Responsibilities

Design and build reliable data pipelines and infrastructure that power underwriting models, claims processing, and operational reporting

Own data models end-to-end—from source ingestion through transformation to delivery—ensuring data quality, freshness, and accessibility for internal teams, product features, and external partners

Identify bottlenecks in existing data workflows and implement solutions that improve reliability, reduce latency, and scale with business growth

Build and maintain the data warehouse architecture, optimizing for both analytical workloads and operational use cases

Partner with engineering, product, and ops teams to understand data needs and translate them into well-designed pipelines and models

Implement monitoring, alerting, and data quality checks to catch issues before they impact downstream consumers

Contribute to data governance practices, including documentation, lineage tracking, and access controls for regulatory and compliance needs

Benefits

Equity

Role trajectory

Comprehensive health benefits for you and your family

401(k) plan with company match

Unlimited PTO

Paid parental leave

Company

End-to-end specialty insurance program management infrastructure

New York, New York, USA

https://authenticinsurance.com/

Founded in 2022

51-200 employees

Qualifications

3-5 years of experience building and maintaining data pipelines and infrastructure in production environments

Strong proficiency with modern data stack tools: Snowflake, dbt, and Airflow (or similar orchestration tools)

Experience with Python for data processing and pipeline development

Solid understanding of data modeling best practices (dimensional modeling, slowly changing dimensions, etc.)

Familiarity with AWS data services and infrastructure-as-code

Demonstrated ownership mindset: you clarify requirements, ask great questions, and drive work to completion

Track record of building reliable systems without sacrificing velocity—you know when to move fast and when to be careful

Required skills

Data pipeline development, Data infrastructure, Underwriting models, Claims processing, Operational reporting, Data modeling, Dimensional modeling, Slowly changing dimensions, Snowflake, dbt, Airflow, Python, AWS data services, Infrastructure-as-code

Preferred skills

Ownership mindset

Experience

3-5 years