Analytics Engineer II - End-to-End Data Modeling (Remote)

Branch Financial Inc.

Columbus (OH)

Remote

USD 110,000 - 140,000

Full time

11 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)
Columbus headquarters
Stock options
Medical, vision, dental
401k matching
YouTime vacation bonus

Job summary

Branch is hiring an Analytics Engineer to build data models, tables and self-service tools used by Accounting, Actuarial and Claims teams, using SQL and dbt on BigQuery. You will join the Analytics Engineering team in Branch's Data Office, reporting to the Senior Manager, Analytics Engineering.

You’ll own a data domain and stakeholder relationships as you grow in the role. AI is integrated into how we work, with Claude Code drafting PRs in our dbt project.

Qualifications

  • 3+ years in data or reporting development, incl. data modeling.
  • Strong, hands-on SQL required.
  • dbt experience is a strong plus.
  • Experience with automation, automated reporting and BI.
  • Experience with Python is a strong plus; JavaScript or other languages valued.
  • AI is part of how we build and review outputs.
  • Experience with insurance data (claims, accounting, actuarial) is a plus.
  • Fast-paced environment; ability to own your work end-to-end.

Responsibilities

  • Build views, tables, data models 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.
  • Work tickets from Accounting, Actuarial and Claims stakeholders from the request through to production.
  • Understand each project's full scope, data flow and interactions; advocate for best practices.
  • Review AI-generated code, catch mistakes, and help AI tools improve over time.
  • Collaborate with leaders to implement, refine and document processes and best practices.
  • Build working knowledge of how data development works at Branch and the insurance business behind the data.

Skills

SQL
Data modeling
Data quality
Python
JavaScript
AI tooling
Insurance data

Tools

dbt
BigQuery

Job description

Branch is hiring an Analytics Engineer to build data models, tables and self-service tools used by Accounting, Actuarial and Claims teams, using SQL and dbt on BigQuery. You will join the Analytics Engineering team in Branch's Data Office, reporting to the Senior Manager, Analytics Engineering.

You’ll own a data domain and stakeholder relationships as you grow in the role. AI is integrated into how we work, with Claude Code drafting PRs in our dbt project.

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 — SQL, dbt & AI-Driven Data
Analytics Engineer II — SQL, dbt & AI-Driven Data

Branch • Columbus (OH)

Remote
USD 70,000 - 100,000
Remote-first (with perks)
Stock options
Medical, vision, dental
+1
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
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
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
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
Remote Analytics Engineer - dbt & Data Modeling
Remote Analytics Engineer - dbt & Data Modeling

20byte • United States

Remote
USD 90,000 - 130,000
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
Senior Analytics Engineer (Fully Remote)
Senior Analytics Engineer (Fully Remote)

Seismic • United States

Remote
USD 110,000 - 150,000
Senior Data Engineer - Remote | BigQuery, dbt & AWS
Senior Data Engineer - Remote | BigQuery, dbt & AWS

99x Brazil • United States

Remote
USD 39,000 - 67,000
Fully remote
Flexible hours
Mentoring culture
+1