Our mission is to redefine real estate in the customer's favor. We're dedicated to building a fairer, more transparent industry, because we know the importance of home and the difference it can make for generations of families. From buying, selling, and renting to renovations, title and finance, we're turning real estate into a one stop on-demand service that puts customers in charge and has saved them over a billion dollars in fees. As a Redfinnian, you'll team up with other caring, creative problem-solvers to help us deliver the best products possible, meet the highest standards of customer service, and have fun along the way. Join us and make real estate better—not just for a few, but for everyone.

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.

The Role

• 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

 

Who You Are

• Pursuing a Bachelor’s degree in Computer Science / Information Systems or a related field with at least one semester/quarter remaining after internship.

• Completed coursework or other experience using SQL to aggregate data for visualization and insights

• Completed coursework or other experience with one or more of the following in a data analytics context is a plus: Relational or columnar databases, AWS tools (S3/Redshift/API Gateway), Python is a plus

• Working knowledge and hands on experience in relational or columnar databases

• The ability to deal with ambiguity, communicate well with partner teams - both technical and non technical, and a strong empathy for the customer experience

• Possessing a curiosity that doesn’t stop at the “What?” but hungers for the “Why?” and “What if?”

What We Offer

• Competitive compensation packages with a salary, relocation and housing stipend

• Far more responsibility than at a big company, while at the same time far less stress than you will find in a 2-person startup

• A company that takes care of its employees, giving them the tools, support, and benefits to be successful, regardless of if we are in the office or working remote

• Strong startup culture with catered lunches, casual dress code, happy hours, and more

• 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

For Colorado applicants:

Starting Base Salary: $0.00 - 100,000.00. Actual starting base salary will depend on varying circumstances, including individual qualifications, market finances, and other operational business needs.

Benefits for Full-Time Employees: Three weeks of paid vacation, paid maternity/paternity leave, sick leave, and flex days; eligible for medical, dental, and vision insurance benefits; flexible spending account; health savings account; life and disability insurance; fertility benefits; commuter benefits; Employee Assistance Program; and 401(k).

#LI-Remote

Redfin is an equal opportunity employer committed to hiring a diverse workforce.

A diverse, inclusive culture is vital to Redfin's mission of making real estate better for people from all walks of life. We’re proud that Redfin is a place where different points of view and backgrounds are encouraged and respected. We constantly strive to build a company that reflects the world around us, based on our conviction that pursuing and developing talent of all types is the right way for a business to thrive over the long haul.

Redfin is an equal opportunity employer. We provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination based on race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, and any other characteristic protected by applicable federal, state or local law. If you need accommodation in the application or recruitment process because of a disability or special need, please contact recruitingteam@redfin.com

To ensure the health and safety of our workforce, customers and third parties, Redfin conducts background screening after making conditional offers for employment. All screening is conducted consistent with Equal Employment Opportunity Commission guidance and state and local Fair Chance Act guidance, and Redfin encourages applications from, and fully considers, qualified applicants with criminal record histories.