Senior Associate, Data Engineer

Summary

Join Nutrafol's growing data engineering team as a key member, contributing to data-driven decisions and providing critical business insights. You will transform business requirements into technical solutions, develop data schemas, monitor data quality, and troubleshoot database issues. This role requires strong SQL skills, experience with data warehousing (Snowflake preferred), and the ability to collaborate with cross-functional teams. You'll be instrumental in building robust data models for various projects, including ad-hoc analysis and data visualization. Nutrafol offers a fast-paced, entrepreneurial environment with a focus on data-driven decision-making. The ideal candidate is detail-oriented, enjoys connecting data across multiple business views, and thrives in a collaborative setting.

Requirements

• 2-3 years of experience in a relevant Data & Analytics role within an eCommerce environment; DTC experience is a plus
• Familiarity with data ETL process and data transfer concepts/capabilities as well as database design
• Experience with Data Management and Data Quality concepts and practices
• Strong working knowledge of SQL and pulling data out of multiple systems
• Experience in Snowflake or other similar data warehouse technology
• Experience writing data documentation (Entity Relationship, Business rules, Source to Target mappings, etc.)
• Strong analytical and problem-solving skills; ability to develop creative and efficient solutions
• Strong troubleshooting skills include the ability to triage and interpret alerts, error messages and logs
• Strong interpersonal skills and ability to work in a team environment, cross-functionally, and with external parties
• Ability to respond quickly to ad hoc requests and manage time effectively

Responsibilities

• Transform business requirements into thoughtful technical solutions around schema design and database object development that support data integration across multiple sourcing paths
• Assist with the development of new data schemas to support a robust data ETL process that results in comprehensive data models being made available to the organization for various projects - ad hoc analysis, data visualization in Tableau, for use in downstream systems, and more
• Monitor and maintain data quality and define/implement corrective actions when required
• Support troubleshooting potential bugs within the database
• Develop procedures to document key processes and queries

Preferred Qualifications

• Experience with DBT (strongly preferred) and/or experience with any non database programming (C#, VB.NET, JAVA, JavaScript, PHP, Python, Go, Ruby, Rust, etc)
• Experience in Data Visualization & related BI Tools (Tableau Desktop and Server, Power BI, etc.)
• Experience meaningfully contributing to stakeholder conversations to narrow down complex business goals into logic for specifications
• Understanding of business and financial concepts including revenue calculations, retention models, etc

Benefits

• Fully remote work experience
• Comprehensive medical, dental, and vision package, including FSA program
• 401K with 50% match
• Quarterly Bonus Program
• Flexible PTO
• Two company-wide wellness breaks every day
• Free lunch on us every Tuesday and Thursday via Seamless/Grubhub
• Monthly wellness stipend
• Monthly internet stipend
• Monthly cell phone stipend
• Annual learning & development stipend
• Wellness Program, including virtual Wellness Sessions & No-Meeting Wednesdays
• Free meditation app membership (Headspace)
• Free Nutrafol subscription
• Pet insurance and benefit programs