Description

You will design and maintain conceptual, logical, and physical data models for enterprise platforms, with a focus on Snowflake data warehouse environments.

Responsibilities

• Design and optimize data models for scalability, performance, and accessibility within Snowflake.
• Write complex, optimized SQL queries for data transformation, validation, and analysis.
• Ingest, parse, and transform semi-structured data, specifically JSON.
• Collaborate with Product Owners, data engineers, and stakeholders to translate business requirements into technical data models.
• Maintain data documentation, lineage, and metadata for enterprise datasets.

Required Skills

• 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 environments.
• Experience working with JSON scripting and semi-structured data.
• Strong understanding of dimensional modeling techniques, including Star Schema and Snowflake Schema.
• Ability to implement best practices for naming conventions and documentation.
• Experience in the Mortgage domain or knowledge of MISMO standards is preferred.

Preferred Skills

• Familiarity with enterprise data governance and metadata management tools.
• Knowledge of mortgage industry data standards (MISMO).

Key Skills

Education

Any Graduate