Impact Workers

09/06/2023

CLOSED – Sr. Data Engineer

About the role

At Dr. Squatch (www.drsquatch.com) we’re raising the bar on men’s personal care with our line of natural, high-performance products. We’re on a high-growth, fast-moving ride, continually introducing new product categories, launching into retailers nationwide, and growing internationally. We recently earned a Great Place to Work® Certification™ and are looking for passionate, talented people who want to join us in our mission to inspire and educate men to be happier and healthier!

 

About the Role:

Dr. Squatch is looking for a talented Sr. Data Engineer to join our Data team. The Sr. Data Engineer will be responsible for ensuring high-quality, accurate data modeling (we use dbt), working with our data engineering team to ensure that our raw data is complete and accurate, and helping data analysts and others on the Data team transform raw data into clean, modeled data that is ready for analysis by end users. This role will have a high level of autonomy and will play a key part in selecting and optimizing the tools we use and the way we transform data at Dr. Squatch.

Our Data team operates a modern data stack built on Snowflake (data warehouse), Fivetran (ETL), Prefect (orchestration), dbt (transformation/modeling), and Monte Carlo (data observability / data quality).

This role will report to the Associate Director, Analytics & Strategy.

This is a full-time, hybrid role with company benefits based in Marina del Rey, California.

The anticipated base compensation range for this role will be $120,000 to $160,000. Compensation will be commensurate with the candidate’s experience and local market rates.

 

What You’ll Do:

  • Take ownership over our data architecture, managing, selecting, and improving the tools we use to store, load, transform, and visualize data
  • Help us improve our ETL processes (improving reliability and data quality) for difficult data sources, especially those that can’t be run through Fivetran; this could include finding new ETL tools or building data pipelines yourself
  • Design, build and optimize data models in our data modeling layer (dbt), reducing runtime and decreasing unnecessary complexity
  • Be a champion for efficient, effective data modeling, reviewing pull requests, suggesting improvements, and helping/coaching others on the team to write better code
  • Implement testing, validation, and documentation to flag and resolve issues with poor-quality data
  • Proactively seek out and explore new technologies to advance our data capabilities
  • Architect and maintain pipelines for moving data into third-party tools, furthering our personalization capabilities

 

About You:

  • 3+ years of experience in a data/analytics engineering role
  • Expert SQL skills
  • Experience working with cloud data warehouses
  • Experience working with business intelligence solutions
  • Proficiency with a scripting language like Python
  • Experience owning / maintaining / improving ETL processes, either using tools like Fivetran or by building data pipelines / connecting to APIs directly
  • Enthusiasm for writing clean code
  • Excellent at creating a peer-reviewed, version-controlled, and well-documented environment
  • Experience using dbt (strongly preferred)
  • Experience using Snowflake
  • Experience in Looker preferred
  • Familiar with Git preferred
  • Experience in eCommerce/direct to consumer businesses preferred
  • Excellent communication skills
  • Interest in health and wellness, personal care, and/or eCommerce industries
  • Someone who gets things done without perfect resources is innovative and works with a sense of urgency
  • Someone who has high standards takes ownership and is invested in the outcome
  • Someone who enjoys working with data and applying the insights you find in it
  • Someone who proactively helps others stays positive and has a good sense of humor

 

Who We Are:

Our core values come naturally and make us a better, more whole, and unique team. We are Scrappy – we get things done, we find a way, we act with urgency and we maintain a start-up mentality. We Play to Win – we have high standards, we encourage ownership of work, we are “hungry” and we invest in the outcome of our work. We have a Team First Mentality – we are humble, help others outside our own wheelhouse, stay positive and have fun.

We offer a competitive salary in a growth-focused & collaborative team environment. Benefits include medical, dental, vision, 401k with Squatch match, and PTO. We also have great perks like healthy snacks, frequent company events, and of course, free products!

 

Diversity, Equity & Inclusion @ Squatch:

We firmly believe that Team Squatch is a place for everyone and we’re proud to be an equal opportunity employer who is committed to inclusion and diversity. We do not discriminate based on any characteristic protected by federal or state law. We embrace differences and are building a company and culture that is represented by a variety of backgrounds, perspectives, life experiences, and skills.

For Applicants with Disabilities. Reasonable accommodation will be made so that qualified applicants with disabilities may participate in the application process. If you need any accommodations during the hiring process, please let us know when you submit your application and we’ll do our very best to adjust as needed.

For Information regarding Data Privacy, please review https://www.drsquatch.com/pages/privacy-policy.

Unsolicited Resume Policy. Dr. Squatch (“DRSQ”) employs an internal Talent Acquisition department. Exceptionally, DRSQ may choose to supplement that internal team with support from temporary staffing agencies, placement services, and/or recruiting agencies (“Agency”). Agencies are hereby specifically directed NOT to contact DRSQ employees directly in an attempt to present candidates. DRSQ’s Talent Acquisition team is responsible for all candidate presentations to our hiring managers.

To protect the interests of all parties, Dr. Squatch will not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to DRSQ, including unsolicited resumes sent to a DRSQ email address or mailing address, directly to DRSQ employees, or to DRSQ’s resume database will be considered property of Dr. Squatch.

DRSQ will not pay a placement, service or other fee for any placement resulting from the receipt of an unsolicited resumeThis also includes partial resumes, LinkedIn profiles, general candidate profiles, and/or candidate details or information. DRSQ will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees.

DRSQ’s Talent Acquisition team must provide advance written approval to an Agency to submit resumes and/or profiles for a specific job-opening, and the approval must be in conjunction with a valid fully executed staffing, placement or other service agreement. DRSQ will not pay a fee to any Agency that does not have a fully executed agreement in place prior to submission, receipt and placement of candidates.

Dr. Squatch

Manufacturer of personal care products intended for men’s grooming. The company offers products such as bar soaps, beard oil, hair care, deodorant and cologne, enabling customers to feel nourished and healthy as well as smell good.

Certified B-Corporation
Size: 201-500
Funding Level: Seed
Year Founded: 2013

Share this job