SQL
Databricks
dbt
Data Warehouse Engineer
Overview
At Zapier, we're on a mission to supercharge productivity and efficiency for over 2.2 million businesses globally by providing seamless workflow automation.
Job Description
Zapier is a platform that helps millions of businesses globally scale with automation and AI. Our mission is to make automation work for everyone by delivering products that delight our customers.
Responsibilities
- - Design, build, and maintain ETL/ELT pipelines that efficiently ingest and transform data from various upstream databases and APIs into our data warehouse
- - Design and enhance data models, focusing on the creation and expansion of slowly changing dimensions and fact tables
- - Develop comprehensive reports and interactive dashboards using industry-leading data visualization tools like Looker and Amplitude
- - Partner with stakeholders across Zapier to understand their analytic needs and design self-service analytics solutions
- - Play a critical role in the continuous improvement of our Go-To-Market (GTM) data models
Required Skills
- - Skilled written communicator
- - Several years of experience as a Data Warehouse Engineer
- - Experience in SQL and data modeling
- - Experience with Databricks, dbt, Airflow, Kafka, Hightouch, and custom Python scripts
- - Ability to design tables and ETL pipelines with an eye towards ease of use by the end consumer, high performance, and scalability
- - Experience getting up to speed quickly on a variety of business domains and systems
- - Ability to partner with Data Science colleagues to ensure efforts align with data objectives
Benefits
- - Offers Equity
- - Offers Bonus
- - Remote work flexibility
- - Commitment to diversity and inclusion
About the company
Zapier puts the power of automation in your hands—no coding required. Take your workflows to the next level with our suite of automation tools.