Senior Data Engineer

Thumbtack; Ontario; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

Thumbtack seeks an experienced Data Engineer to join their Data Engineering team in Ontario. This role involves designing and maintaining data sets while collaborating with cross-functional teams to improve data-driven decision-making. The ideal candidate will have extensive experience in data architecture, SQL, and Python, contributing to building next-generation data products.

Qualifications

• 4 or more years of experience designing and building data sets and warehouses.
• Expertise in SQL and Python for ETL pipelines.
• Experience with cloud-native data warehouses.

Responsibilities

• Design, architect, and maintain core marketing datasets and feature stores.
• Drive data quality and best practices across different business areas.
• Collaboratively refine a framework for integrating data-thinking into software development.

Skills

SQL

Python

Data Architecture

Data Quality

Tools

BigQuery

dbt

Apache Airflow

Job description

Thumbtack helps millions of people confidently care for their homes.

Thumbtack is the one app you need to take care of and improve your home — from personalized guidance to AI tools and a best-in-class hiring experience. Every day in every county of the U.S., people turn to Thumbtack to complete urgent repairs, seasonal maintenance and bigger improvements. We help homeowners know which projects to do, when to do them and who to hire from our growing community of 300,000 local service businesses. If making an impact inspires you, join us. Imagine what we’ll build together.

About the Data Engineering Team

Thumbtack’s Data Engineering team is a centralized team that works closely with engineers, analysts, data scientists, and machine learning engineers to help design and curate data sets originating from internal and third-party sources to meet current and future needs. Over the next year, it will continue to build on its prior successes in building a more cohesive data warehouse while starting to work more deeply upstream to build data best practices into the full software development lifecycle (SDLC).

There are several teams all over Thumbtack with Terabytes of data and unique challenges trying to clean and organize this data to measure their performance. In this role, you will work with Engineers, Data Scientists, Managers, and others to understand their needs, and actively work to build datasets to tackle these challenges.

What you'll do

• Collaboratively refine and evangelize a comprehensive framework for integrating data-thinking into the software development lifecycle for product teams
• Design, architect, and maintain core marketing datasets, data marts, and feature stores that support a blend of mature products and features with a rapidly evolving product line, in partnership with analytics, data science, and machine learning
• Integrate with teams consisting of product engineers, analysts, data scientists, machine learning engineers throughout Thumbtack to understand their data needs, and help design datasets with the same engineering rigor as any other software we design
• Drive data quality and best practices across different business areas
• Help build the next generation data products at Thumbtack, based on real-time data products on top of Apache Kafka

In order to be successful, you must bring

• 4 or more years of experience designing and building data sets and warehouses
• Excellent ability to understand the needs of and collaborate with stakeholders in other functions, especially Analytics, and identify opportunities for process improvements across teams
• Expertise in SQL for analytics/reporting/business intelligence and also for building SQL- and Python-based transforms inside an ETL pipeline, or similar
• Experience designing, architecting, and maintaining a data warehouse and data marts that seamlessly stitches together data from production databases, clickstream data, and external APIs to serve multiple stakeholders
• Expertise building the above with a modern data stack based on a cloud-native data warehouse, in our case we use BigQuery, dbt, and Apache Airflow, but a similar stack is fine
• Strong sense of ownership and pride in your work, from ideation and requirements-gathering to project completion and maintenance.

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: [e-mail] .

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/ .

Apply for this job

*

indicates a required field

First Name *

Last Name *

Preferred First Name *

Email *

Phone *

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Thumbtack currently supports remote work in a number of locations across the United States, Ontario and the Philippines. Using the drop down list below, please select the location you intend to work from. If you are not currently located in or able to work from a location listed below, please select "Location not listed." * Select...

Location

If you selected "Location not listed" above, please use the text box below to let us know where you intend to work from.

Location

Will you now or in the future require sponsorship for employment visa status (e.g. H-1B visa status)? * Select...