Data Modeler

Data Modeler Architect

Westlake Village,California / Carrolton, TX

Full-Time/Permanent

Job Description

Required Qualifications

• 8+ years of experience in data modeling and database design.

• Strong expertise in SQL and relational database concepts.

• Hands-on experience with Snowflake data warehouse.

• Experience working with JSON scripting and semi-structured data.

• Strong understanding of dimensional modeling (Star Schema, Snowflake Schema).

• Experience collaborating with cross-functional teams including Product Owners.

• Excellent analytical, problem-solving, and communication skills.

Preferred Qualification

• Experience in the Mortgage or Financial Services domain is preferred but not mandatory.

Roles & Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models for enterprise data platforms.

• Build and optimize data models for Snowflake data warehouse environments.

• Write complex and optimized SQL queries for data transformation, validation, and analysis.

• Work with semi-structured data (JSON) for ingestion, parsing, and transformation.

• Collaborate closely with Product Owners, data engineers, analysts, and business stakeholders to translate business requirements into scalable data models.

• Implement best practices for data modeling, naming conventions, and documentation.

• Optimize data structures to improve performance, scalability, and data accessibility.

• Maintain data documentation, lineage, and metadata for enterprise datasets.

Job Insights

must have MISMO OR Mortgage Domain