Sr. Data Modeler

Sr. Data ModelerTitle: Sr. Data Modeler (ERWIN or Sybase Power Designer)Location: Charlotte, NCType: Full-TimeRequired 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 toolsMinimum 5 years of Experience with development and deployments MSSQL platformExperience with large, high volume databases is preferred.Experience performing data profilingExperience in Data Mart, Dimensional Modeling, Data Warehouse modelingAbility to work successfully with technical and non-technical groups, and manage multiple tasks at a timeStrong analytical, problem-solving and communication skillsIn-depth understanding of both Relational and Domain Modeling techniquesUnderstanding about BI ReportingResponsibilities :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 ModelsSupport ongoing data modeling efforts for Development and Production environmentsContribute to development of processes and guidelines for Data Modeling