Data Analyst

Job description

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, identify opportunities, 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, data queries and 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-level conversation to understand more about your background and interests and for us to share more about Coterie and the position. Phase 3 : Selected candidates will be invited to participate in an experiential exercise interview. This will include a project provided in advance along with a 1.5-hour interview conducted with our hiring manager and members of our Data & Analytics (DnA) team. Phase 4 : Top candidates will then be invited to meet with additional members of our DnA and leadership team. This series may be 1-3 hours in total. What's in it for you: Coterie has excellent benefits for all full-time employees. We offer the following: 100% remote Health insurance through Aetna (we pay 100% of premiums) Dental and vision insurance through Guardian (we pay 100% of premiums) Basic life insurance (we pay 100% of premiums) Access to flexible spending account (FSA) or health savings account (HSA) (for those using HSA eligible plans) 401K plan (up 4% match with immediate vest). Must be 21 years of age or older to participate Flexible PTO policy offering employees up to 4 weeks of PTO in their first 12 months. Thereafter, PTO usage aligns with company standards and typically does not exceed 5 weeks per calendar year. 12 company-paid holidays each year Continuing education annual stipend Annual salary estimated between $75,000-$95,000 based on national data. Candidates who meet all the minimum requirements and possess additional relevant experience, as outlined in the job description, may be considered for a salary above the midpoint of the above range. Salary is based on internal equity; internal salary ranges; market data/ranges; applicant’s skills; prior relevant experience; degrees or certifications, etc. Work Authorization: At this time, Coterie Insurance is unable to consider candidates who require current or future visa sponsorship. Applicants must have authorization to work in the United States without the need for sponsorship now or in the future. Falsification of an application, including work authorization status, is immediate grounds for dismissal from consideration. 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!