Remote Data Engineer — Pipelines, Modeling & Reliability

Reserv; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health insurance

401(k) plan with employer matching

Competitive PTO policy

Generous family leave policy

Work from anywhere

Apple laptop, large monitor

Job summary

Reserv is seeking an experienced data engineer to design, build, and maintain scalable data pipelines across applications, APIs, databases, and external partners. You will develop data models for analytics and downstream applications while improving performance and reducing costs.

The role requires 6+ years of hands-on experience with SQL and Python, experience with Snowflake/BigQuery/Redshift, and strong data modeling skills.

Qualifications

• 6+ years of experience designing, building, and maintaining production data pipelines and platforms.
• Strong SQL and Python skills, including 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.

Responsibilities

• 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.

Skills

SQL

Python

Communication

Ownership

Problem solving

Tools

dbt

Airflow

Dagster

Snowflake

BigQuery

Redshift

Job description

Reserv is seeking an experienced data engineer to design, build, and maintain scalable data pipelines across applications, APIs, databases, and external partners. You will develop data models for analytics and downstream applications while improving performance and reducing costs.

The role requires 6+ years of hands-on experience with SQL and Python, experience with Snowflake/BigQuery/Redshift, and strong data modeling skills.