Sarian Solutions Inc.
Trusted Partner for your all IT Needs.
Job DescriptionTitle: 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
Skills Required
- Minimum 10 years design and deployment of logical and physical data structures
- Banking Risk Area experience (Counterparty Credit Risk Data Domain knowledge)
- Minimum 5 years experience with Erwin data modeling tools
- Minimum 5 years experience with development and deployments on MSSQL platform
- Experience with large, high volume databases
- Experience performing data profiling
- Experience in Data Mart, Dimensional Modeling, Data Warehouse modeling
- Ability to work with technical and non-technical groups and manage multiple tasks
- Strong analytical, problem-solving and communication skills
- In-depth understanding of Relational and Domain Modeling techniques
- Understanding of BI Reporting
What We Do
Sarian Solutions Inc. is a global information technology and business solutions provider specializing in IT consulting and staffing services. The company delivers comprehensive business solutions using digital technologies including cloud, mobile, security, and data analytics. As a trusted partner, they empower businesses of all sizes to achieve digital transformation through custom software development, strategic guidance, and global talent acquisition.
.png)
