About DRINKS
DRINKS (www.drinks.com) connects retailers, brands, and marketplaces to the $250 billion alcohol market. The company's innovative Wine as a Service (WaaS) platform enables its partners to bring adult beverages safely and conveniently to their customers across the United States in 1-2 days. DRINKS optimizes alcohol e-commerce with its patented DRINKS IQ technology, which empowers retailers to leverage AI-based predictive merchandising and marketing to personalize customer experiences. DRINKS was named a top place to work by Built In LA for the last four years, one of America’s Best Employers by Forbes for the past two years, and was recognized as the Most Innovative Retail Model by Modern Retail in 2020.
Working at DRINKS
At DRINKS, you’ll get the good parts of working for a large company (first-rate health plans and benefits, remote work, highly competitive compensation packages) with the advantages of working at a rapidly growing (influence and impact in your role, broad responsibilities, and a high degree of flexibility). Our culture encourages a healthy work-life balance and we empower employees to think like owners, because they are (when they participate in our generous stock option plan)! DRINKS rewards excellence, promotes career development, and celebrates diverse perspectives that inspire creativity and drive innovation.
The Role
DRINKS is seeking a Senior Data Engineer to be part of the Business Intelligence team to build and manage the complete end-to-end BI infrastructure and support the Business Users with advanced data analytics. This role’s main duties will include designing and developing efficient data pipelines, manage and lead technical design and development activities for implementation of cloud data solutions in Redshift/Snowflake to support multiple use cases like (behavioral segmentation, retention analytics, customer communication analytics etc.) and performing adhoc analysis as required. The successful candidate would be an independent self-starter who can adapt to a fast-paced environment who is an expert in building ETL/ELT processes, data modelling and transformations.
What You'll Do
- Develop and manage the ELT/ETL data processes to support the DRINKS reporting
- Lead design and development of technology and data architectures to support new company initiatives like new partnership launches and new marketing technology system integrations
- Work with other teams (marketing, finance, operations etc.) to understand their requirements and translate the business context into sophisticated data pipelines for report and dashboard development to help data-driven decisions across the company
- Manipulate large datasets with sophisticated SQL queries to support adhoc data requests from different teams
- Create processes to analyze customer order and behavior metrics to optimize advertising and retention programs
- Conceptualize and own the data architecture to manage the cloud data warehouse migration from Redshift to Snowflake
- Reconcile data inconsistencies and ensure data integrity
- Support any other special projects as needed
About You
- Bachelor’s Degree in Computer Science, Mathematics, Statistics, Information Systems, Engineering, Information Technology or a related quantitative field of study
- 4+ years of experience in extracting and transforming data
- Advanced level expertise in writing complex SQL queries to extract or transform data or answer ad hoc questions using operations like aggregations, window functions or similar.
- Ability to work with cloud data platforms like Redshift, Snowflake, Amazon Aurora and others.
- Experience implementing advanced data pipelines to handle large volumes of data using ETL/ELT tools like Matillion, Apache Airflow, Alteryx or others (Matillion experience preferred)
- Knowledge of scripting languages like Python and/or R for data manipulation, statistical modelling and other advanced analytics operations
- Familiarity with best practices in implementing a Data Warehouse/Lakehouse architecture, data validation and testing
- Advanced-level experience with MS Excel to be able to perform data cleaning and analysis.
- Excellent analytical and organizational skills with a proven ability to multi-task in a fast-paced, high performing team
- High attention to detail
- Must be able to effectively liaise with other departments
Bonus points for
- Experience with data visualization tools like Tableau
- Familiarity with financial modeling and forecasting
- Familiarity with customer surveying tools (e.g. Survey Monkey, Qualtrics) and methods and metrics such as NPS, Max Diff testing, survey branching and piping