V
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