Sr. Data Modeler Job at Siri InfoSolutions Inc, Jersey City, NJ

VEZqSmlNUldUUTNib1Zjb3F5RFFPUXZUWkE9PQ==
  • Siri InfoSolutions Inc
  • Jersey City, NJ

Job Description

Job Title: Sr. Data Modeler

Location: Jersey City, NJ or Columbus, OH 5-day on-site role

Long-term Project

Job Description:

  • 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

Job Tags

Hourly pay, Permanent employment, Full time, Contract work, Part time, For contractors, Internship, Seasonal work

Similar Jobs

Hyatt Hotels

Housekeeper/Room Attendant- Extra Job at Hyatt Hotels

 ...clean and neat. Replenish chemical bottles. Report all missing items from room (i.e., irons/boards, hair dryers, etc.) to Housekeeping Supervisor/Manager. Report any maintenance repairs immediately to Housekeeping Supervisor/Manager. Handle items for "Lost... 

Bridge Property Management

Power BI Developer Job at Bridge Property Management

 ...Make an impact Working alongside a small, dynamic data and technology group, you'll be the core resource for our Power BI development and reporting architecture. You'll design and build the reports and dashboards that leadership and operators rely on every day and... 

Confidential

Human Resources / Recruiter Job at Confidential

We are looking for atemporary to hire Recruiter / Generalistto join our HR team, supporting two locations in the northeast. This position...  ...Coordinating and scheduling interviews, both onsite and virtual Supporting the HR team with other recruitmentrelated tasks... 

Contact Discovery Services LLC

Digital Forensic Analyst Job at Contact Discovery Services LLC

 ... Digital Forensic Analyst Contact Discovery Services - Washington, DC Location: Remote Start Date: Negotiable A leading eDiscovery technology and consulting firm headquartered in Washington, DC is looking for a qualified and experienced Digital Forensic... 

Red Robin

Bartender Job at Red Robin

 ...education Open to applicants who do not have a college diploma Equal Opportunity Employer This is a tipped role and the estimate provided is based on you being paid the tip credit minimum wage plus estimated tip income. #9total #redrobin250bartender #redrobin