Mainstay
Senior Data Engineer
Job Summary
Mainstay is seeking a Senior Data Engineer to build and evolve data products supporting the single-family rental industry. The role involves designing data models, establishing workflows, and contributing to the overall architecture of the data platform. Candidates should have extensive experience in data engineering, data modeling, and building scalable data pipelines, with proficiency in SQL, Python, and cloud data warehouses. The position offers a focus on quality engineering and best practices within a small, collaborative team dedicated to delivering high-quality data solutions to business customers.
Required Skills
Benefits
Job Description
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
Mainstay’s compensation varies by U.S. geographic market to align with local labor costs. For most locations, the pay range for this position is $158,080 - $209,250, while the base salary pay range for roles based in the SF Bay Area, Seattle, and New York City Metro area is $197,600 - $232,500. Pay is based on location, skills, and experience, and your recruiter will confirm the specific range for your job location.Please note that remote roles are available in all U.S. states except Hawaii, Alaska, Montana, and U.S. Territories.
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 forCalifornia 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 [email protected]
Mainstay
Unlock single-family rental opportunities with comprehensive market intelligence and the tools to make it work for you.
See more jobsSafe Remote Job Search Tips
Verify Employer Thoroughly
Research the company's identity thoroughly before applying. Check for a professional website with contacts, active social media, and LinkedIn profiles. Verify details across platforms and look for reviews on Glassdoor or Trustpilot to confirm legitimacy.
Never Pay to Get a Job
Legitimate employers never require payment for applications, training, background checks, or equipment. Always reject upfront payment requests or demands for bank details, even if they claim it's for purchasing necessary work gear on your behalf.
Safeguard Your Personal Information
Protect sensitive data like SSN, bank details, or ID copies. Share this only after accepting a formal, written job offer. Ensure it's submitted via a secure company system or portal, never through insecure channels like standard email attachments.
Scrutinize Communication & Interviews
Watch for communication red flags: poor grammar, generic emails (@gmail), vague details, or undue pressure. Be highly suspicious of interviews held only via text or chat apps; legitimate companies typically use video or phone calls.
Beware of Unrealistic Offers
If an offer's salary or benefits seem unrealistically high for the work involved, be cautious. Research standard pay for similar roles. Offers that appear 'too good to be true' are often scams designed to lure you into providing information or payment.
Insist on a Formal Contract
Always secure and review a formal, written job offer or employment contract before starting work or sharing final personal details. Ensure it clearly defines your role, compensation, key terms, and conditions to avoid misunderstandings or scams.