Data Engineer 2
About The Position
The Farmer's Dog is seeking a Data Engineer 2 to join their growing group. This role will maximize technical expertise and data analysis skills to develop, implement, and maintain data analytics solutions within the organization. The Data Engineer 2 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. This role is critical to ensure data integrity, optimize data workflows, and enable partners to make effective decision-making rooted in data. The ideal candidate has a genuine love for data, technology, problem-solving and wants to improve how The Farmer's Dog makes strategic decisions at the company level.
Requirements
- 2-4 years of experience in data engineering, software engineering, or related technical field
- Proficient in Python with experience writing production code
- Solid SQL skills for data transformation and analysis
- Practical experience with REST APIs and data integration patterns for ingesting data from multiple sources
- Familiar with data processing tools like DBT, Airflow, or similar orchestration frameworks
- Understand ETL/ELT concepts and have built data pipelines independently with minimal guidance
- Comfortable collaborating with cross-functional teams to understand data requirements and deliver solutions
- Experience communicating technical concepts effectively to both technical and non-technical stakeholders
- Detail-oriented with strong problem-solving skills
- Can manage multiple priorities effectively
- Eager to learn new technologies, expand skill set in a fast-paced environment, and take initiative to optimize systems.
Nice To Haves
- Experience or strong interest in AI/ML workflows and tooling, including data preparation for machine learning models
Responsibilities
- Build and maintain data pipelines for structured and unstructured data supporting reporting, analytics and AI/ML use cases.
- Write production-level code that processes and validates millions of events per day.
- Develop AI tooling and automation to enhance data engineering capabilities and workflows.
- Ingest data from APIs, databases, file systems, and streaming platforms into our data infrastructure, and build and maintain pipelines for structured and unstructured data that support reporting, analytics, and AI/ML use cases.
- Establish and maintain robust data governance frameworks across our data warehouse to ensure data integrity, reliability, and security across the organization.
- Implement monitoring, data quality checks, and alerting to ensure pipeline reliability and implement automated checks.
- Support production data systems and help resolve data-related incidents.
- Document technical implementations, follow engineering best practices, and foster a collaborative team environment that promotes knowledge sharing, standard methodologies, continuous improvement, and continuous learning.
Benefits
- Dog-friendly office in SoHo
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
