Sr. Associate, Data Engineer

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 touchpoints via predictive analytics and personalized marketing campaigns.

In this role, 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

• 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 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.) preferred
• Experience meaningfully contributing to stakeholder conversations to narrow down complex business goals into 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.)
• Understanding of business and financial concepts including revenue calculations, retention models, etc preferred but not required
• Ability to respond quickly to ad hoc requests and manage time effectively