Senior Data Engineer

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 redefining real estate in the consumer’s favor by combining our own technology and agents to create a service that’s better, faster, and costs less. As a Redfinnian, you’ll make a difference in one of life’s most important events - buying or selling a home. Our hiring standards are high, yet our culture is humble. We’ve got all the perks, but if what you value most is doing great work in a creative, collaborative, and disciplined environment, then come join us.

About The Role

• You will design data warehouse solutions using dimensional methodologies to support ETL processes and data analytics applications
• You will develop, implement and tune ETL processes
• You will write and tune SQL including database queries, DDL and DML
• You will design and implement a new business critical data lake
• You will create code that meets design specifications, follows standards, and is easy to maintain
• You will own features that you develop end to end. Work with end users on requirements gathering, developing and testing your code, and implementing new processes in production that you’ll maintain and support them over time
• You will drive our data storage and ingestion platform and help evolve our technology stack and while using development best practices

About You

• You have 5+ years of experience overall in Enterprise Data Warehouse focused roles
• You have 5+ years of experience writing SQL for production applications
• You have 3+ years of experience in at least one object-oriented or scripting language (i.e., Python, Java, Scala, etc.)
• You have strong experience with AWS Redshift and AWS Cloud Products (i.e., S3, DynamoDB, EC2, etc.)
• You have experience building ETL pipelines for analytical purposes
• You have experience building large scale Data lakes
• You can add architectural insights on where to store data and modeling experience to recommend how it should be structured to make it accessible, performant, and resilient to change

What You’ll Get

Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We’ve got your back. Check out our full list of Benefits and Perks.

About Us

Redfin is a technology-driven real estate company with the country’s most‑visited real estate brokerage website. As part of Rocket Companies (NYSE: RKT), Redfin is creating an integrated homeownership platform from search to close to make the dream of homeownership more affordable and accessible for everyone. Redfin’s clients can see homes first with on‑demand tours, easily apply for a home loan with Rocket Mortgage, and save thousands in fees while working with a top local agent.

Equal Employment Opportunity

This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state and federal law. The company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, at [e-mail].

The compensation information below is provided in compliance with all applicable job posting disclosure requirements. The compensation for this position is $153,500.00-$207,700.00. The position may also be eligible for an annual bonus, incentives, and other employment‑related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid‑time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is the company’s current, good faith estimate at the time of posting. [Compensation and benefits are subject to modification from time to time as the Company, in its sole, exclusive discretion, deems appropriate.] The Company may determine during its future reviews of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position. Los Angeles County and San Francisco Candidates only: qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the Fair Chance Initiative for Hiring.