Sr. Data Modeler

Sarian Solutions Inc. Trusted Partner for your all IT Needs. Title: Sr. Data Modeler (ERWIN or Sybase power designer) Location: Charlotte, NC Type: Full-Time Required Skills/Experience: - Minimum 10 years of experience in design and deployment of logical and physical structures preferably Banking Risk Area (Counterparty Credit Risk Data Domain knowledge) - Minimum 5 years of Experience with Erwin data modeling tools - Minimum 5 years of Experience with development and deployments MSSQL platform - Experience with large, high volume databases is preferred. - Experience performing data profiling - Experience in Data Mart, Dimensional Modeling, Data Warehouse modeling - Ability to work successfully with technical and non-technical groups, and manage multiple tasks at a time - Strong analytical, problem-solving and communication skills - In-depth understanding of both Relational and Domain Modeling techniques - Understanding about BI Reporting Responsibilities : - Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems. - Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions. - Perform source data analysis, data discovery and data profiling. - Provide data structures optimized for information entry and retrieval. - Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures. - Support development team during design process design and during performance tuning. - Participate in both business & IT planning and in the development & management of project plans. - Lead design of Logical and Physical Models - Support ongoing data modeling efforts for Development and Production environments - Contribute to development of processes and guidelines for Data Modeling Thanks Vick Walters Sarian Solutions an IT solutions company Ph: 732.790.2266 Ext: 209 | Fax: 732-790-0944