Data Engineer

Data Engineer

This job is no longer open
Bright Cellars is now a Work from Anywhere company. This means work outside of an office will be the primary experience for all employees, and the location of all roles is flexible. 

Who We Are Bright Cellars is the monthly wine subscription startup designed to help new wine drinkers discover and define their taste in wine! We curate wines from around the world with the goal of making wine fun, accessible and educational. 

Our Mission is to inspire and educate a new generation of wine lovers by delivering a transformative, personalized wine experience.

Our Values
We are obsessed with creating a member-centric wine journey.
We value smart, sustainable growth.
We are curious and humble learners.
We cultivate a diverse, collaborative, and transparent workplace.
We identify our challenges quickly and solve them thoughtfully.
We hold each other accountable to success.
We back our intuition and experience with data-driven insights. 
We love wine and work to share that love with our members.
 
How Bright Cellars Works Our members join Bright Cellars by taking a 7 question-quiz to share their taste preferences. The Bright Points learning algorithm evaluates these preferences to determine the best wine matches for each member’s taste. Each month, members receive four or six unique bottles in the mail, which they are then able to rate and provide personalized feedback on their profile. Similar to Netflix’s collaborative filtering algorithm, Bright Cellars’s algorithm uses this feedback to improve members’ monthly matches going forward. 

What You'll Do:

    • Design, develop, test, implement, and support reliable, performant, and scalable database application solutions with a strong focus on the customer and delivering business value, including data warehouse and data mart
    • Work cross functionally with the team and stakeholders to gather requirements and implement data-enabled solutions
    • Develop, maintain, and support data ETL/ELT processes to populate the data warehouse from various data sources
    • Perform database performance tuning, deployments and engage in performance management tasks including administrative, maintenance tasks, backup/recovery and tuning
    • Provide database technical expertise and direction for development team members and external contacts
    • Assist team members in performance tuning and troubleshooting ETL/ELT processes and queries under development and in production as needed

Experience We're Looking For:

    • Proficient with Python, MySQL, and PostgreSQL
    • Working knowledge of AWS cloud service (e.g. EC2, RDS, S3)
    • Hands-on experience in designing and building data pipelines using tools like Stitch Data and dbt
    • Experience in working with workflow management tools (e.g Apache Airflow)
    • Strong knowledge in data warehouse concepts, dimensional modeling, Data modeling, Data ETL/ELT and data mart
    • Knowledge of Agile software methodology and ability to work in a fast-paced environment
    • Experience in a DevOps culture with focus on continuous integration, test automation, automated deployments, and monitoring/alerting telemetry
    • Knowledge on cloud Data Warehouse databases (e.g. Snowflake, Redshift)
    • Strong cross-functional communication skills that help simplify and move complex problems forward with business partners

Who You Are:

    • You’re an Innovator - You enjoy working with new technologies ranging from the frontend to backend, and are particularly passionate and an expert in multiple stacks
    • You’re A Problem Solver - You have strong experience with various technologies, and know how to pick the right tool for any job
    • You’re a Team Player - You love to collaborate closely with the team to brainstorm ideas, gather requirements, and review and improve code
    • You’re Driven - You have the ability to take initiative and work with minimal supervision
    • You’re Curious - You are naturally curious and have an interest in learning new things.

Perks of Working at Bright Cellars:

    • Competitive total compensation offerings
    • Unlimited paid vacation 
    • Flexibility & work/life balance
    • Medical, dental and vision insurance  
    • Heavily discounted monthly wine memberships 
    • Opportunity to attend wine tastings led by our resident sommelier
    • Opportunity to build something incredible while being surrounded by intelligent, hardworking and motivated coworkers
Bright Cellars is a fun, fast-growing startup with a work hard, play hard attitude. We look for smart, motivated individuals who are excited to build something incredible from the ground up!

#LI-Remote
This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.