Description:

Job Title: Data Warehouse Engineer

We are seeking a forward-thinking Data Warehouse Engineer to join our influential Core Go-to-Market (GTM) Data team. In this role, your expertise will be instrumental in advancing our data-driven capabilities, as you design and implement innovative data solutions. Your efforts will empower teams across advertising, marketing, content, email, support, and RevOps to unlock smarter, faster decisions. You’ll play a crucial role in synchronizing and optimizing our data architecture across multiple GTM systems, ensuring the right data is at the fingertips of those who drive our strategic insights and launch our GTM initiatives.

Join forces with cross-functional teams and apply your skills to reshape our data sync architecture. Your contributions will not only foster innovation and efficiency but also amplify Zapier’s transformative effect on businesses worldwide.

If you’re ready to harness your data warehouse engineering prowess to spearhead transformative changes and elevate business decision-making, we’d love to hear from you. Join us at Zapier and become an integral part of a movement that’s redefining how the world works—one automated task at a time!

• Our Commitment to Applicants
• Culture and Values at Zapier
• Zapier Guide to Remote Work
• Zapier Code of Conduct
• Diversity and Inclusivity at Zapier

About You

• You are a skilled written communicator. Zapier is a 100% remote team and writing is our primary means of communication. You can communicate about technical topics without unnecessary jargon. You translate unfamiliar data modeling concepts into approachable ones to team mates and stakeholders with less experience working with data. And you have a history of contributing to written documentation to elevate your peers with what you’ve learned.
• You have several years of experience. You are a skilled Data Warehouse Engineer with several years of in-seat experience. We’re looking for a candidate who can self-organize and who can help us identify the most valuable areas to contribute based upon business needs. After you have onboarded, we hope that you can learn from others and teach in equal measure thanks to your previous experience.
• You have experience in SQL and data modeling. You’ve written complex SQL queries for the purposes of data warehouse modeling and have a nuanced appreciation for when and where traditional approaches work and when they don’t. You’ve designed tables and ETL pipelines with an eye towards ease of use by the end consumer, high performance, and scalability. You’ve documented schemas and created data dictionaries.
• You have experience getting up to speed quickly on a variety of business domains and systems. You’ve worked with or are familiar with working with data assets that are used by multiple business areas and take ownership over filling in any knowledge gaps.
• You strive to learn about business and product goals so you can design data models that empower analysis and reporting. You value partnering with your Data Science colleagues to ensure your efforts align with data objectives.
• You understand that perfect is the enemy of the good, and default to action by shipping MVP code and iterating as needed to get towards better solutions.  You don’t let stakeholder pressure to move fast deter you from maintaining a high level of quality in your work.
• You have developed innovative solutions and influenced standards that support team goals by proposing improvements to cross-team processes and driving collaborative work to implement them.

Things You’ll Do

• Design, build, and maintain ETL/ELT pipelines that efficiently ingest and transform data from various upstream databases and APIs into our data warehouse. You’ll be working with a modern tech stack including Databricks, dbt, Airflow, Kafka, Hightouch, and custom Python scripts to ensure data is accurate, timely, and accessible.
• Design and enhance data models, focusing on the creation and expansion of slowly changing dimensions and fact tables. Your work will make sure our data architecture supports scalable and high-performance analytics.
• Develop comprehensive reports and interactive dashboards using industry-leading data visualization tools like Looker and Amplitude. These models will empower our stakeholders to get actionable insights and drive data-informed decisions.
• Partner with stakeholders across Zapier to understand their analytic needs and design self-service analytics solutions. Your role includes providing guidance and support to improve their data-driven decision-making.
• Play a critical role in the continuous improvement of our Go-To-Market (GTM) data models. Your ideas will help shape the design and effectiveness of our data structures, making sure they meet business needs and technology changes.