Note: The job is a remote job and is open to candidates in USA. Mainstay is hiring a Senior Data Engineer to build customer-facing data products in partnership with its data science and product teams. The role focuses on providing high-quality data for businesses in the single-family home market while helping evolve the data platform and establish engineering best practices.
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
- 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
- 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
Company Overview
Company H1B Sponsorship