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 Senior 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

• Proactively drive the vision for BI and Data Warehousing across the company, and define and execute on a roadmap to achieve that vision
• Design, architect, and maintain a data warehouse that supports a rapidly evolving product, in partnership with our stellar analytics and data services teams
• Evaluate new technologies in the BI/Data Engineering/Analytics Infrastructure space, and help build the long-term roadmap for data management, observability, et al.
• Define, document and socialize foundational aspects of our reporting and analytical data model.
• 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.
• Partner with data services and product engineering teams to ensure consistent, seamless tracking and measurement of key company and product metrics.

Must-Have Qualifications

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.

• 6 or more years of experience working in data or backend engineering, where your primary focus was on datastores and business intelligence, serving analysis and reporting functions.
• Strong sense of ownership and pride in your work, from ideation and requirements-gathering to project completion and maintenance.
• 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, Presto, 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.

Nice-to-Have Qualifications

• Experience using and/or configuring Business Intelligence tools (Tableau, Mode, Looker, et al).
• Understanding of database internals and query optimization.
• 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*. When it is safe to gather, we will begin to host in-person events on a regular basis. Remote employees will be expected to travel occasionally for these events to a Thumbtack library or offsite team-building location. In cities with 5+ employees, we are establishing local communities, where employees can gather for local events. Additionally, employees in the San Francisco, Salt Lake City, Toronto and Manila areas will have opt-in access to communal workspace at one of our Thumbtack libraries. We always prioritize the health and safety of our employees. Currently, participation in these events and Thumbtack library use are optional. Both require employees to be fully vaccinated.

#LI-Remote