Job ID: JOB_ID_6881
Job Description:
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.
Skills:
- Data Concepts & Data Modelling
- Data Architecture and Modeling
- Enterprise Architecture
- Snowflake Data Warehouse
- SQL
- JSON Scripting
- Dimensional Modeling (Star Schema, Snowflake Schema)
- Mortgage Domain or MISMO Standards
Experience Required:
8-10 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.
Special Requirements
Candidates must have experience in Data modeling within mortgage domain or MISMO standards. Location options: West Lake, CA or Carrolton, TX. Rate: $58/hr on C2C. Keywords: California Texas.
Compensation & Location
Salary: $120,640 – $120,640 per year
Location: Westlake, CA
Recruiter / Company – Contact Information
Email: ish@siraconsultinginc.com
Recruiter Notice:
To remove this job posting, please send an email from
ish@siraconsultinginc.com with the subject:
DELETE_JOB_ID_6881