Software Engineer - Data

Authentic; New York (NY); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

Comprehensive health benefits

401(k) plan with company match

Unlimited PTO

Paid parental leave

Job summary

Authentic is seeking a Data Pipeline Engineer to design and maintain data pipelines and infrastructure for underwriting and reporting. Ideal candidates will have 3-5 years of experience in data management and proficiency in tools like Snowflake and dbt.

The role offers competitive salary, health benefits, and an inclusive work environment. Authentic is a growing company committed to innovation in the insurance industry, actively contributing to customized insurance solutions.

Qualifications

• 3-5 years of experience building and maintaining data pipelines and infrastructure in production environments.
• Strong proficiency with modern data stack tools, including Snowflake, dbt, and similar orchestration tools.
• Experience with Python for data processing and pipeline development.
• Solid understanding of data modeling best practices.
• Familiarity with AWS data services and infrastructure-as-code.

Responsibilities

• Design and build reliable data pipelines for underwriting models and processing.
• Own data models end-to-end, ensuring data quality and accessibility.
• Identify bottlenecks and implement solutions improving reliability and scaling.
• Build and maintain the data warehouse architecture.
• Collaborate with engineering and product teams to understand data needs.
• Implement monitoring and data quality checks.

Skills

Data pipeline management

Snowflake

dbt

Airflow

Python

AWS data services

Data modeling best practices

Infrastructure as code

Job description

Authentic helps insurance brokers create better insurance products for their clients. We provide the technology platform and behind-the-scenes support that lets brokers build custom insurance solutions for specific industries or customer groups. Think of us as the operating system that powers these specialized insurance offerings. For brokers, this means they can offer unique products their competitors don't have, earn more money, and spend less time on paperwork and administrative tasks. We handle the complex (technology, compliance, and partnerships with highly-rated insurance carriers), so they can focus on serving their customers and growing their business.

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

Experience

• 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

Benefits

• Competitive salary, equity, and role trajectory
• Comprehensive health benefits for you and your family
• 401(k) plan with company match
• Unlimited PTO
• Paid parental leave

About Authentic

Authentic builds the infrastructure that program insurance runs on. We partner with leading brokerages to design and manage custom insurance programs, backed by A and A- rated carriers operating nationwide. Brokers bring the data and distribution. We bring everything else: the technology, the capacity, and the underwriting expertise to stand up specialized programs at speed and build them to last. We’re a Series A company backed by top investors, including FirstMark Capital, Zigg Capital, Slow Ventures, Clocktower, Commerce Ventures, and Altai. We’ve grown over 15x in the past year with a massive market opportunity ahead.

Authentic is committed to building an inclusive working environment regardless of gender, sexual orientation, religion, ethnicity, race, education, age, or other personal characteristics. We believe that people do their best work when they can be themselves, and different perspectives and experiences make us stronger as a team. We’re proud of the supportive and inclusive workplace we're building together and are always working to make it even better.