Onsite_Data Modeller || Columbus, OH OR Jersey City, NJ - Onsite Locals

Job Type : Contractual

Location : JERSEY CITY

Job Summary

Location:Columbus, OH OR Jersey City, NJ- 100% ONSITE FROM DAY1

WorkArrangement:Onsite

EmploymentType:Contract

ContractDuration:6-12+ Months

KeyResponsibilities

• 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

Skills

• Digital : Databricks
• ERwin~
• Data Architecture and Modeling

WorkAuthorization

ApplicantsmustbelegallyauthorizedtoworkintheUnitedStates.

EqualEmploymentOpportunity

ThemesoftIncisanEqualEmploymentOpportunityemployer.Weconsiderqualifiedapplicantswithoutregardtorace,color,religion,sex,sexualorientation,genderidentity,nationalorigin,age,disability,veteranstatus,oranyotherstatusprotectedbyapplicablefederal,state,orlocallaw.