Sr. Data Modeler

Sarian Solutions; Charlotte (NC); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company in the banking sector seeks a Data Modeler with extensive experience in logical design, data profiling, and collaboration with technical teams. Responsibilities include translating business needs into data models and enhancing database performance for large information systems. Ideal candidates should possess strong analytical skills and relevant tools expertise.

Qualifications

• Minimum 10 years in data design and deployment, ideally in banking.
• Five years with Erwin and MSSQL experience required.
• Strong analytical, problem-solving, and communication abilities.

Responsibilities

• Translate business and data requirements into logical data models.
• Analyze source data and implement solutions for database performance.
• Lead design efforts for both Logical and Physical Models.

Skills

Data Modeling

Data Profiling

Analytical Skills

Communication Skills

Problem Solving

Tools

Erwin

MSSQL

Job description

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

Additional Information

Thanks

Vick Walters

Sarian Solutions

Ph: 732.790.2266 Ext: 209| Fax: [phone]