Sr. Data Modeler

Role Sr. Data Modeler

Long Term Project

Location Houston, TX

Experience - 12+ Years

• 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 skills.

Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.