The Dignify Solutions, LLC
Data Modeler - Hybrid (Fulltime)
The Dignify Solutions, LLC, Houston, Texas, United States, 77246
Data Modeler
Location: Houston, TX | Salary range: $106,900.00 - $176,500.00 | Employment type: Full-time | Seniority level: Mid‑Senior level | Job function: Other | Industries: IT Services and IT Consulting
Responsibilities & Qualifications
Experience in any one of data modeling tools (currently client is using SQL DBM)
Very good knowledge/experience in SQL
Knowledge of dimensional modeling
Additional skills: experience in Snowflake Data Cloud
Minimum 10+ years of total experience with a minimum of 5‑6 years as a Data Modeler or Data Architect
Knowledge in both OLTP and OLAP modeling
Experience designing data marts and data warehouses on an enterprise scale
Demonstrated capability in designing and creating data models—including conceptual, logical, and physical models—as per requirements
Experience in ERWIN, SQL Database Modeler, or ER/Studio as modeling tools is required; additional model mart management experience preferred
Collaborate with database administrators and data engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data model standards, naming conventions, and best practices to maintain data consistency and quality
Experience in Snowflake Data Cloud
Additional experience in Oracle and SQL Server databases preferred
Experience in Informatica PowerCenter is a plus but not mandatory
Work with business users on requirements and build scalable data model designs
#J-18808-Ljbffr
Responsibilities & Qualifications
Experience in any one of data modeling tools (currently client is using SQL DBM)
Very good knowledge/experience in SQL
Knowledge of dimensional modeling
Additional skills: experience in Snowflake Data Cloud
Minimum 10+ years of total experience with a minimum of 5‑6 years as a Data Modeler or Data Architect
Knowledge in both OLTP and OLAP modeling
Experience designing data marts and data warehouses on an enterprise scale
Demonstrated capability in designing and creating data models—including conceptual, logical, and physical models—as per requirements
Experience in ERWIN, SQL Database Modeler, or ER/Studio as modeling tools is required; additional model mart management experience preferred
Collaborate with database administrators and data engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data model standards, naming conventions, and best practices to maintain data consistency and quality
Experience in Snowflake Data Cloud
Additional experience in Oracle and SQL Server databases preferred
Experience in Informatica PowerCenter is a plus but not mandatory
Work with business users on requirements and build scalable data model designs
#J-18808-Ljbffr