Data Warehouse Engineer, Zapier
$141.1-211.7k
Canadian annual salary range (CAD): 141.1K – $211.7K. Salary only based in USA and Canada and may very in further locations. + Offers Equity + Offers Bonus
More information about location
Workflow automation service
Open for applications
Workflow automation service
1001+ employees
Open for applications
$141.1-211.7k
Canadian annual salary range (CAD): 141.1K – $211.7K. Salary only based in USA and Canada and may very in further locations. + Offers Equity + Offers Bonus
More information about location
1001+ employees
Company mission
Zapier's mission is to Make Automation Work for Everyone!
Role
Who you are
- 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
What the job involves
- 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
Application process
- Deadline to Apply: 7 March 2025 at 05:00 GMT
Our take
Even before remote working became the "in thing", freelancers, small business owners, and large organisations have found themselves needing more and more software platforms to serve their operations needs. As people used more software services, Zapier founders saw the need to connect the actions between these softwares and save everyone some time.
Zapier is the largest integration and automation tool for businesses. Since being founded, Zapier has grown its suite of automation offerings across almost every mainstream software service. The company is one of the most successful to come out of Y Combinator, and has also been one of the pioneers of remote working.
Zapier has so far, been able to capitalise heavily on its advantage as first entrants and has had very little actual competition. Software services aren't going anywhere anytime soon and organisations are only going to need more of them. This puts Zapier in a strong place growth-wise but also opens up room for bolder companies to get in on the action. Companies like Airtable and Integromat are already preying on more niche segments of Zapier's market share.
Freddie
Company Specialist at Welcome to the Jungle
Insights
38% employee growth in 12 months
Company
Funding (1 round)
Oct 2012
$1.3m
SEED
Total funding: $1.3m
Company benefits
- Work from anywhere
- Bonus program
- Unlimited vacation policy
- Great healthcare + dental + vision coverage*
- Retirement plan with company match*
- Stock options for every Zapien**
- 2 annual company retreats to awesome places
- 14 weeks paid leave for new parents
- Home office setup stipend
- Professional development allowance
Additional info
- As a fully remote company with 800+ team members across 40+ states, 38 countries, and 18+ timezones, we’ve adopted a culture of asynchronous work. This work style allows teams to collaborate effectively across locations, time zones, skills, and each individual’s energy levels, and empowers employees to work in a setting that fits their needs. In practice, we live on Slack, with most conversations in public channels. It mimics the open-office feel and allows everyone to search the chat logs if they need to find something that happened when they weren’t around
Leadership
Wade Foster
(CEO & Co-Founder)Prior to co-founding Zapier, wasEmail Marketing Manager with Veterans United Home Loans, and Customer Development Lead at The Idea Works.
Bryan Helmig
(CTO & Co-Founder)Was previously Product Dev/Manager at Veterans United Home Loans.
Mike Knoop
(Co-Founder)Was CPO and Head of Labs at Zapier before becoming President. Previously was a Graduate Research at the University of Missouri.
Share this job
View 9 more jobs at Zapier