The Dignify Solutions, LLC
Data Modeler - Hybrid (Fulltime)
The Dignify Solutions, LLC, Houston, Texas, United States, 77246
Overview
Data Modeler / Data Architect with strong experience in data modeling, dimensional modeling, and data warehousing. Must be proficient in SQL and have hands-on experience with modern data modeling tools and cloud platforms. Responsibilities 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. Design and create data models (Conceptual, Logical, and Physical) as per business requirements. Design Data Marts and Data Warehouses at an enterprise scale. Work with business users to gather requirements and build scalable data model designs.
Qualifications
Experience in at least one data modeling tool (e.g., ER/Studio, ERWIN, SQL Database Modeler) with preference for Snowflake data cloud experience. Very strong SQL knowledge. Knowledge of Dimensional Modeling; experience with OLTP and OLAP modeling. Experience designing Data Marts and Data Warehouses at enterprise scale. Ability to create data models across Conceptual, Logical, and Physical layers. Experience in Snowflake Data Cloud; additional experience with Oracle and SQL Server is preferred. Familiarity 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. Experience with data governance concepts and collaboration with cross-functional teams.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at The Dignify Solutions, LLC by 2x. Get notified about new Data Modeler jobs in
Houston, TX . #J-18808-Ljbffr
Data Modeler / Data Architect with strong experience in data modeling, dimensional modeling, and data warehousing. Must be proficient in SQL and have hands-on experience with modern data modeling tools and cloud platforms. Responsibilities 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. Design and create data models (Conceptual, Logical, and Physical) as per business requirements. Design Data Marts and Data Warehouses at an enterprise scale. Work with business users to gather requirements and build scalable data model designs.
Qualifications
Experience in at least one data modeling tool (e.g., ER/Studio, ERWIN, SQL Database Modeler) with preference for Snowflake data cloud experience. Very strong SQL knowledge. Knowledge of Dimensional Modeling; experience with OLTP and OLAP modeling. Experience designing Data Marts and Data Warehouses at enterprise scale. Ability to create data models across Conceptual, Logical, and Physical layers. Experience in Snowflake Data Cloud; additional experience with Oracle and SQL Server is preferred. Familiarity 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. Experience with data governance concepts and collaboration with cross-functional teams.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at The Dignify Solutions, LLC by 2x. Get notified about new Data Modeler jobs in
Houston, TX . #J-18808-Ljbffr