Data Warehouse Architect

Muness Castle
Muness Castle / February 26, 2018

Hi there!

We're looking for a Data Warehouse Architect 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 a 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.

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

Even though our job description may seem like we are looking for a candidate with a very specific skillset, the role will be tailored to the person who applies and joins. Regardless of how well you feel you fit our description, we encourage you to apply if you meet these criteria:

You love collaborating with teammates to understand and address their data needs and help them become more effective.

About You

You have experience with data warehouses. You’ve ingested data from other systems, made sense of them, matched up data without the luxury of cross-system identities and built conformed models from them. You have experience optimizing queries, especially on column-oriented storage systems.

You are hands on. You don’t expect to come up with designs and leave implementation to others. Instead, you dig in and get stuff done.

You are a skilled written communicator. Zapier is a 100% remote team and writing is our primary means of communication. You can communicate unfamiliar technical topics clearly and approachably.

You enjoy understanding and communicating user and system behaviour through data that is easy, consistent and fast. Our data is published in a Kimball-style data warehouse to ease and speed-up access.

You will thrive with our team’s values of eagerness to collaborate with teammates with any level of data warehousing knowledge, iterating over your deliverables, and being curious.

You understand that perfect is the enemy of good and default to action by initially shipping code and systems that simply work and work simply, while iterating as needed to get towards better solutions.

Things You Might Do

Zapier is a small, fast-growing, and remote-first company, so you'll likely get experience on many different projects across the organization. That said, here are some things you'll probably do:

  • Much of the time, you’ll tackle performance issues with ad-hoc and nightly jobs.
  • Model slowly changing dimensions, transactional, periodic snapshots (we usually use daily), and accumulating fact tables.
  • Implement ETL to extract data from large, event-based data structures.
  • Collaborate with Data Engineers, Analysts, and Scientists to prioritize tasks, implement data ingestion, matching and transformation pipelines, introduce quality assurance checks throughout a data bus architecture.
  • Design, document, implement, and maintain patterns for effectively performing these tasks.
  • The tools we use today are SQL, Matillion ETL, AWS Redshift, Redshift Spectrum, Looker, Kafka, AWS Athena, Google Analytics,, Airflow, Kubernetes, Python, and R. Besides using them, you will be involved in future tool selection with the rest of the team.
  • As a part of Zapier's all-hands philosophy, help customers via support to ensure they have the best experience possible.

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 that credentials don't say everything. Our CTO has a finance degree. Our CEO has an engineering degree. Our CPO has a mechanical engineering degree. What you love doing is way more important than the credentials you have.

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.

If you want to work remote, that's great. If you want to work near others, that's cool too. Our team of 100+ 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, New Zealand and Australia. You just have to be talented!

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

Pick your own equipment. We'll set you up with whatever mac 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.

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.

Complete this form with answers to the questions below. Make sure each answer stands alone as we review question-by-question instead of applicant-by-applicant.

  1. Tell why you’d be a good fit for the role.
  2. In four sentences or less, tell us about your data warehouse and data modeling experience. You should feel free to be proud of your successes.
  3. Describe a time where dimensional modeling (Star Schema/Kimball/Inmon) techniques failed you and what you did to overcome the difficulties.
  4. Describe a time where you detected there was a problem in a data processing pipeline, and the steps you took to determine where the problem was?
  5. What ETL and analysis related tools/platforms/databases/techniques do you have experience with? Which ones do you rank yourself as an expert in?
  6. Tell us about a data analysis deliverable that you're proud of. Why did you decide to work on it? What techniques did you use and why those? Who did you work with?
  7. Tell us about a time you encountered an issue with an existing data warehouse architecture that required significant re-architecture. What approach did you take to analyze and re-architect? What problems did you run into and how did you work through them? What were the results of the redesign?
  8. Share links to sites that showcase your professional works (GitHub, LinkedIn, Twitter, Stack Overflow, a personal site, etc.) if you have some you can share. If the work is proprietary and can’t be shared, provide us with 500+ lines of code as a private gist to help us get a feel for how you write code.
  9. Is there anything else you would like us to know about you, your experience, and your application?
  10. Where did hear about this role?
  11. For interview scheduling purposes, what time zone are you located in?
  12. 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.

Finally, wait for us to reply! 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.

Apply Here

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.