Analytics Engineer

Analytics Engineer II - IV

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 finish—we 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 actively prioritizing candidates located in OH but remains open to hiring qualified individuals from a wide range of states, including AL, AZ, CT, FL, GA, ID, IL, IN, IA, KS, KY, LA, MD, MA, MI, MN, MS, MO, NE, NV, NJ, NC, ND, OK, PA, SC, SD, TN, TX, UT, VA, and WI.

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.

We are seeking a range of candidates with different levels of expertise and experience. Please see the Key Responsibilities and Skills, Knowledge, and Expertise associated with each level.

Key Responsibilities: 

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

  • See the big picture and recommend changes to data models, reporting design or core schema to prevent discrepancies and implement long term fixes to emerging problems

  • Build views/tables, data models, data dictionaries, and self-service tools independently.

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

• Supporting the selection, management, and support processes necessary to bring data into the data lake/warehouse via managed systems (e.g., ETL/ELT)

• Supporting the development of junior members of the team and 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. 

• Has a high level understanding of the main project and quick progress to the entire data schema/architecture to solve business problems.

Skills, knowledge, and Expertise

• 10+ 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 highly desirable

• Experience with Python, JavaScript, or other programming languages is also transferrable 

• Insurance data and business domain experience is also highly desirable

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

Key Responsibilities: 

• Providing hands-on technical expertise and support to: 

  • Build views/tables, data models, data dictionaries, and self-service tools with assistance from peers and senior members of the Data Office

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

  • Provides expertise in a project, including understanding of the overall scope, how it interacts with other projects, and how data flows between them. Advocates for best practices and adherence to service guidelines. 

• 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

• 3+ years of relevant experience with data/reporting development:  

  • Data modeling, monitoring data quality

  • Process automation, automated reporting, business intelligence

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

We’re all about getting back to getting each other’s back—that means Branchers, too. So we provide benefits that let you work and live to your fullest.

• 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

In light of recent hiring scams across the United States, here’s what the process will look like with Branch (so you know it’s us):

• 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 @ourbranch.com 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.