Feature Of The Month

Job Details

Since these are all work from home, freelance, contract and telecommute jobs, you can be based anywhere and still apply, providing you meet the employer's requirements. However, there are times when the employer will ask for applicants from a specific location, this will be clearly stated in the job posting below.

Title: Data Analyst
Date Posted: 2017-12-26
Location: St. Louis, MI
Hi there!

We're looking for a Data Analyst 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. We hope you'll take the leap of faith and apply.

Our Commitment to Applicants (https://zapier.com/jobs/our-commitment-to-applicants/)
Culture and Values at Zapier (https://zapier.com/jobs/culture-and-values-at-zapier/)
Zapier Guide to Remote Work (https://zapier.com/learn/remote-work/)
Zapier Code of Conduct (https://zapier.com/jobs/zapier-code-of-conduct/)
Diversity and Inclusivity at Zapier (https://zapier.com/jobs/working-on-diversity-and-inclusivity/)

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 to collaborate with data scientists, engineers, and business or operations experts to understand and address their data needs.


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 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 appreciate our team's values of eagerness to collaborate with teammates from any function of the organization or with any level of statistical knowledge, iterating over your deliverables, and being curious.

You understand that perfect is the enemy of good and default to action by shipping MVP code and iterating as needed to get towards better solutions.

You love being a Data Analyst
You can communicate about technical topics without too much jargon. You translate unfamiliar data modeling concepts into approachable ones to teammates with less data experience.

You have worked with columnar-store databases. You've used or even administered databases in an environment involving Postgres, Redshift, or Snowflake.

You have experience in ETL development. You've used tools like Matillion ETL, Apache Airflow, Pentaho Data Integration/Kettle, SQL Server Integration Services, Snaplogic, or Informatica.

You have experience visualizing data. You've used tools like Tableau, Qlikview, PowerBI, Looker, or Periscope Data.

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:

Developing ETL to transform data from upstream databases or our Data Lake into a data warehouse. The tools you'll use include AWS Redshift SQL, Kafka, Matillion ETL, and custom Python or R jobs.
Data modeling, including designing and expanding slowly changing dimensions and fact tables.
Improving the performance of existing transformation jobs or SQL queries.
Assisting teammates using the data warehouse in putting together visualizations, queries, and dashboards. Tools used include SQL and Looker. If you're so inclined we've also used ggplot2, Shiny, R Markdown and Jupyter notebooks.
As a part of Zapier's all-hands philosophy (https://zapier.com/learn/customer-support/everyone-on-support/), help customers via support to ensure they have the best experience possible.

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.

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 (https://zapier.com/jobs/zapier-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, 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.


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 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 (https://zapier.com/apps)
*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 (https://mgezo.wufoo.com/forms/demographic-questions/) 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 (https://zapier.com/jobs/zapier-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.

Apply via this link only:

keyword: data analyst


Like us on Facebook

Follow us on Twitter
Company: Zapier Inc.
Contact person: Not mentioned
Contact information: jobs@zapier.com (APPLY VIA THE LINK ABOVE ONLY)