Data Modeler / Data Architect (Databricks & Erwin)

Location: Columbus, OH OR Jersey City, NJ- 100% ONSITE FROM DAY1Duration: 6 months (Extendable)

Pay Range: $55-60/Hour on W2/C2C (All Inclusive)

Skills: Digital: Databricks~ERwin~Data Architecture and ModelingExperience Required: 8-10 yearsDefine entities, relationships, and keys (primary/foreign keys) and document cardinalitiesSpecify table grain (row-level meaning) for each fact/event/feature tableCreate dimension tables with consistent codes, descriptions, and hierarchy attributes where applicableCreate fact/event tables with measures, timestamps, and join keys to relevant dimensions/entitiesRepresent time using standard date/time fields and, when needed, effective start/end dates for historyStandardize naming conventions, data types, units, and allowed values (domains) across modelsAdd 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 pipelinesMaintain versioning/change history for models and update downstream dependencies when schemas changeOptimize the models for performance of AI/BI use casesGood understanding of Databricks conceptsGood understanding of tools like Erwin