Data Analyst

Who we are:
Through a partnership-based approach, 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 and reshape a $200B+ market, we’re excited to talk to you!

Position Summary:

Data is at the foundation of Coterie's business. We are looking for a Data Analyst who is curious, collaborative, and skilled at turning complex information into clear business insights. This role will use data analysis, statistical and quantitative methods, dashboards, forecasting, and fact-based storytelling to help leaders understand performance,identifyopportunities, and make better decisions.

You will work closely with data scientists, engineers, analysts, insurance subject matter experts, and business partners across Coterie. The ideal candidate is a self-starter who cares deeply about data quality, can connect analysis to business outcomes, and is comfortable moving between recurring reporting, ad hoc analysis,dataqueriesand forward-looking modeling.

Key Responsibilities

- Contribute directly to data transformation and modeling in Gold and Platinum Medallion layers, using proficient SQL skills.

- Establish and evolve analytics best practices around metric definition, data integrity, and scalable solutions.

- Partner with subject matter experts across divisions including but not limited to Insurance, Revenue and Operations, to translate business needs into scalable analytics solutions and visualizations.

- Support other business areas through analysis focused on portfolio segmentation, loss experience, partner performance, underwriting, and renewal behaviors.

Required Qualifications:

- Bachelor’s degree in Analytics, Mathematics, Data Science, Actuarial Science, Finance, Economics, or a related quantitative field.

- Three or more years of experience in data analysis, business intelligence, reporting, analytics, or a related role.

- Strong SQL skills and experience querying, joining, validating, and analyzing complex datasets.

- Experience building recurring reports, analytical datasets, and complex formulas using modern data tools.

- Strong attention to detail and commitment to data accuracy, integrity, and documentation.

- Strong critical-thinking, creative problem-solving, communication, and stakeholder-management skills.

- Ability to work independently, manage priorities, and collaborate effectively in a remote environment.

- Experience working with insurance-related data, such as loss experience, premium production, underwriting or operational metrics.

Preferred Qualifications (Bonus Experience):

- Experience with Databricks or related modern cloud analytics platforms.

- Familiarity with Python or R for custom report generation, exploratory data analyses, data visualization, or predictive modeling.

- Familiarity with Power BI, Tableau, or data visualization tools.

- Advanced degree in Analytics, Mathematics, Data Science, Actuarial Science, Finance, Economics, or a related quantitative field.

- Intimate knowledge of commercial insurance

Our Interview Process:

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: The initial phase of our review process will involve selected candidates completing a brief pre-screen exercise. Results from this exercise will help determine advancement to subsequent stages of consideration.

-
Phase 2 : Qualified candidates will first meet with a member of our People Operations team for a phone interview. This discussion is a high-