Analytics Engineer III

Analytics Engineer

Branch is on a mission to make insurance less expensive, so more people can be covered. We innovate using data, tech, and automation to simplify insurance from start to finishwe eliminated inaccurate quotes in favor of real prices, created a better way to bundle, and cut unnecessary costs in the traditional insurance process. Then we pass those savings along to our members. Basically, we're doing insurance the way it was meant to be.

But we didn't just create the insurance we've always wanted, we also created the company we've always wanted to work for. As we redefine insurance, we also want to redefine what it means to work in insurance. Find out for yourself.

Branch is remote first, with most Branchers choosing to work from home. Our headquarters are located in Columbus, Ohio, where we come together from time to time to build relationships and connect with each other in real life. Once a year, the entire company gathers for "BranchFest", a highlight of the year for many Branchers.

About the Analytics Engineer Role

In this role, you will report to the Director of Analytic Engineering or Head of the Data Office and support a wide range of architecture, engineering, BI, and other special projects that will serve different needs across the organization.

Our team manages, governs, and democratizes data through self-service tools that encourage exploration, innovation, and discovery of insights that enable leaders to make informed decisions and develop strategies to offer a competitive edge for all areas. In this role, you'll be able to offer strategic recommendations and hands-on technical expertise to architect solutions and address emerging challenges as they arise.

Outlined below are examples of the routine tasks our team adeptly manages:

Data Engineering and Analytics Engineering pipeline work (Full-Stack Development)

Developing and maintaining dashboards, visualizations, and other forms of ad-hoc reporting necessary to support data-driven business decisions and strategies.

Troubleshooting, diagnosing, and fixing issues within existing data pipelines.

Validating data and following best practices to guarantee quality, compliance and a positive experience for end users.

Making recommendations to create an environment where ongoing optimization is an organic part of our development processes.

Data Engineer III

Key Responsibilities:

Providing hands-on technical expertise, leadership, and support to:

Build views/tables, data models, data dictionaries, and self-service tools with some guidance

Ensure data quality is proactively monitored and unwanted changes or defects are proactively prevented and promptly fixed.

Has broader understanding of how the main project interacts and affects other projects. Defines technical best practices and patterns with assistance from senior team members

Support processes necessary to bring data into the data lake/warehouse via managed systems (e.g., ETL/ELT)

Collaborating with leaders to implement, refine and document processes and best practices to improve quality and enhance the functionality of all our self-service tools.

Learning and understanding how data development works at Branch.

Skills, knowledge, and Expertise:

7+ years of relevant experience with data/reporting development:

Data modeling, monitoring data quality

Process automation, automated reporting, business intelligence

Design and development of ETL processes

SQL proficiency is a must; dbt experience is desirable

Experience with Python, JavaScript, or other programming languages is also highly desirable.

Insurance data and business domain experience is also highly desirable.

Why join us at Branch?

Above-market salary Branch is a data-driven company, so we do the math on salaries, too. If you get an offer from Branch, you can expect compensation that hits above the mark.

Pay equity and transparency Our pay isn't just above market, it's equitable. We let experience and performance drive your success, never your gender, race, orientation, or beliefs.

Remote-first (with perks) Work from where you're most comfortable. We'll take care of your work from home set-up and monthly internet. We also have a Columbus headquarters and if you'd like to join us in an office.

Flexible YouTime We don't just let you control your own time off. We actually encourage you to use it. After your first year at Branch, we'll give you $1000 toward your next vacation.

Employee stock options You're not just an employee. If you're full-time, you're also a part-owner. You'll have stock options so you can invest in the company you're helping to grow.

Medical, vision, dental Get all the coverage you need for a healthy, happy life.

401k and contribution matching Invest in your future. Branch helps you get to retirement on time with a portion of your contributions matched each month.

What to expect

Please apply to open positions directly through our site. If you don't see it here, then it shouldn't exist on another job board. If you're ever unsure about the legitimacy of a Branch job posting found on another site, please check the listings here to verify.

If you're selected to move onto the next phase of the hiring process, a member of our Branch talent team will reach out to you directly from the email domain @ to guide you through our process.

The process will include a number of interviews, which will all happen either over the phone or on video calls.

We will never ask for personal payment or require you to purchase equipment during our interview process. Always be sure to protect your personal information.

Equal Employment Opportunity Employer

At Branch, we are deeply committed to the community. Branch is an Equal Employment Opportunity employer All qualified applicants and/or employees will receive consideration for employment without regard to the individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.