Data Engineer

Coterie helps insurance professionals unlock untapped revenue in the small commercial space. With an innovative quoting platform that delivers accurate pricing and bindable quotes in less than one minute, Coterie makes small business insurance effortless.

We are on a mission to build and foster a world-class team to bring speed, simplicity, and service to commercial insurance. We value integrity, humility, passion, and intelligence. If you want to push yourself, promote social good, and reshape a $200B+ market, we’re excited to talk to you!

What will the Data Engineer do?

Data is the foundation of what we do. It’s what made insurance one of the first industries to make computers a standard in doing business. But it’s time to help our industry make a leap, and to do that we need data from all kinds of sources in all sorts of data types to feed into our host of applications and risk engines. It’s this kind of data that will allow us to create newer and more equitable risk metrics to eventually take insurance away from its antiquated proxies for risk and into something more accurate, and more human.

As a part of the growing data engineering team at Coterie, you will be responsible for helping build the critical ETL pipelines, data stores, and delivery mechanisms that will power our contemporary cloud-first environment. This work will allow us to provide better risk, power dynamic data visualizations for our partners and clients, and fuel the next generation of insurance coverage. As a result of our data-hungry approach, you’ll be faced with scraping, integrating, munging, cleaning, and helping organize information from a litany of traditional and non-traditional sources. It’s this variability that will be key, rather than purely thinking in terms of Big Data centered scale. This is about being nimble and everywhere.

What we are looking for:

• 2+ years' experience building and/or maintaining robust and modular ETL/ELT processes (working with parameters, smart dynamic content)
• Experience working with version control (i.e., GitHub)
• Experience working in a cloud-based data environment (Azure preferred)
• Experience coding in a notebook-style environment
• Strong documentation skills
• Experience working with relational databases and data warehouses
• Strong skills in SQL and Python
• Understand data consumer personas, i.e., data scientists, data analysts, business stakeholders
• Strong communication skills

What will set you apart:

• Experience with insurance data (e.g., policy administration, claims, etc.)

What to expect:

Our hiring process generally consists of 4 phases. The goal is to provide an opportunity for us to learn more about our candidates while allowing them to get to know us as well!

• Phase 1: Qualified candidates will first meet with a member of our People Operations team for a phone interview. This discussion is a high-level conversation to understand more about your background and interests and for us to share more about Coterie and the position.
• Phase 2: Selected candidates will be invited to participate in our PDP survey and meet with our Hiring Manager for a 2nd interview via Teams video. This interview is designed to be more detail oriented and allows you to learn more about the role and expected to be 30 minutes in length.
• Phase 3: Top candidates will be invited to participate in an experiential exercise. This exercise designed to assess technical fit and will include 1-hour project deep dive interview where you can discuss your project in detail and showcase your approach with the hiring manager.
• Phase 4: Final candidates will receive an invite to our final interview series. This series will include 1:1 interview with additional team members. The final series is roughly 1-1.5 hours in total.