As a Senior Data Engineer - Snowflake Platform, you will share ownership of Rocket Companies’ Snowflake Data Platform, which is needed for business critical data integrations, operational excellence, and stringent data security. You will work closely with various Analytics and Engineering teams to support, secure, and grow our Snowflake Data Warehouse. The ideal candidate is someone who is passionate about data warehousing, security and compliance standards, and implementing new platform best practices 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.
The Role
- Support Data Engineering teams across the Family of Companies to utilize Snowflake as a platform in an efficient manner.
- Write and tune SQL including database queries, DDL, and DML, with a focus on Snowflake-specific optimization.
- Establish and enforce security best practices, access controls, and auditing on the Snowflake platform to ensure compliance with standards such as SOX and CCPA.
- Design and implement CICD best practices for the Snowflake platform.
- Stay up to date on the latest Snowflake offerings. Testing and implementing new functionality when appropriate.
- 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
About You
- 5+ years of experience overall in Enterprise Data Warehouse focused roles including 3+ years of hands-on experience maintaining and administering the Snowflake platform, including resource monitoring and cost management.
- Deep experience implementing and auditing security and compliance best practices for data platforms, including familiarity with regulations like SOX and CCPA.
- 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 Cloud Products (i.e., S3, DynamoDB, EC2, etc.)
- Experience with Infrastructure as code practices using Terraform or similar.
- Ability to 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 revolutionizing the $75 billion real estate industry. We use data, beautiful software, and innovative design to put customers first at every step in the home-buying and selling process. Get ready to dive headfirst into our award-winning website and mobile apps, solving complex business problems in a highly visible, customer-centric way. If you value doing great work in a collaborative environment, join our team!
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. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, at _Careers@Rocket.com_.
The compensation information below is provided in compliance with all applicable job posting disclosure requirements. The compensation for this position is $153,500.00-$207,700.00. The position may also be eligible for an annual bonus, incentives, and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found **_here_**. The information regarding compensation and other benefits included in this paragraph is the company’s current, good faith estimate at the time of posting. [Compensation and benefits are subject to modification from time to time as the Company, in its sole and exclusive discretion, deems appropriate.] The Company may determine during its future reviews of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position. Los Angeles County and San Francisco Candidates only: qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the Fair Chance Initiative for Hiring.