Analytics Engineer II

About the role

ABOUT BRANCH

Branch is on a mission to make insurance more accessible, so more people can be covered. We innovate using data, tech, and automation to simplify insurance from start to finish—we eliminated inaccurate quotes in favor of real prices, created a better way to bundle, and cut unnecessary costs in the traditional insurance process. Then we pass those savings along to our members. Basically, we’re doing insurance the way it was meant to be.

But we didn’t just create the insurance we’ve always wanted, we also created the company we’ve always wanted to work for. As we redefine insurance, we also want to redefine what it means to work in insurance. Find out for yourself.

Branch has a preference for candidates in Ohio, but is open to candidates located in AZ, FL, GA, IL, IN, IA, KS, KY, MD, MI, MO, NV, NC, OH, PA, SC, SD, TN, TX, and WI. Applicants must be currently authorized to work in the United States on a full-time basis. We are unable to sponsor or take over sponsorship of an employment visa at this time.

Branch is remote first, with most Branchers choosing to work from home. Our headquarters are located in Columbus, Ohio, where we come together from time to time to build relationships and connect with each other in real life. We also have office space in Columbia and Concordia, Missouri as well as Forreston, Illinois. Once a year, the entire company gathers for “BranchFest”, a highlight of the year for many Branchers.

About the Role

At Branch, we're reshaping the insurance experience with efficient, transparent, member-centered products. As an Analytics Engineer, you'll build the data models, tables and self-service tools that our Accounting, Actuarial and Claims teams rely on, working in SQL and dbt on BigQuery.

You'll join the Analytics Engineering team in Branch's Data Office, reporting to the Senior Manager, Analytics Engineering. Requests come to the team as tickets, and you'll take yours from the question through to production data. As you grow in the role, you'll own a data domain and the stakeholder relationships that come with it.

AI is built into how the team works. Claude Code drafts pull requests inside our dbt project, and the team reviews, corrects and improves what it produces. Branch also moves faster than a large carrier: work that takes a quarter elsewhere ships here in a couple of weeks. That pace is the best part of the job and the biggest adjustment for anyone arriving from a larger company.

This role is ideal for someone who wants to write the code themselves, see their work end to end, and grow quickly.

Key Responsibilities

- Build views, tables, data models, data dictionaries and self-service tools in SQL and dbt, with support from peers and senior members of the Data Office.

- Monitor data quality proactively, prevent unwanted changes and defects, and fix them promptly when they occur.

- Work tickets from Accounting, Actuarial and Claims stakeholders from the request through to production.