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 Posted: February 3, 2025

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

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

Zapier’s Ecosystem is an exciting network of integrations and partnerships that powers our amazing automation platform! With connections to over 7,000 apps, we help users streamline their workflows and make life a bit easier. We’re all about keeping things running smoothly by tracking how our integrations are performing and finding new ways to enhance existing ones or bring in fresh connections. By nurturing a vibrant ecosystem, Zapier enables users to effortlessly link their favorite tools and crush their goals more efficiently!

We also love teaming up with app developers and businesses to foster growth and engagement through strategic partnerships. From co-marketing projects to solution provider programs and sponsorships, these collaborations are a big part of what makes Zapier shine.

Our awesome Ecosystem Data team is here to provide reliable data models and actionable insights so that everyone can make smart, informed decisions. As a Data Warehouse Engineer, you’ll be at the heart of shaping and scaling this vibrant ecosystem, helping us fulfill our mission of making automation available to everyone. 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.