Sr. Data Engineer

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

#LI-BD1