Finance Data Modeler | Remote role (support PST time zone) | W2 Only.

Xlysi LLC.; San Francisco (CA); Remote; USD 120,000 - 160,000; Full time

Job summary

Xlysi LLC, Expert Portal Solutions in San Francisco is seeking an experienced Data Modeler to design, develop, and maintain scalable enterprise data models that support analytics, reporting, and data integration initiatives.

The role collaborates with data architects, engineers, analysts, and stakeholders to establish consistent definitions, governance, and standards across the organization. Experience with cloud data platforms and finance data domains is preferred.

Qualifications

• Extensive experience in enterprise data modeling across conceptual, logical, and physical layers.
• Experience with relational and dimensional modeling, data warehousing, and cloud platforms.
• Familiarity with finance data domains and harmonized enterprise data models preferred.
• Ability to establish naming conventions, data standards, and governance.
• Strong collaboration with business and technical stakeholders.

Responsibilities

• Design and maintain enterprise data models for platforms and applications.
• Translate business requirements into scalable data structures.
• Create relational, dimensional, star/snowflake schemas and data models.
• Define keys, relationships, business keys, hierarchies, and reference data.
• Enforce naming standards and data modeling best practices.
• Collaborate with teams to define consistent data definitions.
• Support master data, metadata, and data governance initiatives.
• Document models, lineage, and metadata in catalog tools.
• Participate in design reviews ensuring conformance to architecture.
• Utilize ER/Studio, ERwin, PowerDesigner, Visio, Lucidchart, or similar.
• Ensure historical data support, slowly changing dimensions, traceability.

Skills

Data modeling

Relational data modeling

Dimensional modeling

Data warehousing

Cloud data platforms

Data governance

Data quality

Stakeholder collaboration

ETL

Tools

ER/Studio

ERwin

PowerDesigner

Visio

Lucidchart

Databricks Unity Catalog

Job description

• SFO, CA.

Note: Please ensure your resume includes a valid LinkedIn profile link. Applications without a LinkedIn profile will not be considered.

Job Summary

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.

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 solutions comply with established architecture standards.
• Use data-modeling tools such as ER/Studio, ERwin, PowerDesigner, Visio, Lucidchart, or equivalent platforms.
• Ensure models appropriately support historical data, slowly changing dimensions, auditability, and data traceability where required.
• Contribute to data-quality controls by identifying required fields, valid relationships, integrity constraints, and business rules.
• Knowledge in unity catalog and databricks.

HR Xlysi LLC, Expert Portal Solutions
251 Milwaukee Ave, Buffalo grove, IL 60089
Web : http://www.xlysi.com
E-mail: [e-mail]