The Data Engineer Lead contributes to The Bouq’s mission of revolutionizing the way we commemorate life’s moments by connecting people to beautifully designed floral experiences and the responsible partners who create them by being a key member of the data management team.  You will be working closely with our software engineering and analytics team in designing and implementing our data warehousing solution. You will be working in a multi-cloud environment that is funneling data from multiple sources into our data warehouse. You will be given the opportunity to put your knowledge and experience to work as you help employ the best designs to handle the ingestion and storage of our production data. In addition, you’ll be in an authoritative role of expanding our data warehouse that will empower our business units to make critical decisions that will impact our future growth. 

Responsibilities:

• You will be responsible for maintaining our current Snowflake data warehouse as well as helping to revamp our data structure with our ever-increasing complex and modern systems.
• You will be working closely with other engineers and our business partners on ensuring that we’re capturing all requested data into our data warehouse.
• You will be advising us with redesigning the data structure as our company expands into new business opportunities.
• You will be expected to be the lead data engineer responsible for designing and solving data related issues, including the ingestion of data from both internal and external production systems. 
• You will be writing out new and updating existing Fivetran connectors between Snowflake and our production systems.
• You will also be assisting our analytics team in managing and data migration of our BigQuery Data Warehouse.
• You will be responsible for reporting on project progress and will be responsible on production systems maintenance.
• You will also assist us with evaluating future data warehousing needs and toolset to improve our reporting needs.

Qualifications:

• 5+ years of experience as a Data Engineer or in a similar role.
• 4+ years of experience with data warehouse technical architectures, ETL/ELT, reporting/analytic tools, and scripting.
• 3+ years of data modeling experience and proficiency in writing complex SQL with mySQL.
• Experience with data modeling, data warehousing, and building ETL.  
  Experience working in SQL and noSQL databases.
• Experience with AWS services including S3, RDS, Data-pipeline, Lambda, etc.
• Experience in scripting languages such as Python.
• You are proficient at tuning database queries. 
• Experience independently building out data new solutions and solving complex data issues, with a curious drive toward constant improvement.
• You should have great communication skills and experience coordinating with both business stakeholders and software engineers. 

Compensation:

• Competitive Salary + Equity Package
• Health, Dental & Vision with 100% employee coverage 
• 401K match
• Three Weeks Paid Vacation
• Discounts on The World’s Best Flowers (obviously!) 
• Work on cutting edge new technologies 

About The Bouqs: 

Our mission here at The Bouqs is to revolutionize the way we commemorate life’s moments by connecting people to beautifully designed flowers and the responsible partners who create them. Grounded in transparency, responsibility, and simplicity, we create genuine moments of emotional connection for our customers, build meaningful relationships with like-minded farmers and florists while empowering them to thrive, and eliminate unnecessary waste along the way.

Founded in 2012, The Bouqs is a venture-backed online floral retailer that delivers flowers fresh from eco-friendly, sustainable farms to doorsteps nationwide.  Headquartered in Marina Del Rey, CA, The Bouqs connects farms and a curated network of artisan florists directly to consumers and disrupts the traditional supply chain by eliminating overhead costs like warehouses, importers, distributors, auctioneers and more. In turn, this model enables a superior product and redefines the experience and economics for both consumers and producers alike.

For more information, visit www.bouqs.com and follow the #BouqLove on Facebook, Instagram and Twitter.

The Bouqs is an Equal Opportunity Employer!