Oh Snap!
This job is no longer active - but you can still view the details below.

Data Modeler

| Greater NYC Area
WHO WE ARE

The Farmer’s Dog was created to radically improve the $90 billion global pet food industry — starting with a subscription service that sends freshly-made food directly to customers’ doors. Long term, our aim is to simplify every part of pet care, bettering the lives of the animals who make our lives better. We recently raised our Series B and are backed by early investors of Warby Parker, Dollar Shave Club, Sweetgreen, and Glossier.

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.

#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

  • Brand new dog-friendly office in Greenwich Village (complete with free-roaming friendly dogs)
  • Comprehensive Healthcare, Dental, and Vision
  • Flexible PTO and WFH policy
  • Discounted fresh food for your pup
  • Fresh breakfast, snacks and coffee for the humans
  • Strict daily belly rub quota
Read Full Job Description

Location

The Farmer's Dog is located in the heart of Greenwich Village right by Washington Square Park and NYU!

An Insider's view of The Farmer's Dog

What’s the vibe like in the office?

It's so refreshing to be able to walk into my job knowing that I'm truly making a difference. Every person on our team believes in our product and mission, so motivation and passion comes organically. Did I mention that our office is full of dogs?

Matt

Customer Experience

What projects are you most excited about?

We are changing the way people think about pet food by delivering fresh, healthy meals for dogs in personalized meal plans. Supply chain is exciting because it's basically the key differentiating factor for how we can be the most cost efficient, really impact the consumer experience for the better, and always make sure the dogs get fed.

Sana

Head of Operations

How does the company support your career growth?

I feel a crazy opportunity to grow my career the way I want to at The Farmer's Dog. We are encouraged to take risks and are surrounded by genuine, loving, and compassionate people. The culture is supportive of both dog and human health and wellness, and I love that I get to help dogs live longer lives with my dog, Emmy, by my side.

Adrian

Growth Manager

What is your vision for the company?

The Farmer's Dog is on a mission to change the way people think about feeding their pets. Our goal is to educate & give people the tools to give their pets the healthiest diet. We believe that once the world is educated about fresh food, people will stop feeding their pets processed food and the life expectancy for the entire species will increase.

Brett

Co-Founder & Head of Community

What does your typical day look like?

As CEO, I spend my days making the hard decisions, hiring the best people, protecting the team, and making sure the company is financially sound. I also get to choose which dogs are allowed in the office (all of them).

Jonathan

Co-Founder & CEO

What are The Farmer's Dog Perks + Benefits

The Farmer's Dog Benefits Overview

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 (avocado toast always)

Culture
Partners with Nonprofits
We love partnering with rescue organizations, adoption centers, and other organizations who are as passionate about dogs and dog people as we are.
Friends outside of work
Eat lunch together
Whether we're ordering in, going out, or bringing our own, we take lunch seriously.
Team owned deliverables
Group brainstorming sessions
We love a good offsite and have regular all-hands meetings led by the co-founders.
Open office floor plan
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
Company Equity
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
More Jobs at The Farmer's Dog14 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Product
Content
Marketing
new
New York
Operations
new
New York
Marketing
new
New York
Content
new
New York
Data + Analytics
new
New York
Developer
new
New York
Data + Analytics
new
New York
Design + UX
new
New York
Operations
new
New York
Design + UX
new
New York
Finance
new
New York
Finance
new
New York