Data Modeler

Data Modeler

West Lake, CA and Carrolton, TX

Fulltime

The associate must have knowledge on Mortgage Insurance

 Mortgage associates experienced in Servicing domain specifically Active ,Default and Secondary Market + MISMO to be considered for the role”

We are seeking an experienced Data Modeler with 8+ years of experience in designing and implementing scalable data models. The ideal candidate should have strong expertise in SQL, hands-on experience with Snowflake, and experience working with JSON scripting and semi-structured data. The role will collaborate closely with Product Owners, data engineers, analysts, and business stakeholders to design efficient data models that support analytics and reporting needs.

Key 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.

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.

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.