Analytics Engineer 2

Salary

$133,000.00 - $145,000 USD Annual

Location

New York, New York, United States

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.

How You'll Make An Impact

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.

We're Excited About You Because

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.

‌