Data Architect

About Coterie Insurance

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!

What You'll Do as a Data Architect

The Data Architect will serve as a strategic and technical bridge between Coterie’s Data and Analytics team (DnA) and Engineering teams, ensuring alignment in how data is modeled, governed, and consumed across the organization. This role will drive the definition and enforcement of scalable data architecture standards, oversee OLTP domain modeling, and establish stable, business-aligned data contracts to support both internal analytics and external data exchange. As a cross-functional collaborator and thought leader, the Data Architect plays a critical role in enabling secure, reliable, and performant data systems that meet the needs of DnA, Engineering, Growth, and Insurance teams.

• Serve as the architectural bridge between DnA and Engineering departments, ensuring alignment between the needs and standards for DnA, Engineering, Growth and Insurance.
• Collaborate closely with data engineers, data analysts, data scientists and software engineers to ensure consistent implementation of architectural decisions.
• Establish and enforce data architecture standards, best practices and design patterns across the organization.
• Ensure data models meet requirements for governance, security, privacy, reliability and performance.
• Support data governance initiatives, including data quality, lineage, metadata management and regulatory compliance.
• Own OLTP domain modeling and schema design, ensuring source systems represent business entities, workflows and constraints correctly before data lands downstream.
• Create and maintain a domain map and canonical model, clarifying boundaries between services/domains and preventing duplicated or conflicting representations of the same concepts.
• Create and maintain stable, business-aligned data contracts that power reliable ingestion into a lakehouse.

What We Are Looking For

• Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, Engineering or a related quantitative field.
• 7+ years of experience in data architecture, data engineering, software development or related roles.
• Demonstrated experience working in regulated industries such as insurance (preferred), banking or financial services.
• Strong understanding of data modeling and data warehousing concepts.
• Proficiency in multiple scripting languages (e.g., Python, SQL).
• Ability to collaborate effectively across DnA and Engineering teams, balancing analytical requirements with engineering constraints.
• Strong communication skills with the ability to explain architectural decisions to both technical and non-technical stakeholders.
• Experience designing and supporting cloud-based data platforms (e.g., AWS, Azure or GCP).
• Extensive experience with:
• Event modeling (batch and streaming)
• Databricks
• Relational and document-based data structure

What Will Make You Stand Out

• Familiarity with data governance frameworks and regulatory requirements (e.g., SOC 2, SOX).
• Experience supporting analytics, business intelligence and data science use cases.
• Prior leadership or mentorship experience within technical teams.

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: Phone Interview. Qualified candidates will first meet with a member of our People Operations team for a high-level discussion about your background and interests, and for us to share more about Coterie and the position.

Phase 2: Hiring Manager Interview. Selected candidates will be invited to meet with our Hiring Manager for a 30-minute Teams video interview, designed to be more detail-oriented about the role.

Phase 3: Experiential Exercise & Team Discussion. Top candidates will participate in an experiential exercise. Following a review of your project work, select candidates will then advance to interview to dive deeper into their project and discuss their approach with the team (1-2 hours).

Phase 4: Senior Leadership Interview. Final candidates will be invited to meet with a member of our senior leadership team for a 30-minute interview.

What's In It For You

Coterie has excellent benefits for all full-time employees. We offer the following:

• 100% remote work arrangement.
• Health insurance through Aetna (100% employer-paid premiums).
• Dental and vision insurance through Guardian (100% employer-paid premiums).
• Basic life insurance (100% employer-paid premiums).
• Access to flexible spending account (FSA) or health savings account (HSA).
• 401K plan (up to 4% match with immediate vest, 21+ age requirement).
• Flexible PTO policy: up to 3 weeks in the first year, transitioning to 4-5 weeks annually after the first year.
• 12 company-paid holidays each year.
• Continuing education annual stipend.
• Annual salary estimated between $135,000-$165,000, based on national data, skills, and experience.

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.

Key Skills/Competency

• Data Architecture
• Data Modeling
• Data Governance
• OLTP Design
• Cloud Platforms (AWS/Azure/GCP)
• Event Modeling
• Databricks
• SQL
• Python
• Regulatory Compliance