The Dignify Solutions, LLC
Data Modeler - Hybrid (Fulltime)
The Dignify Solutions, LLC, Houston, Texas, United States, 77246
Overview
Data Modeler role requiring extensive experience in data modeling, data warehousing, and dimensional modeling. The position involves collaborating with DBAs and Data Engineers to translate models into physical structures and establishing standards for data models. Responsibilities
Collaborate with Database Administrators and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity. Design data models including Conceptual, Logical, and Physical models as per requirements. Define and enforce data model standards, naming conventions, and best practices to maintain data consistency and quality. Work with business users to gather requirements and build scalable data model designs. Qualifications
Experience in at least one data modeling tool (currently SQL DBM is used by the client). Very strong knowledge/experience in SQL. Knowledge of Dimensional Modeling. Snowflake Data Cloud experience is required; additional experience with Oracle and SQL Server databases is preferred. Experience in designing Data Marts and Data Warehouses at an enterprise scale. Experience creating data models across Conceptual, Logical, and Physical layers. Experience with ERWIN, SQL Database Modeler, or ER/Studio is required; additional Model Mart management experience is preferred. Experience with Informatica PowerCenter is a plus but not mandatory. Minimum 10+ years of total experience with at least 5-6 years as a Data Modeler or Data Architect. Knowledge of both OLTP and OLAP modeling. Hybrid or on-site collaboration with business users to translate requirements into scalable models. Seniority level
Mid-Senior level Employment type
Full-time Job function
Other Industries
IT Services and IT Consulting Location: Houston, TX Salary: $57,100.00-$103,700.00 #J-18808-Ljbffr
Data Modeler role requiring extensive experience in data modeling, data warehousing, and dimensional modeling. The position involves collaborating with DBAs and Data Engineers to translate models into physical structures and establishing standards for data models. Responsibilities
Collaborate with Database Administrators and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity. Design data models including Conceptual, Logical, and Physical models as per requirements. Define and enforce data model standards, naming conventions, and best practices to maintain data consistency and quality. Work with business users to gather requirements and build scalable data model designs. Qualifications
Experience in at least one data modeling tool (currently SQL DBM is used by the client). Very strong knowledge/experience in SQL. Knowledge of Dimensional Modeling. Snowflake Data Cloud experience is required; additional experience with Oracle and SQL Server databases is preferred. Experience in designing Data Marts and Data Warehouses at an enterprise scale. Experience creating data models across Conceptual, Logical, and Physical layers. Experience with ERWIN, SQL Database Modeler, or ER/Studio is required; additional Model Mart management experience is preferred. Experience with Informatica PowerCenter is a plus but not mandatory. Minimum 10+ years of total experience with at least 5-6 years as a Data Modeler or Data Architect. Knowledge of both OLTP and OLAP modeling. Hybrid or on-site collaboration with business users to translate requirements into scalable models. Seniority level
Mid-Senior level Employment type
Full-time Job function
Other Industries
IT Services and IT Consulting Location: Houston, TX Salary: $57,100.00-$103,700.00 #J-18808-Ljbffr