Senior Data Modeler - On-site AI/BI Data Architect

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

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.