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, join us.
As a Data Engineering Intern, you will be part of the team that owns Redfin's data automation platform, data warehouse, and agent pay system. This role will contribute to our Data Warehouse and help provide valuable data to downstream analysts and report users. You will help import, transform and optimize data used across the business in reports and analysis, enabling the data-driven machine that is Redfin.
Assist in onboarding new source system objects into our Data Warehouse
Assist in modeling datasets and adding business logic for downstream consumers
Performance tune and optimize existing processes
Monitor and help troubleshoot operational issues
Identify and remove obsolete objects from our Data Warehouse
Triage and complete support tickets for Data Engineering
Bachelor’s Degree in Computer Science / Information Systems or related field
Working knowledge and hands-on experience in SQL
Working knowledge and hands-on experience in relational or columnar databases
Working knowledge and hands-on experience in Python is a plus
Working knowledge and hands-on experience with AWS tools (S3/Redshift/API Gateway) is a plus
The ability to deal with ambiguity, communicate well with partner teams - both technical and nontechnical, and strong empathy for the customer experience
What We Offer
A fully paid internship with competitive compensation.
Close mentorship by a Senior Data Engineer who will be available for both formal and informal meetings and discussions.
The opportunity to work start to finish on meaningful tasks and projects, using new technologies and building data structures that last.
Intern-specific company-wide events and other support to ensure a positive learning experience.
Redfin is an equal opportunity employer committed to hiring a diverse workforce.