Senior Data Modeler: AI-Ready Data & Semantic Layers

Credit Acceptance; United States; On-site; USD 114,000 - 167,000; Full time

Benefits offered by this job

401(k) match

Adoption assistance

Parental leave

Tuition reimbursement

Medical, dental, vision benefits

Job summary

Credit Acceptance is seeking a Senior Data Modeler to design and evolve high-quality data models across our modern data platform. You will combine hands-on modeling with growing involvement in AI-ready data practices, including semantic layers, enriched metadata, and governed metrics to support analytics and AI use cases.

As a key contributor in the Data Engineering team, you will translate business requirements into well-governed models that serve analytics, reporting, and AI consumption while

Qualifications

• 8+ years of experience in data modeling, data architecture, or analytics engineering roles.
• Strong hands-on expertise in dimensional modeling (Kimball) and relational modeling (3NF).
• Experience modeling data across multiple source systems in cloud data platforms (Databricks or similar).
• Awareness of how data models serve downstream AI and analytics use cases, with willingness to deepen expertise in semantic layer design and AI-ready data structures.
• Proficient SQL skills and experience working closely with data engineers on ELT pipelines.
• Experience with data modeling and design tools (ER/Studio, ERwin, SqlDBM, dbt, or similar).
• Understanding of data governance concepts including lineage, metadata management, and data quality.
• Strong communication skills and ability to collaborate across technical and business teams.
• Self-directed and comfortable operating with autonomy while working within established architectural direction.
• Experience with or exposure to semantic layers, governed metrics, or analytics modeling frameworks.

Responsibilities

• Design and maintain logical and physical data models (dimensional, relational) across our Databricks lakehouse environment.
• Apply Kimball star schema and normalized modeling best practices.
• Translate business requirements into clear, well-documented data structures for analytics, reporting, and AI consumption.
• Model data with lifecycle awareness across systems, integration layers, and downstream consumers.
• Develop semantic layer artifacts to enable AI agents and self-service analytics to interpret data correctly.
• Contribute to data element identification, glossary development, and metadata tooling to reduce manual cataloging.
• Collaborate with data engineers to implement models in ELT pipelines and denormalized views.
• Adhere to and refine enterprise data modeling standards and design patterns within the SDLC.

Skills

Data modeling

Dimensional modeling (Kimball)

Relational modeling (3NF)

SQL

Communication

Education

Bachelor's degree in a related field

Tools

Databricks

Unity Catalog

Delta Lake

ER/Studio

ERwin

SqlDBM

dbt

Job description

Credit Acceptance is seeking a Senior Data Modeler to design and evolve high-quality data models across our modern data platform. You will combine hands-on modeling with growing involvement in AI-ready data practices, including semantic layers, enriched metadata, and governed metrics to support analytics and AI use cases.

As a key contributor in the Data Engineering team, you will translate business requirements into well-governed models that serve analytics, reporting, and AI consumption while