Data Architect

External job listingat Vsiontek

Data Architect in Columbus, OH / Jersey City, NJ. 6+Months contract. Good understanding of Databricks concepts and tools like Erwin. Share your resume.

External source - not verified5 weeks agoOpen until: Jan 14, 2027

Salary

Not provided

Location

Columbus, United States

Employment type

Full time

Workplace

Not provided

Data Architect

Columbus, United States

Job description

Tasks

  • 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

Requirements

  • Good understanding of Databricks concepts
  • Good understanding of tools like Erwin

Schedule

  • 6+Months Contract

How to apply

  • Share your updated resume

Location

  • Columbus, OH / Jersey City, NJ

Similar jobs