6+ years of experience in production data pipelines and platforms with ownership of architecture and reliability.
Strong SQL and Python skills for writing maintainable code.
Experience with cloud data warehouses like Snowflake, BigQuery, or Redshift.
Solid understanding of data modeling and incremental processing.
Familiarity with transformation and orchestration tools such as dbt or Airflow.
Proven track record of enhancing data reliability through testing and monitoring.
Strong communication skills to explain technical concepts to diverse audiences.
Responsibilities
Design, build, and maintain data ingestion pipelines from various sources.
Develop accessible and consistent data models for analytics.
Implement automated tests and monitoring for data quality.
Collaborate with teams to define requirements and deliver trusted datasets.
Optimize pipeline performance while managing costs.
Oversee production workflows, including troubleshooting and recovery.
Document data sources and ensure appropriate access controls.
Benefits
Generous health-insurance package with nationwide coverage, vision, & dental.
401(k) retirement plan with employer matching.
Competitive PTO policy to promote employee well-being.
Generous family leave policy after 8 months of continuous work.
Work from anywhere to enhance work-life balance.
Provision of quality technology equipment to improve work efficiency.
Full Job Description
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.
Benefits
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. If you believe you are a good fit for this role, we would love to hear from you!
