Who We Are
At Spruce, our mission is to change the way people live in their homes by making home services more accessible. As the leading provider of lifestyle services to the multifamily industry, we offer daily chores and housekeeping services to more than 2,000 apartment communities across the US, and we work with over 60 of the top apartment managers in the country. Through the Spruce app, apartment residents can easily have their clothes folded, their dishes washed, their bed sheets changed, or their bathroom cleaned.
Venture-backed and headquartered in Austin, Spruce has more than 80 employees and is growing rapidly. We promote a people-first culture where curiosity, ownership, hustle, and boldness are valued and encouraged. Each employee has a personal, measurable impact on the success of the company, and ideas are welcomed from everyone.
About the Role
We’re looking for a Data Engineer I who will report to the Director of Business Analytics. You’ll be serving an integral role in bridging between our data engineering and business analytics team members. Namely, this person will be owning the maintenance, organization, and improvements made to data in our BI tool, Looker. This will be a great opportunity for someone with a strong technical background who’s interested in startups and enjoys tackling unique data challenges with high impact to the business.
What You Get to Do
- Designing data models with a deep understanding of how the data will be used in Looker
- Re-structuring old data models in LookML to be more efficient and flexible to evolving data needs
- Familiarizing yourself with what exists in our databases, data lake and data warehouse that could be pulled through to Looker to answer arising business questions
- Translating business analytics needs into technical requirements for engineers
- Pulling through new data tables/fields to Looker and ensuring proper setup in LookML (coding in LookML, choosing proper joins, model design/data architecture etc.)
- QAing data provided in Looker and creating systems to ensure data quality
- Launching new data to the business and maintaining related documentation (data dictionary)
Who You Are
- Bachelor’s degree, or equivalent, in engineering or data related fields
- 3-5 years of work experience in a data/analytics oriented role
- Self-starter with a desire to continuously learn new skills
- Comfortable with ambiguity and enjoys creating structures/processes that improve efficiency with cumulative effect over time (exponential thinking).
Technical Skills
- Strong understanding of data modeling
- Strong understanding of relational database design and data warehousing concepts
- Expert on profiling data and uncovering data quality issues that impact analysis and dashboard
- Expert in SQL
- Experience with Snowflake or similar cloud warehouse technologies
- Expert in building Visualizations in Looker, including strong LookML coding skills essential
Things that can set you apart
- Strong understanding of source data optimization for Looker Processing
- Experience in designing and developing ETL processes
What We Offer
- Competitive salary
- Stock options
- 401K plan
- Medical, vision, dental insurance
- Unlimited PTO
- 100% remote work
- Spruce-provided WFH setup (laptop, keyboard, monitor(s), mouse)
- A huge role in the growth of a company with a meaningful mission
#LI-Remote
We're building a strong, diverse team of curious, creative people who want to find purpose in their work and support each other in the process. If this sounds like you, then let's talk.
