This position is a remote eligible position. You can chose to work at a remote location or at one of Redfin's headquarter locations (Seattle, San Francisco, or Dallas).

As the Data Engineer for the Business Intelligence Team, your job is to integrate, sanitize, and productize our massive store of market and user data to turn it into a competitive weapon. You will have ownership of Redfin's Data Warehouse platform, overall architecture, data integration and operational excellence. You will also be working closely with marketing team to provide key business KPIs and enable marketing automation.

Job Responsibilities

• Write and tune SQL including database queries, ddl and dml, stored procedures, triggers, user defined functions, analytic functions, etc.
• Develop, implement and tune ETL processes
• Design data warehouse solutions using Kimball methodologies to support ETL processes and data analytics applications
• Create code that meets design specifications, follows standards, and is easy to maintain
• Develop and unit test assigned features to meet product requirements
• Work with Quality Assurance team to ensure that the processes are fully tested
• Support and maintain dev/test/prod environments to meet business delivery specifications and needs
• Assist with adhoc report generation and data analysis for customers

Job Requirements

• Expert level SQL
• 1-3 years experience in database technologies (i.e., Postgres, MySQL ,SQL Server, Oracle, RedShift etc.)
• Minimum 3 years of experience in Data Warehousing
• Ability to work with minimal direction, yet also able to work in team environment
• Working knowledge of dimensional modeling techniques
• Working knowledge of data quality approaches and techniques
• Ability to communicate technical issues/subjects to non-technical audiences
• Experience working with a standard ETL tool (i.e.,Informatica, SSIS, Talend, Pentaho, etc.)
• Experience working with Linux a plus
• Programming language experience (Python, Java, etc) is a plus
• Working with the Agile/Scrum development process is a plus
• AWS experience is a plus

To make sure we hire the most qualified people, we've designed a multi-step selection process which may include interviews, a homework assignment, and a reference check. We're excited to get to know you and hope you're ready to give this opportunity everything you've got!

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

#LI-remote
#LI-CY1

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.