Skip to content

Data Analytics Engineer

The Bouqs Company LogoThe Bouqs Company
View Organization

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

Competitive Base Salary Range of $120,000.00 - $180,000.00 USD + Equity Package

‌