Thumbtack needs to address the challenge of hundreds of terabytes of data spread across various teams, with unique difficulties in cleaning and organizing this data to measure performance. The role will involve understanding data needs and building datasets to solve 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
