Ollie Pets

New York, NY

51-200 employees

On a mission to give dog food a good name. Ollie delivers freshly made food from real, human-grade ingredients, tailored to your dog's unique nutritional needs.

Other Open Roles

Prior Listings

Other Jobs in Data Engineering

See all

Analytics Engineer

Ollie Pets

Analytics Engineer

Data Engineering

This job is no longer open

Ollie was born with the mission of improving the lives of pets and pet parents nationwide. We make human-grade pet food, tailored for each dog’s nutritional needs, and deliver directly to our customers’ doors. Through Ollie’s carefully crafted meals, dogs can truly live their healthiest, happiest lives.

We are a U.S. based distributed team and are backed by the same venture capital companies behind Instacart, Warby Parker, Glamsquad, Mirror, Prose, and Allbirds.

The Data Team at Ollie is responsible for empowering functional teams with the data they need to make data-driven decisions, as well as proactively surfacing actionable insights and recommendations. As an Analytics Engineer at Ollie, you will have an active role in driving impact in our business by setting up our analysts and business users for success. In this role, you will be responsible for maintaining data pipelines and providing clean and accurate data sets for all analysts and business users to leverage.

Responsibilities

Write production-quality ELT code with an eye towards performance and maintainability
Design, develop, and extend dbt code to clean and transform raw data into easily querible tables
Create and maintain systems documentation and a data catalog for business users
Act as the code owner for specific database and data model schemas and approve data model changes
Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models

Preferred Experience

2-3 of experience in data field as an analyst or engineer
1+ years of experience building and maintaining dbt scripts
Ability to assess business needs and translate them into appropriate data designs
General understanding of distributed version control systems, e.g. Git
Solution-oriented, independent, and able to communicate across different departments

Bonus Points

Familiarity with Snowflake, Stitch, dbt and Looker
Experience with Apache Airflow and Snowpipes

Benefits

Competitive salary and a stake in the company
Sponsored 401k program with employer match up to 4%
Comprehensive health coverage including medical, dental and vision
Unlimited vacation policy that you're encouraged to use
Paid parental leave
1-week paw-ternity leave for new dog parents
Ollie subscription for one dog
Inspiring pack members!

If you'd like to stand out, tell us in your cover letter why you're interested in joining Ollie and how your skills match the responsibilities detailed in this posting.

Ollie embraces diversity and equal opportunity. We're committed to building a team that represents a variety of backgrounds, perspectives, and skills. Ollie is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please include that in your application.

This job is no longer open