Data Analytics Engineer
The Bouqs
Data Science
marina del rey, ca, usa
Posted on Wednesday, May 24, 2023
The role 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 team. As an Analytics Engineer, you will work closely with the Product, Engineering, and Data teams to build and maintain the data infrastructure needed to support our data and business needs. You will also be responsible for developing, optimizing, and maintaining the best-in-class data pipelines, data models, and ETL processes to ensure that data is accurate, reliable, and available to stakeholders in a timely manner. The Analytics Engineer will also serve as the liaison between Engineering and Analytics and will serve as an active member in both teams.
Responsibilities:
- Lead the transfer of data modeling from legacy systems to DBT
- Contribute to building the data modeling layer, which exposes clean, transformed data to the whole company for analytics
- Build datasets in DBT (cloud) for data analysts to improve speed and accuracy for the team
- Improve current processes, whether that includes modularizing and standardizing a piece of commonly used code
- Design and develop new data pipelines and streaming processes that are highly available, scalable, and reliable
- Develop review processes for new data models and take charge on implementing SQL standards for the team
- Actively strive towards writing performant SQL rather than just SQL that works, while also ensuring the same SQL is easy to understand when new eyes look at it
- Optimize data processing and flow within our Snowflake Data Warehouse
- Document new datasets and pipelines and the reasoning/story behind their structure
- Work closely with engineering to keep track of schema changes in the production database and adjust pipelines, as needed
- Support existing data pipelines and systems in production
- Apply software engineering best practices to analytics code such as version control and testing
- Develop and communicate strong opinions about best practices in analytics
- Help explore and evaluate new technologies
Qualifications:
- 4+ years of experience working within a data team, preferably as an Analyst/Data Engineer
- Bachelor's degree in a quantitative field such as statistics, mathematics, economics, or computer science preferred
- Strong SQL fluency in both DDL/DML and analytics (Snowflake experience is a plus)
- Experience working with JSON, DBT or other data transformation tools
- Experience working with an ETL tool such as Fivetran or Stitch
- Knowledge of data structures and how to write performant SQL
- Experience with ensuring data quality through testing, deltas, lineage, etc
- Strong communication and critical thinking skills to deliver solutions that not only solve problems but also serve as tools we didn’t know we needed
- Ability to transform raw data into intuitive datasets that serve as building blocks for analytics
- Comfortable leading the growth of a data warehouse and maintaining it
- Capable of working through uninformative assumptions and built-biases in datasets and are not stalled when data is not perfect/sparse
Compensation & Perks:
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!
See more open positions at The Bouqs
Something looks off?
