Analytics Engineer II

Branch

. Build views, tables, data models, data dictionaries and self-service tools in SQL and dbt .

Posted 11/5/2026full-timeRemote • United StatesMid-LevelSenior💰 $70,000 - $100,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL and dbt for data modeling and quality monitoring, with a strong focus on process automation and business intelligence. Familiarity with insurance data and AI coding tools enhances the ability to deliver high-quality self-service tools and reporting solutions.

Highest-signal resume keywords

SQL ExperienceData ModelingDbt ProficiencyProcess AutomationInsurance Data Knowledge

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ModelingData Quality MonitoringProcess AutomationAutomated ReportingBusiness IntelligencePythonJavaScriptAI Coding ToolsTransformations

Soft Skills

CollaborationProblem-SolvingAdaptabilityAttention to Detail

Tools & Technologies

DbtAI Coding ToolsBusiness Intelligence Tools

Industry Keywords

Insurance DataClaims DataAccounting DataActuarial Data

Tech Stack

Tools & technologies

JavaScriptPythonSQL

About the role

Key responsibilities & impact

Build views, tables, data models, data dictionaries and self-service tools in SQL and dbt
Monitor data quality proactively, prevent unwanted changes and defects, and fix them promptly
Work tickets from Accounting, Actuarial and Claims stakeholders through to production
Understand project scope, dependencies and data flows
Advocate for best practices and adherence to service guidelines
Review AI-generated code, identify mistakes and improve AI tooling
Collaborate with leaders to implement, refine and document processes and best practices
Improve the quality and functionality of self-service tools
Build knowledge of Branch’s data development practices and insurance business
Report to the Senior Manager, Analytics Engineering

Requirements

What you’ll need

3+ years of relevant experience in data or reporting development
Experience with data modeling and data quality monitoring
Strong, hands-on SQL experience; must have built models and transformations
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 valued
Experience building with AI coding tools, particularly Claude Code, is a strong plus
Experience with insurance data, especially claims, accounting or actuarial data, is a plus
Comfortable in a fast-paced environment and owning work from start to finish
Must be currently authorized to work in the United States on a full-time basis
Must not require employment visa sponsorship, transfer, renewal, extension, or status change

Benefits

Comp & perks

Above-market salary
Pay equity and transparency
Remote-first work arrangement
Work-from-home setup support
Monthly internet allowance
Flexible YouTime paid time off
$1,000 vacation benefit after the first year
Employee stock options for full-time employees
Medical insurance
Vision insurance
Dental insurance
401(k) contribution matching
Annual company gathering (BranchFest)