Senior Data Engineer — Data Lake & Warehouse Architect

Redfin; Seattle (WA); On-site; USD 153,500 - 207,700; Full time

Job summary

Redfin is seeking a data engineer to design data warehouse solutions and build scalable the data lake for analytics. You will own end-to-end features from requirements gathering to production deployment, collaborating with stakeholders across the business.

Ideal candidates have 5+ years in enterprise data warehousing, strong SQL skills, and experience with AWS Redshift and cloud services. This Seattle-based role offers growth, impact, and the chance to shape data infrastructure at Redfin.

Qualifications

• 5+ years of experience in Enterprise Data Warehouse focused roles.
• 5+ years of production SQL experience.
• 3+ years in Python, Java, or Scala.
• Experience with AWS Redshift and AWS cloud services.
• Experience building ETL pipelines for analytics.
• Experience building large-scale data lakes.
• Ability to provide data architecture insights and modeling recommendations.

Responsibilities

• Design data warehouse solutions using dimensional modeling to support ETL and analytics.
• Develop, implement and tune ETL processes.
• Write and optimize SQL for production applications.
• Design and implement a new data lake.
• Create maintainable code that meets design specs.
• Own features end-to-end from requirements to production.
• Drive data storage and ingestion platform evolution with best practices.

Skills

SQL

ETL

Data warehouse

Python

Java/Scala

AWS Redshift

AWS Cloud

Tools

AWS S3

DynamoDB

EC2

Job description

Redfin is seeking a data engineer to design data warehouse solutions and build scalable the data lake for analytics. You will own end-to-end features from requirements gathering to production deployment, collaborating with stakeholders across the business.

Ideal candidates have 5+ years in enterprise data warehousing, strong SQL skills, and experience with AWS Redshift and cloud services. This Seattle-based role offers growth, impact, and the chance to shape data infrastructure at Redfin.