Senior Data Modeler

Abacus Insights is a mission-driven, start-up technology company focused on transforming the healthcare payer industry, ultimately creating a more personalized patient experience, improving health outcomes, and lowering the overall cost of healthcare. Abacus Insights provides a flexible, efficient, and secure platform that organizes and exchanges healthcare data from various sources and formats, allowing our customers to uncover differentiated insights that address their clients' needs. Our employees know that they play an active role in keeping our customers' data safe and are responsible for ensuring that our comprehensive policies and practices are met.  

With our deep expertise in cloud-enabled technologies and knowledge of the healthcare industry, we have built an innovative data integration and management platform that allows healthcare payers access to data that has been historically siloed and inaccessible. Through our platform, these health insurance payers can ingest and manage all the data they need to transform their business by supporting their analytical, operational, and financial needs.  

Since our founding in 2017, Abacus has built a highly successful SaaS business, raising more than $81 Million by leading VC firms who have deep expertise in the healthcare and technology industries. We are solving problems of massive scale and complexity in an industry that is not only ready for disruption. We're growing quickly and would love for you to be a part of it!  

About the Role:  

We are looking for a highly technical and hands-on Senior Data Modeler to lead a global data modeling team responsible for transforming conceptual and logical data models into optimized physical ERDs. This role requires a deep understanding of healthcare data domains (Claims, Membership, Enrollment, Provider, Billing, Interoperability - FHIR, HL7, ADT, CCDA, etc.) and expertise in enterprise data modeling best practices.

The Senior Data Modeler will work closely with the Director of Data Modeling to define data modeling standards, metadata governance, and data architecture strategies that align with business and technical needs. They will also collaborate with engineering, client implementation teams, and data governance teams to ensure models support operational and analytical use cases, high performance, and data integrity.

This is an exciting opportunity for a technical leader with expertise in Databricks, Snowflake, schema evolution, and modern data engineering practices to shape the future of healthcare data platforms.

What you'll do:

Data Modeling Leadership & Best Practices

• Lead a global team of data modelers to build scalable, high-performance physical data models aligned with enterprise architecture and industry standards.
• Define and enforce data modeling best practices, including schema evolution, lossless data modeling, metadata management, and data versioning.
• Convert conceptual and logical data models into optimized physical ERDs using enterprise data modeling tools (Erwin, ER/Studio, DBT, or similar).
• Ensure models support analytical (data science, actuarial, reporting) and operational (Claims, Care Management) use cases.
• Maintain metadata, business glossary, and data dictionaries to support data lineage and governance.
• Implement data quality rules and validation frameworks to meet industry SLAs and compliance requirements (HIPAA, HITRUST, CMS regulations).

Technical Data Modeling Engineering

• Own data modeling workflows, including version control, schema deployment, and upgrade automation.
• Work with engineering teams to implement data models in Databricks, Snowflake, and modern cloud architectures.
• Optimize data models for query performance, indexing, partitioning, and storage efficiency.
• Ensure data enrichment (standardization, transformations, algorithms, and grouping) is seamlessly integrated into the data models.
• Design and document data delivery patterns using complex events or business rules to enable real-time and batch processing.
• Implement data federation strategies, ensuring interoperability between enterprise data lakes, cloud data warehouses, and transactional systems.

Collaboration & Client Engagement

• Collaborate with Director of Data Modeling and client implementation teams to understand client needs, assess data model impact, and enhance models for efficient implementations.
• Partner with engineering and product teams to define and prioritize data model features in the product roadmap.
• Work with client management teams to provide support and technical expertise during client engagements.

What We're Looking For:

• 8+ years of experience in data modeling, enterprise data architecture, and cloud-based data engineering.
• 4+ years leading data modeling teams in enterprise environments.
• Expertise in enterprise data modeling tools (Erwin, ER/Studio, DBSchema, or similar).
• Strong hands-on experience with cloud data platforms (Databricks, Snowflake) and data lakehouse architectures.
• Deep understanding of healthcare data models across Core Payer (Claims, Membership, Enrollment, Provider, Billing, Premium) and Clinical Interoperability (FHIR, HL7, ADT, CCDA, etc.) domains.
• Experience with schema evolution, lossless data modeling, and data versioning strategies.
• Strong background in SQL, performance tuning, and query optimization for large-scale datasets.
• Hands-on experience with data engineering workflows, including data pipeline integration, ELT/ETL optimizations, and data transformation frameworks.
• Ability to mentor junior modelers, enforce modeling best practices, and drive adoption of enterprise data standards.
• Excellent collaboration skills to work with data architects, engineers, and client implementation teams.

What we would like to see but not required:

• Experience with OBT, data Lakehouse, and metadata management frameworks.
• Familiarity with business intelligence (BI) and reporting solutions on modern cloud data warehouses.
• Knowledge of APIs, SDKs, and data distribution frameworks for enabling real-time and batch data access.
• Experience with data governance, security, and regulatory compliance in healthcare data management.

Equal Opportunity Employer  

As a mission-led technology company that is helping to drive better healthcare outcomes, Abacus Insights believes that the best innovation and value we can bring to our customers comes from diverse ideas, thoughts, experiences, and perspectives. We are dedicated to building diverse teams and providing equal employment opportunities to all applicants. Abacus prohibits discrimination and harassment of any type regarding race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.