Thumbtack needs to clean and organize hundreds of terabytes of data from various teams to measure performance, requiring the development of datasets to address these challenges.
Requirements
- 2 or more years of experience designing and building data sets and warehouses
- Experience 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 datasets that integrate data from multiple sources, including production databases, clickstream data, and external APIs
- Familiarity 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
Responsibilities
- 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
- Collaboratively refine and evangelize a comprehensive framework for integrating data-thinking into the software development lifecycle for product teams
Other
- Excellent ability to understand the needs of and collaborate with stakeholders in other functions, especially Analytics, and identify opportunities for process improvements across teams
- Strong sense of ownership and pride in your work, from ideation and requirements-gathering to project completion and maintenance
- LI-Remote
- 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.
