Senior Data Engineer
About The Position
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. 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
Requirements
- 5+ years of experience overall in Enterprise Data Warehouse focused roles
- 5+ years of experience writing SQL for production applications
- 3+ years of experience in at least one object-oriented or scripting language (i.e., Python, Java, Scala, etc.)
- Strong experience with AWS Redshift and AWS Cloud Products (i.e., S3, DynamoDB, EC2, etc.)
- Experience building ETL pipelines for analytical purposes
- Experience building large scale Data lakes
- 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
Responsibilities
- Design data warehouse solutions using dimensional methodologies to support ETL processes and data analytics applications
- Develop, implement and tune ETL processes
- Write and tune SQL including database queries, DDL and DML
- Design and implement a new business critical data lake
- Create code that meets design specifications, follows standards, and is easy to maintain
- 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
- Drive our data storage and ingestion platform and help evolve our technology stack and while using development best practices
Benefits
- medical, dental, and vision benefits
- 401K retirement plan
- paid-time off
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
