Lead, Data Engineer

About Us

We’re a growing company. Everything we do, we do to help people grow. Our mission is to be a partner in progress on each unique journey to hair wellness. We provide personalized, natural solutions for healthy hair growth and connect people with doctors who care about hair. We challenge existing treatments and methodologies to continue to advance the frontier of hair science. As we help our customers grow, we grow too- through diversity & inclusion, teamwork & collaboration, and through empowering ourselves and others with our passion for wellness and innovation.

#KeepGrowing It’s our mantra- a voice of encouragement for hair and humanity, motivating people to grow in the best ways possible: personally, spiritually, and exceptionally.

About You

You will help Nutrafol make informed, data-driven decisions and support our leadership team with critical insights into the business through the development of new datasets as well as enhancements to existing database design. You are incredibly detail-oriented, have the ability to connect the dots across multiple views of the business, and enjoy seeing data power not only visualizations but also key customer touch points via predictive analytics and personalized marketing campaigns.

As the Manager of Data Engineering, you will have the opportunity to be a key member of our data engineering team, enabling us to gather data to better understand our customers, our supply chain, and our strategic partners. Nutrafol operates with a high-growth mentality and is invested in positioning data at the core of each business function to ensure teams are working smarter. You will provide strategic direction on data flow design and implementation across features that are key to unlocking powerful insights, generating executive level visualizations, or powering customer journey campaigns. You will work with cross-functional partners to generate and modify data load and validation processes that support their business use cases and help define the technology stack to be provisioned by the development team.

The ideal candidate is energized by working with fast-paced, entrepreneurial teams with a high degree of ownership. This role requires comfort working with complex challenges, appreciation of white space, and the ability to work with stakeholders across marketing, technology, and operational roles.

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

Requirements:

• Must have 3-5 years of experience in a relevant role.
• Familiarity with data ETL process and data transfer concepts/capabilities as well as database design
• Experienced with Data Management and Data Quality concepts and practices
• Strong working knowledge of SQL and pulling data out of multiple systems.
• Expert in Snowflake or other similar data warehouse technology.
• Experience with DBT preferred and/or experience with any non database programming (C#, VB.NET, JAVA, PHP, Python, etc)
• Experience in Data Visualization & related BI Tools (Tableau Desktop and Server, Power BI, etc.)
• Experience guiding stakeholder conversations to interpret complex business goals into precise logic for specifications
• 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
• Experience writing data documentation (Entity Relationship, Business rules, Source to Target mappings, etc.)
• Basic to mid level understanding of business and financial concepts including revenue calculations, retention models, etc.
• Ability to respond quickly to ad hoc requests and manage time effectively