Careers

                                                                                                                      

Data Warehouse Engineer at Zapier
world wide

We're looking for a Senior Data Warehouse Engineer to join the data team at Zapier. Interested in helping grow a product that helps the world automate their work so they can get back to living? Then read on…

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. We hope you'll take the leap and apply.

Zapier is proud to be an equal opportunity workplace dedicated to pursuing and hiring a diverse workforce.

ABOUT YOU

  • You are a skilled written communicator. Zapier is a 100% remote team and writing is our primary means of communication.
  • You have experience in SQL. You’ve used written complex SQL queries that join across data from multiple systems, matching them up even when there was not a straightforward way to join the tables. You've designed tables with an eye towards ease of use and high performance. You've documented schemas and created data dictionaries.
  • You have worked with columnar-store databases.You've used and administered databases in an environment involving Postgres, Redshift, BigQuery, or Snowflake.
  • You have experience in ETL development. You’ve used tools like Matillion ETL, Apache Airflow, Apache NiFi, Pentaho Data Integration/Kettle, SQL Server Integration Services, Snaplogic or Informatica.
  • You understand star schemas and have a reference copy of The Data Warehouse Toolkit on your desk. You have a nuanced appreciation for when and where the traditional approaches work and when they don’t.
  • You build tools. You have put together tools for data analysts and data scientists to build their own transforms.
  • You can communicate about technical topics without unnecessary jargon. You translate unfamiliar data modeling concepts into approachable ones to teammates with less experience working with data.

Things you might do:

  • Develop ETL to ingest and transform data from upstream databases and APIs into a data warehouse. The tools used include AWS Redshift, NiFi, Kafka, Matillion ETL and custom Python.
  • Build, deploy, and continuously improve the infrastructure used by our data scientists and data and business analysts. The tools we have been using here include Docker, Terraform, Ansible, Kubernetes, and AWS EC2.
  • Data modeling, including designing and expanding slowly changing dimension and fact tables.
  • As a part of Zapier's all-hands philosophy, help customers via support to ensure they have the best experience possible.

DATA AT ZAPIER

Zapier relies on dozens of systems that emit data about Zapier and our potential and current users and partners. This data is useful for us to make a better product, better decisions, and understand our weaknesses and opportunities. The data team at Zapier pulls this data from DBs, APIs, and event streams, collocates it and then processes it through all the disparate systems to bring them together in a reliable, timely, performant, and easy to understand way to employees and systems that need it.

Within the data team we're made up of several subteams: Data Ops focusing on data infrastructure and storage, compute, ingest, and dimensional modeling; Data Products focusing on building statistical and ML tools and models; and Decision Science that focuses on exposing the data in useful and self-service form.

Our stack is best summed up by: AWS Redshift (and the related AWS products AWS Glue, Redshift Spectrum, AWS S3), Looker, Airflow, Matillion ETL, Kafka, Python, and NiFi. But we're pragmatic -- for example, we have some Java for ingesting data from Kafka, and we use Clojure for inferring schema and other information about data sets.

How To Apply

We have a non-standard application process. To jump-start the process we ask a few questions we normally would ask at the start of an interview. This helps speed up the process and lets us get to know you a bit better right out of the gate. Please make sure to answer each question.

After you apply, you are going to hear back from us, even if we don't seem like a good fit. In fact, throughout the process, we strive to make sure you never go more than seven days without hearing from us.

 About Zapier

For the past six years, Zapier has been helping people across the world automate the boring and tedious parts of their job. We do that by helping everyone connect the web applications they already use and love.

We believe that there are jobs a computer is best at doing and that there are jobs a human is best at doing. We want to empower businesses to create processes and systems that let computers do what they are best at doing and let humans do what they are best at doing.

We believe that with the right tools, you can have big impact with less hassle.

We believe in small teams. Small teams are fast and nimble. Small teams mean less bureaucracy and less management and more getting things done.

We believe in a safe, welcoming, and inclusive environment. All teammates at Zapier agree to a code of conduct.

The Whole Package

Location: Planet Earth.

Our team of 200+ is distributed because it lets us work with the best people. You don't have to be located in the USA either. Some team members live in the United Kingdom, Thailand, India, Nigeria, Taiwan, Guatemala, New Zealand, Australia, and more! You just need the skills and drive to succeed in this role and the ability to work from anywhere.

Compensation:

  • Competitive salary (we don't use remote as an excuse to pay less)
  • Great healthcare + dental + vision coverage*
  • Retirement plan with 4% company match*
  • Profit sharing
  • 2 annual company retreats to awesome places
  • 14 weeks paid leave for new parents of biological or adopted children
  • Pick your own equipment. We'll set you up with whatever Apple laptop + monitor combo you want plus any software you need.
  • Unlimited vacation policy. Plus we require you to take at least 2 weeks off each year. We see most employees take 4-5 weeks off per year. This isn't a vague policy where unlimited vacation means no vacation.
  • Work with awesome companies around the world. We partner with great software companies all over the world and you'll constantly get to interact with people from these great companies

*While we take care of our international folks as best we can, currently, healthcare and retirement plans are only available to US-based employees. Optional: Share anonymously some demographic information about yourself to help us better track trends related to the backgrounds of candidates interested in working at Zapier in order for us to build a team that represents the users at Zapier and the broader world population.

Zapier is an equal opportunity employer. We're excited to work with talented and empathetic people no matter their race, color, gender, sexual orientation, religion, national origin, physical or mental disability, or age. 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.