Senior Data Engineer

Mainstay

United States

Remote

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Mainstay is seeking a Senior Data Engineer to join the Data Platform team. You will help build data products with data science and product teams, delivering data engineering as a shipped product for customers in the single-family rental space.

You will lead durable data models, reliable workflows, and architectural guidance, becoming the real estate data domain expert while promoting high-quality engineering practices.

Qualifications

  • 6+ years of experience in data engineering or software engineering.
  • Expertise in data architecture, data modeling, and building data pipelines at scale.
  • Proficiency in SQL, Python, and/or Spark.
  • Expertise in cloud data warehouses such as Snowflake, Redshift, BigQuery.
  • Experience scheduling and operating batch data processing workflows.

Responsibilities

  • Architect durable data models with intuitive representations of residential real estate.
  • Design graceful and reliable workflows to generate data assets.
  • Inform the overall architecture of our data platform.
  • Establish standards and best practices for data engineering.
  • Become a domain expert in real estate.

Skills

SQL
Python
Spark
Data pipelines
Data modeling
Cloud data warehouses

Tools

Snowflake
Redshift
BigQuery
Airflow
Terraform
Docker
AWS

Job description

ABOUT MAINSTAY Mainstay is the leading market intelligence platform purpose built for buying, managing, and selling homes in the single family rental industry. As an AI native company, we turn complex data into clarity that helps the industry move forward with confidence. Founded within Opendoor, Mainstay launched as an independent company in 2024 and recently raised a Series A round led by Khosla Ventures. Ready to shape the future of real estate with AI? Join Mainstay and help us redefine what’s possible in the single family rental space. If you thrive on solving complex problems and want to make a tangible impact in a fast-growing industry, we’d love to hear from you

WHAT YOU’LL DO:

As a Senior Data Engineer on the Data Platform team, you will be responsible for building data products in partnership with our data science and product teams. This is a rare opportunity where your data engineering output will be the shipped product and not just an internal resource. Our customers are businesses operating in the single-family home market and our goal is to provide them with high quality data to inform underwriting, leasing, vendor management, and more. We’re a small team dedicated to quality engineering and are looking for a technical leader to help us evolve our products and establish best practices.

YOU’RE EXPECTED TO:
  • Architect durable data models with intuitive representations of residential real estate
  • Design graceful and reliable workflows to generate data assets
  • Inform the overall architecture of our data platform
  • Establish standards and best practices for data engineering
  • Become a domain expert in real estate
WHAT WE’RE LOOKING FOR
  • 6+ years of experience working in data engineering or software engineering
  • Expertise in data architecture, data modeling, and building data pipelines at scale
  • Proficiency in SQL, Python, and/or Spark
  • Expertise in cloud data warehouses such as Snowflake, Redshift, BigQuery
  • Experience scheduling and operating batch data processing workflows
BONUS POINTS IF YOU HAVE:
  • Airflow, Prefect, Dagster, or a similar orchestration system
  • Data Warehouse (DWH) architecture and Change Data Capture (CDC) modeling techniques
  • Web scraping and data extraction from public or semi-structured sources
  • Experience with AI/ML platforms such as SageMaker, MLflow, or similar
  • Hands-on experience managing data platform infrastructure, with proficiency in tools such as Terraform, Docker, and AWS services
MAINSTAY BUILT ON TRUST

At Mainstay, trust is at the core of everything we do. We build trust with everyone -- from candidates to employees to partners. We believe in fairness and openness throughout our hiring process, evaluating candidates based on qualifications without regard to race, color, religion, national origin, age, gender, marital status, disability, veteran status, sexual orientation, gender identity, or any other protected status. Our privacy practices describe how we handle applicant information, you can find the policy details for California residents here https://mainstay.io/privacy. We are committed to providing reasonable accommodations throughout our recruitment processes for candidates with disabilities, pregnancy, religious beliefs, or other reasons protected by applicable laws. If you require assistance or a reasonable accommodation, please contact us at mainstay-recruiting@opendoor.com

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Mainstay Labs Inc. • United States

Remote
USD 140,000 - 180,000
Agent Operations Lead
Agent Operations Lead

Mainstay • United States

Remote
USD 120,000 - 140,000
Senior Institutional Brokerage Sales
Senior Institutional Brokerage Sales

Mainstay Labs Inc. • United States

Remote
USD 120,000 - 190,000
Senior Data Engineer, AI-Driven Real Estate Platform
Senior Data Engineer, AI-Driven Real Estate Platform

Mainstay • United States

Remote
USD 120,000 - 180,000
Senior Data Engineer - AI-Driven Real Estate Platform
Senior Data Engineer - AI-Driven Real Estate Platform

MAI Agents • United States

Remote
USD 140,000 - 180,000
Escrow Support Specialist - Funding
Escrow Support Specialist - Funding

mainstay • Plano (TX)

On-site
USD 60,000 - 90,000
Agent Operations Lead (Fully Remote)
Agent Operations Lead (Fully Remote)

Mainstay • United States

Remote
USD 150,000 - 210,000
Senior Software Engineer - Data
Senior Software Engineer - Data

ApartmentIQ • United States

Remote
USD 120,000 - 180,000
Remote-first
Competitive salary
Generous PTO
+3
Senior Software Engineer - Data
Senior Software Engineer - Data

ApartmentIQ • Alabama

Remote
USD 120,000 - 160,000
Remote-First
Competitive Salary
Paid Time Off
+3
Senior Data Engineer
Senior Data Engineer

AMH • San Antonio (TX)

On-site
USD 121,000 - 151,000
Medical, dental and vision insurance
401(k) with company matching
Tuition reimbursement
+2