Senior Data Engineer (Remote)
Senior Data Engineer at Mainstay builds data products that are shipped as the core offering of its market-intelligence platform for the single-family rental industry, designing durable data models and reliable batch pipelines. Core stack: SQL, Python/Spark, cloud data warehouses (Snowflake/Redshift/BigQuery), plus orchestration tools like Airflow and AWS/Terraform/Docker.
- Compensation
- Not disclosed
- Location
- US
- Work setup
- Remote
- Seniority
- Senior
- Employment
- Full time
- Experience
- 6+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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
Nice to have
- Orchestration systems such as Airflow, Prefect, or Dagster
- 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 or MLflow
- Managing data platform infrastructure with Terraform, Docker, and AWS services
Full description
Senior Data Engineer
Department: Engineering
Location: Remote
Employment Type: FullTime
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 - apply now and let’s move the industry forward, together!
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