Analytics Engineer II

The role

You will build data models, tables, and self-service tools using SQL and dbt on BigQuery. You will work on requests from Accounting, Actuarial, and Claims teams from initial question to production data.

What you will do

• Build views, tables, data models, data dictionaries and self-service tools in SQL and dbt.
• Monitor data quality proactively and fix defects promptly.
• Work tickets from Accounting, Actuarial and Claims stakeholders from request to production.
• Understand project scope and data flow between projects.
• Advocate for best practices and adherence to service guidelines.
• Review AI-generated code and help improve AI tools.
• Collaborate with leaders to implement and document processes and best practices.
• Build working knowledge of data development and the insurance business.

Required qualifications

• 3+ years of relevant experience in data or reporting development, including data modeling and data quality monitoring.
• Strong, hands-on SQL.
• Experience with process automation, automated reporting and business intelligence.
• Applicants must be currently authorized to work in the United States on a full-time basis.

Nice to have

• Experience with dbt
• Experience with Python
• JavaScript or another programming language
• Experience with insurance data, especially claims, accounting or actuarial data

Benefits

• Above-market salary
• Work from home set-up and monthly internet
• Flexible YouTime
• $1000 toward next vacation after first year
• Employee stock options
• Medical, vision, dental
• 401k and contribution matching

Before you apply

• 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.

About the company

Branch is on a mission to make insurance more accessible using data, tech, and automation. They are a remote-first company with headquarters in Columbus, Ohio.