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 annual base salary range for this role is $100k-135k. It is important to note that our salary ranges are based on paying competitively for our size, industry, and the market and are one part of the total rewards that we provide. Individual pay rate decisions are based on several factors, including qualifications for the role, experience level, skillset, scope of the role, and internal peer benchmarking.
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.
About Boll & Branch:
At Boll & Branch, we don’t make bedding like everyone else. We make it better.
In 2014, our founders, Scott and Missy Tannen, challenged every conventional standard in the textile industry, creating a new supply chain that prioritized thread quality, not thread count. By investing exclusively in 100% organic raw materials from the start, we became the first bedding company ever to be Fair Trade Certified. Today, we keep five commitments at the heart of everything we do. We are:
- Cultivators of the Highest Quality Threads
- Pioneers in 100% Organic Cotton
- Free from Toxins at Every Step
- 100% Traceable from Farm to Finish
- Committed to Fair and Ethical Treatment for All
Boll & Branch has over 150 employees, and we are headquartered in Summit, NJ, with a second office in New York, NY and a dedicated Photo Studio in New Providence, NJ. In 2019, to propel our growth, we raised $100M from L Catterton, a leading consumer goods private equity fund. We are also progressively expanding our retail and wholesale footprint. While the heart of our business lies in the direct-to-consumer online model, we also have three retail stores around the country as well as a partnership with Nordstrom in ~20 locations.
Boll & Branch LLC is an equal opportunity employer.