Senior Data Modeler

Trinity Technology Solutions LLC; San Diego (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Trinity Technology Solutions LLC is seeking an experienced Data Modeler to design, develop, and maintain scalable enterprise data models that support analytics, reporting, operational applications, and data integration initiatives.

You will work with business stakeholders, data architects, data engineers, analysts, and application teams to translate requirements into clear conceptual, logical, and physical data models.

Qualifications

• Extensive experience in enterprise data modeling across conceptual, logical, and physical layers.
• Strong background in relational and dimensional modeling, data warehousing, and cloud platforms.
• Experience supporting finance data domains and harmonized enterprise data models.
• Ability to collaborate with stakeholders and technical teams to define data standards.

Responsibilities

• Design and maintain enterprise data models for data platforms and applications.
• Translate business requirements into scalable data structures.
• Create relational, dimensional, star/snowflake schemas and domain-oriented models.
• Define keys, business keys, hierarchies, and reference data.
• Maintain documentation, lineage, and metadata.

Skills

Data Modeling

Databricks

Unity Catalog

Job description

Key Skills: Data Modeling, Databricks, and Unity Catalog.

Nice to Have: Exposure to Finance Domain.

About the Role:

We are looking for an experienced Data Modeler to design, develop, and maintain scalable enterprise data models that support analytics, reporting, operational applications, and data integration initiatives. The Data Modeler will work closely with business stakeholders, data architects, data engineers, analysts, and application teams to translate business requirements into clear conceptual, logical, and physical data models. The role will help establish consistent data definitions, relationships, standards, and governance practices across the organization.

The ideal candidate will have strong experience in enterprise data modeling, relational and dimensional modeling, data warehousing, cloud data platforms, and modern data architecture practices. Experience supporting finance data domains and harmonized enterprise data models is preferred. Experience in the Financial domain would be a great plus.

Key Responsibilities:

Design and maintain conceptual, logical, and physical data models for enterprise data platforms and business applications.

Translate business requirements and processes into scalable, reusable data structures.

Develop relational, dimensional, star-schema, snowflake-schema, and domain-oriented data models as appropriate.

Define entities, attributes, relationships, primary keys, foreign keys, business keys, hierarchies, and reference-data structures.

Define and enforce naming conventions, modeling standards, data types, and modeling best practices.

Partner with business and technical teams to establish consistent definitions for critical business data.

Support master data, reference data, metadata, and data-governance initiatives.

Maintain model documentation, business definitions, lineage, and metadata in enterprise modeling or cataloging tools.

Participate in design reviews and ensure proposed database and analytics