Analytics Engineer II
Ollie
Data Science
Remote
Posted on Tuesday, July 30, 2024
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 business
- Own and maintain the semantic layer of our data modeling, defining and managing metrics, dimensions, and joins to ensure consistent and accurate reporting across the organization
- Collaborate with the Analytics team to understand their data needs and translate them into effective data models and metrics
- Own the implementation and maintenance of our Segment tracking plan, ensuring comprehensive and accurate event tracking across our digital properties
- Support the Product team in their use of Mixpanel for event analysis, ensuring alignment between Segment data and Mixpanel insights
- Develop and maintain self-service analytics strategies for Lightdash and Looker, empowering business users to access insights independently from our team
- Assist in documenting data lineage, definitions, and usage guidelines to promote data literacy across the organization
- Collaborate with the Sr. Data Engineer and Sr. Machine Learning Ops Engineer to ensure analytics infrastructure aligns with broader data platform initiatives
Who You Are:
- 3+ years of experience in analytics engineering, data engineering, or a related field, preferably in an eCommerce or subscription-based business
- Strong proficiency in SQL and experience with dbt, with a focus on dimensional modeling for business intelligence
- Hands-on experience with Snowflake or similar cloud data warehouses, and familiarity with data pipeline development
- Expertise in Segment implementation, including structuring tracking plans and designing event properties for comprehensive analytics
- Familiarity with event analytics tools like Mixpanel, and an understanding of how to align event data across platforms
- Experience with business intelligence tools such as Lightdash, Looker, or similar platforms for creating self-service analytics dashboards
- Solid understanding of eCommerce metrics and KPIs, and how to model data to support their calculation and analysis
- Strong analytical and problem-solving skills, with the ability to translate business questions into data models and queries
- Proactive and self-motivated, with the ability to manage projects and priorities in a fast-paced environment
- Enthusiasm for learning and adapting to new technologies and methodologies in the rapidly evolving field of data analytics
- This 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 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
- Free Ollie subscription
- Inspiring 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.