Sr. Data Modeler

Sr. Data Modeler

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