Apply on Employer Site

goodr · 6 hours ago

Analytics Engineer

Los Angeles

Full-time

Hybrid

Mid, Senior Level

$110K/yr - $125K/yr

4+ years exp

goodr is a company that creates and sells active eyewear with a focus on fun and authenticity. They are looking for an Analytics Engineer who will design and build robust data models in their data warehouse, ensuring data integrity and availability while optimizing system performance and costs.

Retail

No H1B

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

Qualification

Analytics EngineeringDatabase AdministrationSQLETL/ELT ProcessesData IntegrationSnowflakeFivetranDBTGit/GitHubNetSuiteShopifyCommunication SkillsOrganizational SkillsProblem Solving

Required

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 managing version control; should be proficient with Git/GitHub

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?)