Data Warehouse Engineer

About Zapier

We're humans who simply think computers should do more work.

At Zapier, we’re not just making software—we’re building a platform to help 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. You’ll collaborate with brilliant people, use the latest tools, and leverage the flexibility of remote work. Your work will directly fuel our customers’ success, and as they grow, so will you.

Job Updated: March 27, 2025

Location: Americas (North, Central and South America), EMEA

Shape the future of automation as a Data Warehouse Engineer at Zapier!

We’re hiring two Data Warehouse Engineers to join Zapier’s growing Data org: one supporting our Ecosystem Data team, and one supporting our Upmarket Data team. While both roles share a strong foundation in modern data engineering, each supports a different strategic area of the business through thoughtful, well-modeled analytics data.

The Ecosystem Data team focuses on Zapier’s network of 7,000+ app integrations and partnerships. They help teams across the Integration Platform and Partnerships understand how integrations are performing, identify opportunities to grow adoption and measure the impact of partner programs. In this role, you’ll transform raw data into clean, reliable models that enable stakeholders and Data Scientists to explore trends, evaluate integration quality, and drive strategic decisions.

The Upmarket Data team supports Zapier’s enterprise motion, working closely with RevOps, Sales, Success, and Marketing, and Enterprise Product. This team enables Zapier to better understand and serve our largest customers by modeling key moments in the customer journey and ensuring data flows cleanly across GTM systems. As a Data Warehouse Engineer, you’ll play a critical role in creating scalable, self-serve data assets that power enterprise insights and go-to-market strategies.

Our awesome Data teams provide the reliable data foundations that help everyone at Zapier make smart, informed decisions. Whether you're focused on integrations or enterprise customers, you’ll be a key partner in helping us scale thoughtfully, efficiently, and with impact. Exciting times ahead!

We know applying for and taking on a new job at any company requires a leap of faith. We want you to feel comfortable and excited to apply at Zapier. To help share a bit more about life at Zapier, here are a few resources in addition to the job description that can give you an inside look at what life is like at Zapier. Hopefully, you'll take the leap of faith and apply.

• 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 experienced in Data Warehouse Engineering. You bring 4+ years of experience as a Data Warehouse Engineer, Data Engineer, Analytics Engineer, or in a similar role. You excel at self-organizing and managing projects end-to-end, from requirements gathering and solution design to implementation and delivery.

• You have strong proficiency in SQL and Python. You’re skilled at writing complex SQL queries for data transformation and analysis. You are also proficient in Python, capable of building Airflow functions and extracting data from third-party APIs.

• You have a deep understanding of data modeling concepts. You understand the nuances of when traditional data modeling approaches are effective and when they aren’t. You’ve designed data models and ETL pipelines with a focus on ease of use for end consumers, high performance, and scalability.

• You are committed to data quality. You prioritize data integrity and implement robust solutions for monitoring and ensuring data quality. You employ testing, monitoring, and alerting practices to maintain data reliability throughout the pipeline.

• You strive to align with business goals. You design data models that empower insightful analysis and reporting, always keeping the end goal in mind. You understand the key metrics and their implications, and you work closely with Data Science colleagues and cross-functional stakeholders to ensure your efforts align with broader objectives.

• You influence technical standards. You’re familiar with modern data platforms and best practices for scalability and performance. You contribute to shaping your team’s technical direction, including decisions on architecture, tooling, and strategies for technical improvements.

• You embrace progress over perfection. You understand that “perfect is the enemy of good” and take a pragmatic approach to shipping solutions. You prioritize delivering functional solutions quickly and iterating to refine and optimize them over time.

• You are a skilled written communicator. Zapier is a 100% remote team, and writing is our primary means of communication. You explain complex technical topics in a clear and approachable way

• You value collaboration and knowledge sharing. You work effectively with teammates at all technical levels. You take ownership of filling knowledge gaps about the data assets you manage and contribute to comprehensive documentation to elevate your peers with what you’ve learned.

• You are proactive and strategic. You proactively develop forward-thinking plans that prioritize stakeholder value and contribute to shaping the team’s technical direction. You stay curious about emerging technologies and stakeholder challenges, striving to connect the two in your work.

Things You’ll Do

• Design and Build Data Pipelines: Develop and maintain efficient data pipelines using Airflow, Databricks, and dbt to transform raw data into analytics-ready datasets for user-facing products and insights.

• Ensure Data Quality: Implement automated testing and monitoring systems to uphold data quality and integrity, leveraging best practices in observability and issue detection.

• Enable Self-Service Analytics: Partner with stakeholders across Zapier to understand their analytical needs and build data models and self-service analytics solutions using tools like Looker and Amplitude.

• Define Data Collection Strategies: Collaborate with product, marketing, and engineering teams to ensure products and services are properly instrumented to collect the right data for analytics.

• Shape Technical Direction: Contribute to architectural decisions, tooling choices, and strategies to optimize data storage, workflows, and schemas, ensuring scalability, accessibility, and security.

• Bridge Data to Insights: Work closely with Data Scientists and cross-functional stakeholders to bridge the gap between raw data and actionable insights, empowering teams to make informed, data-driven decisions.

• Mentor and Share Knowledge: Act as a resource for junior team members, offering guidance and knowledge-sharing to elevate team expertise and contribute to a culture of learning.

How to Apply

At Zapier, we believe that diverse perspectives and experiences make us better, which is why we have a non-standard application process designed to promote inclusion and equity. We're looking for the best fit for each of our roles, regardless of the type of companies in your background, so we encourage you to apply even if your skills and experiences don’t exactly match the job description. All we ask is that you answer a few in-depth questions in our application that would typically be asked at the start of an interview process. This helps speed things up by letting us get to know you and your skillset a bit better right out of the gate. Please be sure to answer each question; the resume and CV fields are optional.

Education is not a requirement for our roles; however, if you receive an offer, you will need to include your most recent educational experience as part of our background check process.

After you apply, you are going to hear back from us—even if we don’t see an immediate fit with our team. In fact, throughout the process, we strive to never go more than seven days without letting you know the status of your application. We know we’ll make mistakes from time to time, so if you ever have questions about where you stand or about the process, just ask your recruiter!

Zapier is an equal-opportunity employer and we're excited to work with talented and empathetic people of all identities. Zapier does not discriminate based on someone's identity in any aspect of hiring or employment as required by law and in line with our commitment to Diversity, Inclusion, Belonging and Equity. Our code of conduct provides a beacon for the kind of company we strive to be, and we celebrate our differences because those differences are what allow us to make a product that serves a global user base. Zapier will consider all qualified applicants, including those with criminal histories, consistent with applicable laws.

Zapier is committed to inclusion. As part of this commitment, Zapier welcomes applications from individuals with disabilities and will work to provide reasonable accommodations. If reasonable accommodations are needed to participate in the job application or interview process, please contact jobs@zapier.com. 

Application Deadline:

The anticipated application window is 30 days from the date job is posted, unless the number of applicants requires it to close sooner or later, or if the position is filled.

Even though we’re an all-remote company, we still need to be thoughtful about where we have Zapiens working. Check out this resource for a list of countries where we currently cannot have Zapiens permanently working.