Data Modeler || Columbus OH

Columbus, OH, US • Posted 9 hours ago • Updated 7 hours ago
Contract W2
Contract Independent
Contract Corp To Corp
Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Artificial Intelligence
  • Documentation
  • ERwin
  • Meta-data Management
  • OLAP
  • Business Intelligence
  • Cadence
  • Data Architecture
  • Databricks
  • Dimensional Modeling

Summary

Role: Data Modeler Columbus OH
Skills: Digital : Databricks~ERwin~Data Architecture and Modeling
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10299481
  • Position Id: 9103297
  • Posted 9 hours ago
Contact the job poster
Sachin Agrawal

Sachin Agrawal

IT Recruiter @ McKinsol Consulting Inc
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Columbus, Ohio

•

3d ago

Easy Apply

Contract, Third Party

Depends on Experience

Columbus, Ohio

•

Yesterday

Easy Apply

Full-time

Depends on Experience

Remote

•

Yesterday

Easy Apply

Contract

Up to $65

Remote

•

Today

Full-time

Search all similar jobs