Data Warehouse Lead at The Farmer’s Dog
New York City, NY, US

WHO WE ARE

The Farmer’s Dog exists to simplify giving every dog their best life. First up? Completely reimagining what pet food is, how it’s made, and how it’s delivered. We recently raised our Series B and are backed by the early investors of Warby Parker, Dollar Shave Club, Sweetgreen, and Glossier.

Our company was launched after our Co-founder, Brett’s, battle to cure the stomach issues of his Rottweiler, Jada. He quickly realized just how broken the commercial pet food industry was - even the “organic” and “natural” varieties proved to be heavily processed - and it was only when his vet recommended a fresh, home-cooked diet that Jada began to improve and was eventually cured. Through a combination of proprietary technology, and a lot of heart, our direct-to-consumer service was born.

Join The Farmer’s Dog team as we continue to figure out ways of bringing peace of mind to customers, health to their companions, and much-needed change to the way people feed and care for their pets.

Only “dream job” applicants, please. #mustlovedogs

WHAT'S THE ROLE?

At The Farmer’s Dog, we have a very strong culture of making data-driven decisions. The Data Strategy & Insights team, specifically, works on constantly bringing our whole organization to higher levels. We turn green into yellow and blue.

As the team’s resident engineer, you will own the data models and get to contribute to many of the key architectural decisions. You will leverage your strong knowledge of BigQuery to help our entire team and larger organization more quickly get to strong insights.

This is an extremely unique role (and open to re-titling as appropriate). If you love data, especially in JSON form, wrangling it, thinking about it, designing all aspects of it, and using all the fun tools associated with it, we want to hear from you!

The person filling this role will work closely with the department head and collaborate with all members of the data team and engineering team. This is a hybrid engineering / analytics / modeling / architecting role.

KEY RESPONSIBILITIES 

  • Own the BigQuery datawarehouse
  • Model and wrangle our myriad datasets in manners that are most fitting to larger needs and business objectives
  • Own the ETL pipelines
  • Collaborate with the rest of the data team to assess the needs of the company, and organize our warehouse to best support those needs.

QUALIFICATIONS

  • Expertise with Big Query (non-legacy)
  • Strong love for JSON and semi-structured data
  • Ability to model data in multiple ways, as appropriate to larger objectives
  • Ability to “think in data” (relating the real-world to its data abstraction, and vice-versa)
  • History having stood up data warehouses from ground up (does not need to have been GCP)
  • Familiarity with BI tools such as Looker a plus, but not required
  • Familiarity with dbt a plus, but not required
  • Natural curiosity
  • Highly organized individual
  • Must play nicely with others (humans and dogs)
  • Prefer dogs to other species.

PERKS & BENEFITS

  • Dogs everywhere!
  • Brand new dog-friendly office in Greenwich Village
  • Discount on TFD food for your pup!
  • Comprehensive Healthcare, Dental and Vision
  • Unlimited vacation & sick days
  • Flexible work-from-home policy
  • Team outings, coffee always brewed fresh, and a strong snack game