As a Senior Data Engineer, you will share ownership of Redfin's Analytics Data Warehouse which is needed for business critical data integrations and operational excellence. You will work closely with Analytics and Engineering teams to support, enhance and grow our Data Warehouse. The ideal candidate is someone who is passionate about data warehousing and implementing new data sources to help drive the success of the business. You should also be driven to continuously innovate and improve the infrastructure that you own all while being self-directed and comfortable supporting the data needs of multiple systems and teams.

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.

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.