Sr. Data Modeler

Siri InfoSolutions Inc; Jersey City (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Siri InfoSolutions Inc is seeking a Sr. Data Modeler for a long-term, on-site role in Jersey City, NJ or Columbus, OH. The candidate will define entities, relationships, keys, and grain; create dimension and fact tables; standardize naming, data types, and domains; and maintain metadata and versioning for BI and AI pipelines.

Proficiency with Databricks, Erwin, and strong SQL skills are required to design robust data models that support AI/BI workloads and scalable analytics solutions.

Qualifications

• Define entities, relationships and keys with documented cardinalities.
• Specify grain for fact/event and dimension tables.
• Create fact/dimension models with measures, keys, timestamps.
• Standardize naming, data types and domains across models.
• Add metadata including source, owner, cadence.
• Implement basic validation: nullability, uniqueness, RI, ranges.
• Design for OLAP and AI pipelines with efficient access patterns.
• Maintain versioning and update downstream dependencies.

Responsibilities

• Define entities, relationships and keys (PK/FK) and doc cardinalities.
• Specify table grain for fact/event tables and dimensions.
• Create dimension tables with codes, descriptions and hierarchies.
• Create fact/event tables with measures and join keys.
• Represent time with standard date/time fields and history windows.
• Standardize naming conventions, data types and domains.
• Add metadata and documentation: sources, cadence, owner.
• Implement basic validation: nullability, uniqueness, RI, ranges.
• Design outputs for OLAP and AI pipelines via joins/filters.
• Maintain versioning and update downstream dependencies.

Skills

Data modeling

Databricks concepts

Dimensional modeling

SQL

Erwin

OLAP/BI pipelines

Documentation

Data governance

Performance optimization

Versioning

Tools

Erwin

Databricks

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