Goodr is a company that creates and sells active eyewear, emphasizing fun and authenticity in their workplace culture. They are seeking an Analytics Engineer to design and build data models in their data warehouse, ensuring data integrity and supporting the analyst team with comprehensive documentation and efficient database management.
Responsibilities
- Design and build robust data models in our data warehouse (DWH) under guidance from senior team members so that our analyst team can build reports with ease
- Assist in maintaining the health, organization, and security of our DWH and corresponding integrations
- Optimize efficiency and costs based on system uptime, source system integrations, and refresh rates
- Ensure database design is optimized for both front-end and back-end users
- Respond to and troubleshoot user-reported database errors in a timely manner
- Draft, update, and maintain comprehensive documentation related to database configurations, procedures, and best practices
- Support trend analysis and system capacity planning
- Implement and maintain data distribution and disaster recovery strategies to ensure data integrity and availability
- Conduct regular disaster recovery testing
- Investigate and resolve database performance and capacity issues
- Monitor and maintain database security
- Communicate effectively with the cross-functional teams to address their needs (bilingual in nerd and business!)
- Keep the data warehouse and your work organized – more well-labeled closet, less junk drawer (Marie Kondo who?)
- Create API connections and scope new integrations - work with our ETL partners to find ways to continue integrating more data into our DWH as the business grows
- This role is in the Business Intelligence team and will report directly to the Director of Business Intelligence
- Perform other related duties as assigned
Skills
- 1+ years of hands-on experience working with database architecture, DaaS, or analytics engineering pipelines (professional roles, internships, or significant personal/academic projects accepted)
- Beginner knowledge of database design, ETL/ELT processes, and data management best practices
- Solid organizational skills including attention to detail and multitasking skills
- Proficiency in SQL is a MUST
- Experience managing version control and proficiency with Git/GitHub
- Excellent written and verbal communication skills
- Proactive and an independent problem solver
- Experience in Snowflake
- Experience in Fivetran
- Experience in DBT
- Bonus points if you have experience in NetSuite and/or Shopify
- May or may not have a degree...we don't care (bonus points for Basset Hound Science or Dinosaur Law)
- Loves Data Integration! Lives for Data Integration! Can't get enough of Data Integration!
- Excited about being a data detective–where is this data from, why is the code written this way, where does this lead? When a number looks funky, will stop at nothing to hunt down the root cause!
- Loves the work more than a paycheck
- Is happy to give away credit to their team
- Loves getting and giving feedback
- Is into personal growth
- Thinks Fun is being great (not partying)
Benefits
- Medical, Dental, and Vision benefits
- 401(K) with company matching
- Financial Wellness Counseling
- Sunglasses. Duh.
Company Overview
- Goodr is creating fun, fashionable, and functional sunglasses that everyone can afford. It was founded in 2015, and is headquartered in Inglewood, California, USA, with a workforce of 51-200 employees. Its website is https://goodr.com.