Analysis Skills, Best Practices, Communication Skills, Cross-Functional, Data Analysis, Data Modeling, Data Sets, Data Structures, Data Warehousing, Database Design, Database Technology, Dimensional Modeling, Documentation, Financial Services, JSON, Metadata, Mortgage, Performance Management, Problem Solving Skills, Query Optimization, Relational Databases (RDBMS), Requirements Management, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Snowflake Schema, Star Schema, Structured Data
Job Title: Data Modeler Architect
Duration- Fulltime Permanent
Location: West Lake, CA or Carrolton, TX Onsite
Job Description:
Data Modeler
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.
Q
Q1 Technologies, Inc
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.