Senior Data Engineer

Thumbtack
Summary
Join Thumbtack's Marketing Tech team and play a pivotal role in optimizing millions of marketing dollars and driving top-line revenue growth. Collaborate with a team of builders to refine and implement a data-driven framework for marketing software development. Design, architect, and maintain core marketing datasets, data marts, and feature stores. Integrate with various teams to understand their data needs and design datasets with engineering rigor. Drive data quality and best practices, and build the next generation of marketing data products based on real-time data. This role requires 4+ years of experience in designing and building datasets and warehouses, expertise in SQL and Python, and experience with a modern data stack (BigQuery, dbt, Apache Airflow).
Requirements
- 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
- 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
- Strong sense of ownership and pride in your work, from ideation and requirements-gathering to project completion and maintenance
- Experience in the marketing domain and third party tools like Branch, Fivetran etc
Responsibilities
- Collaboratively refine and evangelize a comprehensive framework for integrating data-thinking into the software development lifecycle for marketing
- 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 marketing 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 marketing and business areas
- Help build the next generation of marketing data products at Thumbtack, based on real-time data products on top of Apache Kafka
Benefits
- For candidates living in San Francisco / Bay Area, San Jose, New York City, or Seattle metros, the expected salary range for the role is currently $212,700 - $259,900
- For candidates living in Austin, TX or Washington DC metros or in California, Massachusetts, New Jersey, or Washington states, the expected salary range for the role is currently $191,400 - $234,000
- For candidates living in all other US locations, the expected salary range for this role is currently $180,800- $221,000