A home is the biggest investment most people make, and yet, it doesn't come with a manual. That's why we're building the only app homeowners need to effortlessly manage their homes ?" knowing what to do, when to do it, and who to hire. With Thumbtack, millions of people care for what matters most, and pros earn billions of dollars through our platform. And as one of the fastest-growing companies in a $600B+ industry ?" we must be doing something right.

We are driven by a common goal and the deep satisfaction that comes from knowing our work supports local economies, helps small businesses grow, and brings homeowners peace of mind. We're seeking people who continually put our purpose first: advocating for pros and customers, embracing change, and choosing teamwork every day.

At Thumbtack, we're creating a new era of home care. If making an impact and the chance to do good inspires you, join us. Imagine what we'll build together.

Thumbtack by the Numbers

Available nationwide in every U.S. county
80 million projects started on Thumbtack
10 million 5-star reviews and counting
Pros earn billions on our platform
1000+ employees
$3.2 billion valuation (June, 2021)

About the Engineering Team

At Thumbtack, engineers at every level build products and systems that directly impact our customers and professionals. Our challenges span a wide variety of areas, ranging from building search and booking experiences, to optimizing pricing systems, to building tools to help professionals grow their businesses. We believe in tackling these hard problems together as a team, with strong values around collaboration, ownership and transparency. To read more about the hard problems that our team is taking on, visit our engineering blog.

About the Role

As a Data Engineer, you will work closely with product and engineering teams throughout Thumbtack, and turn data into insight into action. We're building a hybrid-embedded team of Data Engineers that consult directly with teams to help them better model the data necessary to build a better marketplace for local services. You'll work to understand requirements, then design, deploy, test, and deploy data pipelines, as well as help architect the core data ecosystem for Analysts, Machine Learning Engineers, and Data Scientists. Major project areas include: designing a next-gen warehouse with DBT, developing advanced ingress/egress validation in the data lake, and modeling cost of supply acquisition for our two-sided marketplace.

Responsibilities

Design, build, and maintain data pipelines that support a rapidly evolving product, in partnership with our stellar Analytics and Data Services teams.
Build and own the reporting pipelines that organize and structure our terabytes of data into digestible tables that empower analysis and reporting across the company
Integrate with product teams throughout the org to understand their data needs, and deliver pipelines and insights with the same engineering rigor as any other software we design.
Drive data quality across key product and business areas.
Collaborate closely with analysts and engineers to ensure our analytics infrastructure helps meet company goals and allows product development to move quickly.
Partner with data platform and product engineering teams to ensure consistent, seamless tracking and measurement of key company and product metrics.

What you'll need

If you don't think you meet all of the criteria below but still are interested in the job, please apply. Nobody checks every box, and we're looking for someone excited to join the team.

2 or more years of experience working in data engineering or a similar discipline, where your primary focus was on datastores and business intelligence, serving analysis and reporting functions.
Experience building ETL data pipelines in a programming language like Python, SQL, or Scala.
Expertise in SQL for analytics/reporting/business intelligence, including basic comprehension of query execution plans, and query tuning/optimization for Google BigQuery, Amazon Redshift, Snowflake, or similar.
Experience designing, architecting, and maintaining a data warehouse that seamlessly stitches together data from production databases, clickstream event data, and external APIs to serve teams of analysts.
Excellent ability to understand the needs of and collaborate with stakeholders in other functions, especially an Analytics team, and identify opportunities for process improvements.

Bonus points if you have

Experience using and/or configuring Business Intelligence tools (Tableau, Mode, Looker, et al).
Experience working with semi- or unstructured data in a data lake.
Experience working in data engineering or a similar discipline at an online marketplace or similar consumer technology company.
Experience orchestrating data pipelines that serve hourly or daily metric reporting in Airflow or similar.

Thumbtack is a virtual-first company, meaning you can live and work from any one of our approved locations across the United States, Canada or the Philippines.* Learn more about our virtual-first working model here.

#LI-Remote

Benefits & Perks

Virtual-first working model coupled with in-person events
20 company-wide holidays including a week-long end-of-year company shutdown
Library (optional use collaboration & connection hub) in San Francisco
WiFi reimbursements
Cell phone reimbursements (North America)
Employee Assistance Program for mental health and well-being

Learn More About Us

Thumbtack embraces diversity. We are proud to be an equal opportunity workplace and do not discriminate on the basis of sex, race, color, age, pregnancy, sexual orientation, gender identity or expression, religion, national origin, ancestry, citizenship, marital status, military or veteran status, genetic information, disability status, or any other characteristic protected by federal, provincial, state, or local law. We also will consider for employment qualified applicants with arrest and conviction records, consistent with applicable law.

Thumbtack is committed to working with and providing reasonable accommodation to individuals with disabilities. If you would like to request a reasonable accommodation for a medical condition or disability during any part of the application process, please contact: recruitingops@thumbtack.com.

If you are a California resident, please review information regarding your rights under California privacy laws contained in Thumbtack's Privacy policy available at https://www.thumbtack.com/privacy/ .

Summary
Company name: Thumbtack
Remote job title: Data Engineer
Job tags: bigquery, Redshift, Tableau