Job Details

• Data Modeler
• Location: Houston, Tx.
• Onsite/ Remote/ Hybrid: Hybrid/Onsite(2-3 days onsite every week)

Below is the JD for the Data Modeler:

• Experience in any one of data modeling tool (currently client using SQL DBM)
• Very good knowledge/experience in SQL
• Knowledge on Dimensional Modeling
• Additional skills - Experience in Snowflake Data Cloud
• Min 10 years of Total experience with minimum 5-6 years being Data Modeler or Data Architect.
• Knowledge in both OLTP and OLAP Modelling.
• Experience designing Data Marts and Data Warehouses on Enterprise Scale.
• Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements.
• Experience in ERWIN, SQL Database Modeler or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred.
• Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity.
• Define and enforce data models standard, 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 the requirement and build data model designs with scalable solution.
• Demonstrated ability to understand, produce, and extend large and complex data models for operational and dimensional reporting data stores.
• Knowledge of best practices and design principles building performance efficient models.
• Ability to effectively present complex technical information to non-technical audiences and to senior decision-makers.
• Experience coordinating information requirements of multiple departments, including assessment of usefulness, reliability, and cleanliness of data from several sources.
• Strong SDLC knowledge, with excellent process and application system documentation skills.
• Excellent presentation, communication skill