Analytics Engineer II

August 1

Apply Now

Receive Emails with Similar Jobs

Ollie

WebsiteLinkedInAll Job Openings

Premium Pet Food • Home Delivery • Healthy Food • Direct to Consumer

51 - 200 employees

👥 B2C

🛍️ eCommerce

Description

• 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

Requirements

• 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!

Benefits

• 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!