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

Branch Financial, LLC

Annapolis (MD)

Remote

USD 90,000 - 150,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Remote-first
Stock options
Medical, vision, dental

Job summary

Branch is seeking an Analytics Engineer to build data models, tables, and self-service tools used by Accounting, Actuarial, and Claims teams, leveraging SQL and dbt on BigQuery.

You will join the Analytics Engineering team in Branch's Data Office, handling tickets from request to production, owning a data domain, and partnering with stakeholders to ensure data quality and accessibility.

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.
  • AI is part of how we build. Our agentic tooling drafts changes across our dbt project, and our team owns what ships.
  • 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
Data modeling
Data quality
Automation
BI

Tools

BigQuery
dbt

Job description

Branch is seeking an Analytics Engineer to build data models, tables, and self-service tools used by Accounting, Actuarial, and Claims teams, leveraging SQL and dbt on BigQuery.

You will join the Analytics Engineering team in Branch's Data Office, handling tickets from request to production, owning a data domain, and partnering with stakeholders to ensure data quality and accessibility.

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 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 - Remote Data Modeling & dbt
Analytics Engineer II - Remote Data Modeling & dbt

Branch Financial, LLC • Philadelphia

Remote
USD 110,000 - 165,000
Above-market pay
Stock options
Remote-first with home setup support
+2
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 (SQL/dbt) - Remote
Analytics Engineer II - End-to-End Data Modeling (SQL/dbt) - Remote

Branch Financial, LLC • Columbus (OH)

Remote
USD 90,000 - 130,000
Above-market salary
Pay equity
Remote-first
+4
Analytics Engineer II - Remote, End-to-End Data
Analytics Engineer II - Remote, End-to-End Data

Branch Financial, LLC • Charlotte (NC)

Remote
USD 110,000 - 165,000
Above-market salary
Pay equity and transparency
Remote-first with home setup support
+5
Analytics Engineer II - End-to-End Data & AI (Remote)
Analytics Engineer II - End-to-End Data & AI (Remote)

Branch Financial, LLC • Jackson (TN)

Remote
USD 120,000 - 170,000
Above-market salary
Remote-first with home setup support
Stock options
+2
Analytics Engineer II: End-to-End Data Modeling & AI Tools
Analytics Engineer II: End-to-End Data Modeling & AI Tools

Branch Financial, LLC • Columbia (SC)

Remote
USD 120,000 - 170,000
Above-market salary
Pay equity and transparency
Remote-first (with perks)
+1
Analytics Engineer II — End-to-End Data & AI Tools
Analytics Engineer II — End-to-End Data & AI Tools

Branch Financial, LLC • Kansas City (MO)

Remote
USD 110,000 - 150,000
Remote-first
Office visits in Columbus
Stock options
+2
Analytics Engineer II - Build Core Data Tools (Remote)
Analytics Engineer II - Build Core Data Tools (Remote)

Branch Financial, LLC • Tallahassee (FL)

Remote
USD 100,000 - 160,000
Above-market salary
Pay equity and transparency
Remote-first with home setup support
+1
Analytics Engineer II - Data Modeling, SQL & AI (Remote)
Analytics Engineer II - Data Modeling, SQL & AI (Remote)

Branch Financial, LLC • Lansing (MI)

Remote
USD 110,000 - 160,000
Remote-first
Stock options
401k matching
+1