Data Engineer

Reserv; Atlanta (GA); Remote; USD 130,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401(k) retirement plan

Generous PTO

Family leave

Remote-work flexibility

Equipment (Apple laptop + monitor)

Job summary

Reserv is an insurtech focused on AI and automation for claims efficiency. This fully remote role requires 6+ years building data pipelines, strong SQL and Python, and experience with Snowflake/BigQuery/Redshift.

You will own data models, pipelines, tests, and provide trusted datasets for analytics across the business. You’ll collaborate with teams to improve performance, manage costs, and adhere to security practices.

Qualifications

• 6+ years designing, building, and maintaining production data pipelines and platforms.
• Strong SQL and Python with tested, readable code.
• Experience with cloud data warehouses (Snowflake/BigQuery/Redshift).
• Understanding of data modeling (dimensional models, incremental processing).
• Experience with transformation/orchestration tools (dbt, Airflow, Dagster).
• Track record of improving data reliability via testing and monitoring.
• Comfort with APIs and various data formats.
• Strong communication skills and ownership mindset.

Responsibilities

• Design, build, and maintain data pipelines ingesting data from apps, APIs, databases, and partners.
• Develop data models making claims and operational data accessible for analytics.
• Build automated tests, monitoring, and alerts for data quality and pipeline failures.
• Collaborate with business/technical teams to define requirements and trusted datasets.
• Improve pipeline and query performance while managing infrastructure costs.
• Own production workflows, including backfills and recovery from upstream changes.
• Apply engineering practices: version control, code reviews, automated tests, CI/CD.
• Document data sources, transformations, and dependencies; protect sensitive information.

Skills

SQL

Python

Data Modeling

Cloud Warehouses

Data Quality

APIs

Communication

Ownership mindset

Tools

Snowflake

BigQuery

Redshift

dbt

Airflow

Dagster

Job description

Reserv is an insurtech creating and incubating cutting-edge AI and automation technology to bring efficiency and simplicity to claims. Founded by insurtech veterans with deep experience in SaaS and digital claims, Reserv is venture-backed by Bain Capital and Altai Ventures and began operations in May 2022. We are focused on automating highly manual tasks to tackle long-standing problems in claims and set a new standard for TPAs, insurance technology providers, and adjusters alike. We have ambitious (but attainable!) goals and need people who can work in an evolving environment. If building a leading TPA and the prospect of tackling the long-standing challenges of the claims role sounds exciting, we can't wait to meet you.

Location Requirement

Candidates must reside in an eligible U.S. state throughout employment. We are unable to hire candidates residing in California, Alaska, Hawaii, U.S. territories, or outside the United States.

What you will do

• Design, build, and maintain pipelines that ingest data from applications, APIs, databases, and external partners.
• Develop data models that make claims and operational data accessible, consistent, and useful for analytics and downstream applications.
• Build automated tests, monitoring, and alerts to catch data quality issues and pipeline failures early.
• Partner with business and technical teams to define requirements, clarify data definitions, and deliver trusted datasets.
• Improve pipeline and query performance while managing infrastructure costs.
• Own production workflows, including troubleshooting, backfills, and recovery from upstream changes.
• Apply sound engineering practices through version control, code review, automated testing, and CI/CD.
• Document data sources, transformations, and dependencies, and help protect sensitive information through appropriate access controls

Qualifications

• 6+ years of experience designing, building, and maintaining production data pipelines and platforms, with demonstrated ownership of architecture, reliability, and technical decisions.
• Strong SQL and Python skills, including experience writing readable, tested, and maintainable code.
• Experience with a cloud data warehouse such as Snowflake, BigQuery, or Redshift.
• A solid understanding of data modeling, including dimensional models, incremental processing, and changing source data.
• Experience with transformation and orchestration tools such as dbt, Airflow, Dagster, or comparable technologies.
• A track record of improving data reliability through testing, monitoring, and thoughtful system design.
• Comfort working with APIs, relational databases, and structured or semi-structured data.
• Strong communication skills and the ability to explain technical tradeoffs to colleagues with different backgrounds.
• A practical approach to problem-solving, a willingness to learn, and comfort taking ownership as priorities evolve.
• Experience with insurance or claims data, sensitive information, or event-driven systems is a plus.
• Generous health-insurance package with nationwide coverage, vision, & dental
• 401(k) retirement plan with employer matching
• Competitive PTO policy - we want our employees fresh, healthy, happy, and energized!
• Generous family leave policy after 8 months of continuous work
• Work from anywhere to facilitate your work life balance
• Apple laptop, large second monitor, and other quality-of-life equipment you may want. Technology is something that should make your life easier, not harder!

At Reserv, we value diversity in backgrounds, perspectives, and life experiences and believe that diversity in viewpoints and critical thinking drives innovation, first-principles thinking, and success. We welcome applicants from all backgrounds and encourage those from all walks of life to apply.