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 and health services for members, dogs can truly live their healthiest, happiest lives.
As a member of our growing team, you’ll take part in a company culture that cares deeply about its work and its team members.
As we continue to grow, we’re seeking an Analytics Engineer II to join our Data Platform team. You’ll work your magic at the intersection of data engineering and business analytics, crafting the models, pipelines, and tools that keep our business growing and our hungry pets thriving.
In this role, you’ll report to our Data Platform Lead and collaborate closely with our Analytics team to build and maintain a data infrastructure that’s robust, dependable, and actionable. This is your chance to sink your teeth into complex data problems and make a lasting impact on both pet health and our eCommerce operations. We’re looking for someone who’s passionate about data, thrives in a collaborative environment, and is excited about the challenges of a rapidly growing business. If you’re ready to tackle complex data problems and help shape the future of pet nutrition, we want to hear from you.
This role is ideally based remotely in the northeastern U.S., but we’re open to exceptional candidates from other locations.
What You'll Do: Design and implement analytical data models using SQL in dbt and Snowflake, focusing on accuracy, performance, and scalability for our eCommerce businessOwn and maintain the semantic layer of our data modeling, defining and managing metrics, dimensions, and joins to ensure consistent and accurate reporting across the organizationCollaborate with the Analytics team to understand their data needs and translate them into effective data models and metricsOwn the implementation and maintenance of our Segment tracking plan, ensuring comprehensive and accurate event tracking across our digital propertiesSupport the Product team in their use of Mixpanel for event analysis, ensuring alignment between Segment data and Mixpanel insightsDevelop and maintain self-service analytics strategies for Lightdash and Looker, empowering business users to access insights independently from our teamAssist in documenting data lineage, definitions, and usage guidelines to promote data literacy across the organizationCollaborate with the Sr. Data Engineer and Sr. Machine Learning Ops Engineer to ensure analytics infrastructure aligns with broader data platform initiativesWho You Are: 3+ years of experience in analytics engineering, data engineering, or a related field, preferably in an eCommerce or subscription-based businessStrong proficiency in SQL and experience with dbt, with a focus on dimensional modeling for business intelligenceHands-on experience with Snowflake or similar cloud data warehouses, and familiarity with data pipeline developmentExpertise in Segment implementation, including structuring tracking plans and designing event properties for comprehensive analyticsFamiliarity with event analytics tools like Mixpanel, and an understanding of how to align event data across platformsExperience with business intelligence tools such as Lightdash, Looker, or similar platforms for creating self-service analytics dashboardsSolid understanding of eCommerce metrics and KPIs, and how to model data to support their calculation and analysisStrong analytical and problem-solving skills, with the ability to translate business questions into data models and queriesProactive and self-motivated, with the ability to manage projects and priorities in a fast-paced environmentEnthusiasm for learning and adapting to new technologies and methodologies in the rapidly evolving field of data analyticsThis is not a checklist, so if you don’t have all of these, apply anyway!What You'll Get:Competitive salary and a stake in the companySponsored 401k program with employer match up to 4%Comprehensive health coverage including medical, dental and visionUnlimited vacation policy that you're encouraged to usePaid parental leave1-week paw-ternity leave for new dog parentsFree Ollie subscriptionInspiring pack members!What We Value:
Keeping Dogs At The Heart
Our profound love for dogs unites us and drives and inspires every aspect of our business. We wholeheartedly believe dogs make us better in life and at work.
Being Courageous And Kind
We create a safe, inclusive space for everyone to show up as their authentic selves. We check our egos at the door and speak our minds. We embrace diverse backgrounds and perspectives as they bring new and different ideas and ways of working together.
Setting New Standards
We believe in continually raising the bar, never settling for less than our best as a team and individuals. We keep improving from the quality of our products to our customer experience to how we work.
Making Ollie The Best Chapter
We are building an impactful business while making memorable experiences with one another. We celebrate our successes, learn from our failures, and enjoy our collective journey. Our time at Ollie should be a milestone in our careers.
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.