Analytics Engineer

ABOUT GOODR

We create and sell active eyewear for anyone. No Slip. No Bounce. All Polarized. All Fun. Interested in joining our team? Keep reading.

OUR VALUES: We have two core values: Fun & Authenticity.

• FUN = Being sh*tty isn’t fun. Agreed? Taking pride in your work, finding joy in being GREAT, and celebrating wins… and losses. Now, that’s fun!
• AUTHENTICITY = Focusing on being authentic over being liked. (Next-level guru stuff. Count it.)

Fun Fact: We do not allow email to be sent internally. Carrier pigeons only. JK, we use Slack.

AUTONOMY: We practice autonomy, empowerment, and accountability so that every team member can be in control of their own life.

• HYBRID WORKING: This role is required to be in the Inglewood office every Tuesday and Thursday with the occasional third day thrown in.
• PROFESSIONAL DEVELOPMENT: We have an all-company learning program so that we’re constantly leveling up our skills.

SUSTAINABILITY: We think Earth’s pretty rad. That’s why we take action wherever possible to limit our impact on the planet.

• 1% FOR THE PLANET MEMBER: 1% of goodr’s annual sales go directly to environmental organizations.
• CARBON NEUTRAL: In 2019, goodr became a 100% carbon neutral company.

Fun Fact: goodr celebrates every Earth Day by releasing limited-edition sunglasses with frames made from 100% recycled materials—and the packaging is 100% sustainable, too!

ABOUT THE ROLE

Look, we’ve already done the hard part. We’ve scrubbed our data until it sparkles like a fresh pair of "Flamingos on a Booze Cruise" sunnies. We’ve got a warehouse that’s cleaner than Carl’s private cabana, and our database models are purring like a kitten in a sunbeam.

But here’s the thing: a clean house is no fun if you can't find the snacks.

We’re looking for an Analytics Engineer who looks at a Star Schema and sees a work of art. We need someone who doesn’t just "do data"—we need someone who wants to take our existing, pristine data tables and dance with them.

If you get a tingly feeling in your soul when a Fact table and a Dimension table join perfectly on a primary key, you’re in the right place. We aren’t looking for a "Data Janitor" to mop up spills; we’re looking for an Architect of Insight who can walk into our beautifully designed data neighborhood, learn the street names, and start building skyscrapers of logic on top of it.

Are you ready to be the keeper of the Schema? To protect the purity of our cleaned data? To ensure our metrics stay as polarized as our lenses? Then read on!

RESPONSIBILITIES

• Design and build robust data models in our data warehouse (DWH) so that our analyst team can build reports with ease
  
• Maintain 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 user-reported database errors in a timely manner
  
• Manage relationships with DWH provider
  
• Determine, document, and enforce comprehensive documentation related to database configurations, procedures, and best practices
  
• Perform 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
  
• No direct reports – you get to focus on the fun stuff without managing your fellow flamingos
  
• This role is in the Business Intelligence team and will report directly to the Director of Business Intelligence
  
• Perform other related duties as assigned
  
  

ABOUT THE IDEAL CANDIDATE 

• May or may not have a degree...we don’t care (bonus points for Basset Hound Science or Dinosaur Law)
• Asks a lot of questions 
  
• 4+ years experience in analytics engineering, database administration, database architecture, or Data as a Service (DaaS)
  
• Solid organizational skills including attention to detail and multitasking skills
  
• 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!
  
• Possess advanced knowledge of database design, ETL/ELT processes, and data management best practices
  
• Proficiency in SQL is a MUST
  
• Experience in Snowflake (preferred), Fivetran, and DBT
  
• Experience managing version control; should be proficient with Git/GitHub
  
• Bonus points if you have experience in NetSuite and/or Shopify
  
• Excellent written and verbal communication skills
  
• 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) 
  
• Is proactive and an independent problem solver! (Can you google a question?)
  

WHAT YOU GET

• A role at a company that is going to the moon
• The opportunity to show up every day and have fun
• The ability to learn and grow as a person
• Paid vacation (we encourage you to take time off!)
• Flexible work environment (want to go for a run at 11am on Wednesday, go for it!)
• Paycheck... obviously. Salary range: $110k - $125k, final number dependent on experience
• Medical, Dental, and Vision benefits
• 401(K) with company matching
• Financial Wellness Counseling
• Sunglasses. Duh.

**No Visa Sponsorship is available for this position.

NEXT STEPS

Here's what we expect the hiring process for this role to be, should all go well with your candidacy. This entire process is expected to take 8 weeks to complete and you'd be expected to start on a specific date. 

1. Application

2. Fill out a form with basic questions

3. 35 minute introductory interview with HR team member

4. 30 minute virtual interviews with peers and manager

5. Final assignment and presentation

6. Offer!

TO GET THE PROCESS STARTED, REVIEW & SUBMIT THE FOLLOWING: 

• Review goodr's Applicant Privacy Policy. By submitting an application to goodr, you are confirming that you have read the Applicant Privacy Policy and agree to its terms. (Because nothing says “fun” like reading legal documents!)
• Resume
• Cover letter showing your personality. Seriously. No boring corporate speak allowed.
• Links to projects or groups you’re involved with (if you have them)
• A drawing of an octopus fighting a pirate (not joking)*
• We may ask you to enter a code. But don't worry, it's just our attempt to keep the bots at bay.

*We accept submissions using accessibility tools. 

#LI-Hybrid