Posted 126 months ago
Sr. Data Modeler
CharlotteOn-siteFull-time
AI Summary
Sr. Data Modeler translates business and data requirements into logical and physical data models, focusing on banking risk domains (counterparty credit risk). Designs, profiles, and optimizes large-scale data structures for OLTP, data warehouses, and BI reporting.
About this role
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
Additional Information
Thanks
Vick Walters
Sarian Solutions
an IT solutions company
Ph: 732.790.2266 Ext: 209 | Fax: 732-790-0944
Skills
Data ProfilingData WarehousingDimensional ModelingErwinLogical Data ModelingMSSQLPhysical Data ModelingSybase PowerDesigner
Explore related jobs
More jobs at Sarian Solutions
Similar Data Profiling jobs
Jobs in Charlotte
- PsychiatristSeasoned Recruitment · Charlotte, North Carolina
- Mobile Building EngineerLincoln Property Company · Charlotte, New Caledonia
- Community ManagerHawthorne Residential Partners · Hawthorne at Whitehall - 9105 Bowling Green Lane - Charlotte, NC - 28209
Software DeveloperTerrestrial Energy · Charlotte, North Carolina
Data ScientistTerrestrial Energy · Charlotte, North Carolina- Bilingual Community Program Coordinator (Woodland Estates)Project Access Inc · Charlotte, New Caledonia