Analytics Engineer 2

The Farmer’s Dog was born from a mission to change the landscape of pet health, providing dogs and their humans with honest, smart, and simple care. We’re starting by radically improving the $90 billion pet food industry, replacing bags of highly-processed pellets with a personalized subscription service that sends complete and balanced, freshly-made dog food directly to customers’ doors. Our ultimate goal is to create innovative, delightful and personalized experiences across all aspects of pet care, and we believe our direct-to-consumer business model, holistic approach to growth, and dynamic culture uniquely position us to shepherd this backwards industry into the future.
To date, The Farmer’s Dog has delivered over 1 billion meals nationwide and raised over $150M in funding to help us build a company as healthy as the dogs who are eating those meals. Join us as we continue to develop 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.

#LongLiveDogs

The Farmer’s Dog is seeking an Analytics Engineer 2 to join our growing team, with a focus on supporting Operations data!  You will maximize your technical expertise and data analysis skills to develop, implement, and maintain data analytics solutions within the organization. This role will collaborate with cross-functional groups - including data scientists, data engineers, and business partners to gather requirements, design data models, build data pipelines, and deliver practical insights. Your role will be critical to ensure data integrity, optimize data workflows, and enable effective decision-making. If you have a genuine love for data, technology, problem-solving and want to improve how The Farmer’s Dog makes strategic decisions at the company level, then this is the role for you!
One Team: We don’t think of ourselves as “Acquisition Marketers”, “Engineers”, “Data Analysts”, or “Product Managers”. Beyond denoting skill sets and areas of expertise, we don’t think departments matter. We’d rather align ourselves to the goals we’re working to achieve and make sure we have necessary subject matter expertise to drive meaningful impact. We strive to orient ourselves around customer problems TOGETHER – getting the right people, with the right context, in the right rooms/Zooms to solve problems holistically.

We are skeptical about everything and precious about nothing:  Ideas can and should come from anywhere, and we aren’t tied to our own. We proactively source input. We talk to our customers and leads regularly and are quick to change course if we know there’s a better or more impactful way to solve problems.

We consider the customer journey in all of our decisions:  We know that no interaction exists in a silo and therefore understand how important every single one is.  We ensure our strategy sets prospective and new customers up for success and drives long-term retention.  We answer questions and address problems early and proactively.  We understand the value of different channels, initiatives, and messages and know how to articulate impact and advocate for prioritization holistically.

We Execute For Impact: We don’t subscribe to “best practices” or “industry KPIs”. We’re uninterested in how we compare to “benchmarks”; instead we orient ourselves around being the best we can possibly be. Similarly, we don’t subscribe to rigid or classical expectations of roles – i.e. acquisition is hyper-focused on improving customer retention and experience.

We Are Focused and Work Without Assumption: We are not beholden to ideas. We have goals and believe everything beyond that is a series of hypotheses to validate. To that end, we seek to work in sequence and not in parallel. We constantly ask ourselves, “what’s the most important hypothesis I should be working on right now? How do I confirm or reject that hypothesis as fast as possible?”. We rarely have timelines/deadlines and are constantly taking in new information and adjusting our priorities accordingly. We don’t expect to be perfect the first time.

• Collaborate with data analysts, data scientists and operations business partners to understand their analytical requirements and translate them into data models and technical specifications.
• Develop and maintain data models, schemas, analytical frameworks, and databases to support flexible data analysis and reporting of our supply chain processes
• Identify and resolve data quality issues, ensuring accuracy, consistency, and completeness.
• Stay up to date with emerging trends and technologies, evaluating their potential for adoption and driving innovation.
• Monitor and optimize the performance of data pipelines, databases, and analytics systems to ensure efficient processing and retrieval of our data.
• Act as a subject matter expert, providing guidance on complex analytics projects and initiatives, using storytelling to support our analysts in articulating nuances in our data to partners.
• Design and optimize queries to extract valuable insights from complex and large-scale datasets.
• Apply data visualization tools and techniques to communicate analytical findings to technical and non-technical partners.
• Communicate complex technical concepts and project progress in a clear and concise manner to non-technical partners.
• Work closely with data engineers and analysts to integrate analytics solutions into existing systems and applications.
• Foster a collaborative and innovative team environment, promoting knowledge sharing, standard methodologies, and continuous learning.

• You have 2-4 years of experience in a data engineering or analytics role, with a focus on designing and implementing data analytics solutions.
• You are proficient in SQL, as a requirement; Experience with Python or R is a plus. 
• You have experience with DBT and Looker
• You have a strong background in data manipulation, analysis, and visualization
• You are familiar with data modeling and standard methodologies.
• You have working knowledge of data warehouse technologies and cloud platforms (e.g. AWS, GCP).
• You have strong problem-solving skills, attention to detail, and ability to work with complex datasets.
• You are skilled at connecting dots across multiple analytics requests to design re-usable and self-service analytics frameworks
• You seek to share your knowledge to help others work more efficiently
• You are able to thrive in a fast-paced and ambiguous environment, are naturally curious and a proactive self-starter that seeks new opportunities and solutions.
• You are proactive and excel in managing multiple projects simultaneously. 
• You love dogs.

We are an in-office culture, made of in-office people who thrive on the collaboration and magnetism of working in a shared space. We are seeking individuals who excel in this type of environment, where being present fosters deeper connections and engagement.

Our company’s mission is rooted in deep, genuine care for dogs – and for the people who love them. As an organization we are full of individuals who are unique in many ways, but all united in a mission of providing true peace of mind to dog lovers everywhere. Fixing this industry and improving the lives of pets and their people will be a difficult, decades-long endeavor. We believe the best use of our time, energy, and resources as a collective team is to focus on this mission, and on supporting our team to do their best work and be their best selves. In support of this we’re committed to supporting a diverse workforce, and investing in internal structures, opportunities, and training that create and sustain an inclusive team. We strive to provide an experience at TFD that will be invested, meaningful and memorable as we progress on the journey to reimagine how we feed and care for our pets.

• Dog-friendly office in Greenwich Village
• Market-competitive compensation and equity packages
• Comprehensive Healthcare, Dental, and Vision
• Company supported mental health benefits
• 12 week paid parental leave
• Competitive 401k plan with company match
• Flexible PTO 
• Discounted fresh food for your pup
• Your pet interrupting video calls (and in-person meetings) is now a feature, not a bug

We commit to building a competitive compensation package and company environment for all individuals to thrive. We believe in competitive base compensation rooted in location specific market data and performance along with equity ownership in the company that allows every team member to build their personal wealth as the company grows, just as much as we believe in fostering a culture that supports our team members personally, professionally, and holistically. For this role the anticipated hiring base compensation range is $133,000.00 - $145,000 USD Annual and the compensation offered will include a robust market competitive package of base and equity. In addition to your base compensation offer you will also receive equity ownership in the company. More information about the value of this equity will be shared at the time of offer. This range is representative of NYC Market Data if you are applying to this role outside of the NYC area the range may change.

The Farmer's Dog, Inc. is an equal employment opportunity employer and does not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religion, creed, national origin, physical or mental disability, protected veteran status or any other legally protected characteristic or status. For more information, please visit Know Your Rights.

TFD complies with applicable federal, state, and local disability laws and makes reasonable accommodations for applicants and employees with disabilities.  If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [email protected].