Other

Data Modeller

Cynosure Technologies LLCColumbus, OH🇺🇸United StatesPosted Oct 15, 2026

Why This Role Stands Out

Advance your career as a Data Modeller at Cynosure Technologies LLC, where you'll shape critical data architecture and leverage tools like Databricks and ERwin. This hybrid role is perfect for experienced professionals eager to enhance their skills in data modeling and contribute to impactful AI/BI initiatives within a reputable company. Seize this opportunity to grow your expertise and make a significant contribution!

Quick Overview

Seniority

Mid Senior

Work mode

Hybrid

Location

Columbus, OH, United States

Posted

20 hours ago

Databricks

Job Description

Role: Modeller
Skills: Digital : Databricks~ERwin~Data Architecture and Modeling
Experience Required: 8-10 years
Role Descriptions-
Skills / Requirements:
Define entities, relationships, and keys (primary/foreign keys) and document cardinalities
Specify table grain (row-level meaning) for each fact/event/feature table
Create dimension tables with consistent codes, descriptions, and hierarchy attributes where applicable
Create fact/event tables with measures, timestamps, and join keys to relevant dimensions/entities
Represent time using standard date/time fields and, when needed, effective start/end dates for history
Standardize naming conventions, data types, units, and allowed values (domains) across models
Add metadata and documentation (field definitions, source system, refresh cadence, owner)
Implement basic validation checks (nullability, uniqueness, referential integrity, value ranges)
Design outputs for common access patterns (joins, filters, aggregations) used by OLAP and AI pipelines
Maintain versioning/change history for models and update downstream dependencies when schemas change
Optimize the models for performance of AI/BI use cases
Good understanding of Databricks concepts
Good understanding of tools like Erwin