Analytics Engineer

Boll & Branch is searching for an Analytics Engineer to engage in each of the data team’s functions with a focus on Data Transformation and Business Intelligence. Your primary responsibilities will be to:

Design, build and maintain scalable dbt models that are readable, well-tested, and well-documented
Troubleshoot data quality issues at different parts of the stack
Assist analysts with creating insightful analyses, dashboards, and automation
Identify and respond to failures across our data stack

In addition to working with another analytics engineer and a data scientist, this role will work directly with various stakeholders (from Marketing, Finance, Tech, E-Commerce, etc.) to fulfill any analytics-related requests. Along the way you are expected to own and promote optimization, testing, and documentation of the various components in our data stack.

At Boll & Branch the data team is a shared service among all business units and comprises of four main functions:

Data Mobility: build and maintain robust and observable pipelines that send data into and out of our data warehouse.
Data Transformation: transform raw data tables in our warehouse into validated models that will be queried by reporting tools and other downstream business applications.
Business Intelligence: Promote data access across the company by exposing tables/views to reporting tools where business users can create on-demand insights.
Data Science: create analyses and statistical/ML models that enable the business to make predictions and improve customer experience.

Problems You’ll Solve:

In the first month:
Gain an understanding of our data stack (Google Cloud Functions, Stitch, Segment, BigQuery, dbt, Looker) and understand how to address each component if there is a failure
Build a rapport with analysts and other data consumers
Make your first commits to dbt and Looker projects
Investigate and resolve dbt test failures, and/or errors reported by our pipelines
In the first three months:
Establish a data domain (or domains) within our data catalog (e.g. web events, financial transactions, marketing campaigns) and become the ‘go-to’ person for addressing related bugs and features
Identify and address bottlenecks and redundancies in our dbt project
Identify and address areas of low test coverage in dbt
Identify and address areas of low observability in our data pipelines
In the first six months:
Help bring one of our annual data roadmap initiatives to completion

Qualifications:

Proactive contributions: If you see issues with our process/code/architecture, you do not hesitate to raise them and address them by collaborating with other team members.
Ability to work autonomously: You enjoy the freedom to work on projects without micromanagement. When you are stuck you ask for help, but you require minimal guidance to complete most tasks.
Clear communication: You are able to break down complex concepts into intelligible summaries for business stakeholders. This includes writing clear documentation for new or updated data models, pipelines, and workflows.
Software engineering mindset: You like to build SQL queries modularly and create reusable components that minimize redundancy.
Experience using our tools:
SQL (high proficiency)
dbt (you have deployed dbt models/tests and maintained a dbt project)
BigQuery (preferred) or other cloud data warehouses (Snowflake, Redshift, etc.)
Creating reports / data models in Looker (preferred), Tableau, Mode, or other BI tools
Python / Serverless Functions (not required, but nice to have)

The primary location for this role is New York City. We believe our business and our culture are strongest when we work together in person. We also know that it’s helpful to have flexibility to work remotely. Currently we are operating under a hybrid model whereby all teams work in an office a minimum of two days per week (Tuesdays/Wednesdays) and may be provided flexibility to work from home on other days. There may be times when you’re asked to work in our Summit, NJ headquarters because it’s in the best interest of our business or your team.

The above is a comprehensive, but not exhaustive, description of requirements and expectations that may evolve over time based on business needs. You must be able to complete all physical requirements of the job with or without a reasonable accommodation.

‌