Senior Data Modeler: AI-Ready Analytics & Lakehouse

Credit Acceptance Corporation; Southfield (MI); Hybrid; USD 137,000 - 191,000; Full time

Benefits offered by this job

401(K) match

Parental leave

Tuition reimbursement

Medical/dental/vision

Adoption assistance

Job summary

Credit Acceptance is seeking a senior data modeling engineer to design and maintain dimensional and relational models within our Databricks lakehouse, aligning with analytics, reporting, and AI needs.

You will partner with data engineers to implement fast ELT pipelines, contribute to a semantic layer, metadata, and governance, and operate in a hybrid, two days remote per week model at hub locations in Southfield, Bellevue, or the San Francisco Bay Area.

Qualifications

• 8+ years in data modeling, data architecture, or analytics engineering.
• Expertise in Kimball dimensional modeling and 3NF relational modeling.
• Experience modeling across multiple source systems in cloud platforms (Databricks).
• Understanding AI-ready data structures and semantic layer concepts.
• Strong SQL and collaboration with ELT pipelines.
• Experience with data modeling tools (ER/Studio, ERwin, dbt).
• Knowledge of data governance, lineage, metadata, and data quality.
• Excellent communication and cross-team collaboration.
• Self-directed and autonomous while following architecture guidance.
• Exposure to semantic layers, governed metrics, or analytics modeling frameworks.
• Willing to relocate to hub locations: Southfield MI area, Bellevue WA, or SF Bay Area.

Responsibilities

• Design and maintain data models for analytics and AI consumption.
• Model data across systems for end-to-end data pipelines.
• Develop semantic layer artifacts for AI-ready analytics.
• Support metadata, glossary, and data dictionary efforts.
• Collaborate with data engineers to implement ELT pipelines.
• Uphold data modeling standards and governance in SDLC.

Skills

Dimensional modeling

Relational modeling

Databricks

SQL

Data governance

Communication

Autonomy

Semantic layer

Tools

ER/Studio

ERwin

dbt

Unity Catalog

Collibra

Job description

Credit Acceptance is seeking a senior data modeling engineer to design and maintain dimensional and relational models within our Databricks lakehouse, aligning with analytics, reporting, and AI needs.

You will partner with data engineers to implement fast ELT pipelines, contribute to a semantic layer, metadata, and governance, and operate in a hybrid, two days remote per week model at hub locations in Southfield, Bellevue, or the San Francisco Bay Area.