Ritual
Culver City, CA
51-200 employees
Daily essentials with good intentions — for living life or creating it.
Prior Listings
Data Analytics Engineer
Data Analytics Engineer
This job is no longer open
About Ritual
Based in sunny Los Angeles, Ritual is a direct-to-consumer health brand that believes it’s crucial to know not just what you’re putting into your body, but why you need it in the first place.
We’re transparent about our ingredients, where they're sourced from, and have spent years conducting extensive research behind each of the premium nutrient forms we use. Our products are simple, effective, and backed by science. Our mission is simple: to empower people to feel their best by turning healthy habits into a ritual.
We have built a team of curious skeptics, world-class scientists, unconventional artists, expert marketers and analytical strategists that are on a mission to reinvent an entire industry. We’re well-funded, growing quickly, and committed to our mission. If you’re a team player who refuses to settle for the status quo, we want you. Welcome to your new daily Ritual.
Position: Data Analytics Engineer
Reports to: Head of Data Analytics
Location: Remote
Essential:
The Data Analytics Engineer will be responsible for designing and building data models to clean and transform data sets, empowering end users’ ability to answer their own questions. You will work closely with the Director of Data and Analytics and various stakeholders on coming up with new data models and exploring new data sources to add to our Analytic Data Warehouse.
What You'll Do:
- Manage data loading platforms to make sure of timely incoming raw data to Snowflake database.
- Collect requirements from cross-department stakeholders to design and implement sophisticated data models in SQL for end user consumption inside Looker.
- Design customized data tests to guarantee quality of data model results.
- Clearly document data models with source, description and field definitions for better collaboration and end user experience.
- Help build and maintain Looker Models and Explores as well as provide training for business users on how to best utilize provided data.
Who You Are:
- Detailed-oriented: Excellent organizational skills and detail-oriented.
- Team Player: Exceptional teammate who establishes positive working relationships.
- Communication: Good communication skills with the ability to express sophisticated concepts effectively.
- Multi-tasking: Demonstrated ability to multitask in a dynamic environment.
What You'll Need:
- Education: BS or MS Degree in Computer Science, Mathematics, Statistics or a related technical field.
- Experience: 3+ years of experience developing ETL workflow with SQL, preferably working with Snowflake.
- Experience: 2+ years of experience with Business Intelligence tools such as Looker and Tableau with Looker preferred.
- Practical experience establishing and utilizing data analytics standard methodologies.
- Experience with transactional data processing, ETL, data warehouse, data mart, and operational reporting solutions is preferred.
- Experience with DBT and Fivetran highly preferred.
- Data science and machine learning model building experience with interest in broader E-commerce projects such as recommendation engine, attribution modeling, demand forecast, LTV modeling and customer segmentation is welcomed.
Why Ritual?
Since launching in October 2016, Ritual has grown to be a cultural revolution in the health industry. We’re not about pseudoscience, half-truths or health fads. We are simple, effective, and backed by real science. We have some pretty great benefits & perks related to our office environment, however, they have been limited due to the global health situation. See below for our perks available to Ritual's full-time employees!
Medical/Dental/Vision/Life Insurance
Healthcare & Dependent Care FSA
Equity participation
401k Match - Up to 4%
Pet Insurance
Free Ritual Forever
Unlimited PTO - 10 days minimum to keep you fresh
18 paid holidays
Bi-Annual Performance Reviews
“Ritual First Fridays” - Entire company takes off the first Friday of each month to take additional time away to focus on your health
12 weeks paid maternity/paternity leave and we cover health insurance during any additional time taken under-protected baby bonding time off
Periodic group workouts with trainers on Zoom
Work from Home stipend
Childcare stipend (monthly expense)
Flex time for returning to work birth-parents
Ritual is an Equal Opportunity Employer. We are committed to bringing together humans from different backgrounds and perspectives, providing employees with a safe and welcoming work environment free of discrimination and harassment. We strive to create a diverse & inclusive environment where everyone can thrive, feel a sense of belonging, and do impactful work together.
This job is no longer open