Senior Data Engineer

About Mainstay

Are you ready to be a part of something groundbreaking? Mainstay is the leading market intelligence platform purpose-built for buying, managing, and selling homes in the single-family rental industry. We empower informed decision-making and unlock opportunities for owners, operators, and residents by aggregating and standardizing data from over 50 unique sources. Originally founded within Opendoor, Mainstay launched as an independent company in 2024, driven by our mission to simplify the complex and bring clarity and trust to the single-family rental ecosystem. Join us as we reshape the future of the industry!

About the role

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.

In this role, you will:

• 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

We're looking for someone with:

• 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

Benefits Package (for full-time employees only):

• Paid time off and 12 paid holidays annually

• Medical, dental, and vision insurance

• Basic life insurance

• 401(k) retirement plan

#LI-AW

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.

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