Analytics Engineer II — SQL, dbt & AI-Driven Data

Branch

Columbus (OH)

Remote

USD 70,000 - 100,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote-first (with perks)
Stock options
Medical, vision, dental
401k and matching

Job summary

Branch, a Columbus-based insurance tech company, is seeking an Analytics Engineer to build data models, tables and self-service tools using SQL and dbt on BigQuery. You’ll own data domains, collaborate with Accounting, Actuarial and Claims teams, and drive end-to-end data from requests to production.

AI is embedded in our workflow, with Claude Code assisting code reviews and rapid iteration. You’ll thrive in a fast-paced environment, write code end-to-end, and advance Branch’s data capabilities

Qualifications

  • 3+ years of relevant experience in data or reporting development, including data modeling and data quality monitoring.
  • Strong, hands-on SQL is required. You have built the models and transformations yourself, not only the dashboards on top of them.
  • Experience with dbt is a strong plus.
  • Experience with process automation, automated reporting and business intelligence.
  • Experience with Python is a strong plus. JavaScript or another programming language is also valued.
  • Experience building with AI coding tools, Claude Code in particular, is a strong plus.
  • Experience with insurance data, especially claims, accounting or actuarial data, is a plus.
  • Comfortable in a fast-paced environment where you own your work from start to finish.

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.
  • Understand each project's full scope, how it interacts with other projects, and how data flows between them. Advocate for best practices and adherence to service guidelines.
  • Review AI-generated code carefully, catch its mistakes, and help the team's AI tools improve over time.
  • Collaborate with leaders to implement, refine and document processes and best practices that improve quality and the functionality of our self-service tools.
  • Build a working knowledge of how data development works at Branch and of the insurance business behind the data.

Skills

SQL
dbt
Python
Claude Code
Insurance data
Data modeling
Data quality monitoring
Automation

Tools

SQL
dbt

Job description

Branch, a Columbus-based insurance tech company, is seeking an Analytics Engineer to build data models, tables and self-service tools using SQL and dbt on BigQuery. You’ll own data domains, collaborate with Accounting, Actuarial and Claims teams, and drive end-to-end data from requests to production.

AI is embedded in our workflow, with Claude Code assisting code reviews and rapid iteration. You’ll thrive in a fast-paced environment, write code end-to-end, and advance Branch’s data capabilities

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analytics Engineer II - End-to-End Data & AI
Analytics Engineer II - End-to-End Data & AI

Branch • United States

Remote
USD 120,000 - 160,000
Above-market salary
Pay equity and transparency
Remote-first (with perks)
+4
Analytics Engineer II - End-to-End Data Modeling (Remote)
Analytics Engineer II - End-to-End Data Modeling (Remote)

Branch Financial Inc. • Columbus (OH)

Remote
USD 110,000 - 140,000
Remote-first (with perks)
Columbus headquarters
Stock options
+3
Analytics Engineer II (Fully Remote)
Analytics Engineer II (Fully Remote)

Branch Financial, LLC • United States

Remote
USD 120,000 - 160,000
Remote-first with perks
Flexible time off
$1000 toward vacation after one year
+5
Remote Analytics Engineer II — Data Modeling & Tools
Remote Analytics Engineer II — Data Modeling & Tools

Branch Financial, LLC • United States

Remote
USD 120,000 - 160,000
Remote-first with perks
Flexible time off
$1000 toward vacation after one year
+5
Senior Data Platform Engineer: AI-Driven Scale & Impact
Senior Data Platform Engineer: AI-Driven Scale & Impact

Branch International • United States

Hybrid
USD 140,000 - 210,000
Competitive compensation
Hybrid work
Medical insurance
+6
Analytics Engineer II
Analytics Engineer II

Branch • Columbus (OH)

Remote
USD 70,000 - 100,000
Remote-first (with perks)
Stock options
Medical, vision, dental
+1
Analytics Engineer II
Analytics Engineer II

branchinsurance • United States

Remote
USD 75,000 - 110,000
Remote-first
Home office setup support
Monthly internet coverage
+5
Analytics Engineer II — Remote-First with Stock Options
Analytics Engineer II — Remote-First with Stock Options

branchinsurance • United States

Remote
USD 75,000 - 110,000
Remote-first
Home office setup support
Monthly internet coverage
+5
Analytics Engineer II
Analytics Engineer II

Branch Financial, LLC • United States

Remote
USD 110,000 - 160,000
Above-market pay
Pay equity
Remote-first with setup
+4
Senior Analytics Engineer: AI-Driven Data Modeling
Senior Analytics Engineer: AI-Driven Data Modeling

Genius AI (HearstLab) • New York (NY)

On-site
USD 140,000 - 190,000
Competitive health & dental insurance
Flexible PTO
In‑office lunch NYC/SF
+7