Role Data Modeler
Long Term Project
Location Houston TX
- 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 56 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 nontechnical audiences and to senior decisionmakers.
- 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.