Logical Data Modeler (w/ Erwin)
Adroit Software, Inc. - Charlotte, NC

This job posting is no longer available on Dice. Find similar jobs: Logical Data Modeler jobs - Adroit Software jobs

Targeted Skills & Competencies: The Logical Data Modeler is responsible for creating logical data models that follow the Enterprise Logical Data Model concepts and standards to provide designs that meet the various project requirements. He or she will be familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals. The Logical Data Modeler will work with delivery teams to meet project deliverables by developing and maintaining logical data models based on business requirements. Expected Responsibilities: Responsibilities * Participate in the development of the conceptual and logical data models for strategic projects across the Enterprise * Collaborate with the other Data Modeling Architects to leverage existing models and to refine and extend those models for specific applications and projects * Collaborate closely with business analysts and data subject matter experts to ensure the data models produced will properly support business needs.

  • Deliver data model designs using both Agile and Waterfall methodologies to multiple project teams * Work closely with database administration to establish and maintain highly resilient, scalable and high performance architecture as the model is implemented physically on the target platform(s). * Assist project teams in requirements gathering and analysis in order to deliver data models that meet project goals Tasks and Responsibilities: See above Suggested Experience & Qualifications: Qualifications * A minimum of a bachelor of science in Computer Science, CIS/MIS or equivalent degree from an accredited four year institution. * A minimum of 5 years of experience with data modeling (conceptual, logical and physical model design) * Knowledge of application modeling languages / techniques (e.g. UML, OML, entity relationship modeling, DFDs) including the ability to create and read the associated diagrams.
  • At least 3 years of direct experience using Erwin to produce logical data models * Experience working with IBM's Banking and Financial Data Warehouse Industry Models, IBM's Insurance Information Warehouse Models or relevant experience in financial services * Extensive experience modeling data requirements based on complex business needs across multiple information domains with an emphasis on mapping to established industry models * Excellent verbal and written communication skills. * 3 to 5 years of experience working with financial services preferably with annuity, insurance, fixed income or mutual funds products * Solid skills in normalization and 3NF structures supporting operational systems and enterprise warehouses * Must have an understanding of dimensional modeling * A proven ability to develop data models with proper atomic level granularity and time variant constructs to ensure the enterprise data assets are captured, stored, maintained and aged appropriately * Solid understanding of transaction and information systems, data warehouses, data marts, ODS, MDM methodologies and life cycles as well as ETL and MDM technologies. * Familiarity with performance tuning techniques in both the Teradata and Oracle environments such as partitioning, conditional RI, Bitmap indexes, Mviews, CUBEs, Dimension and fact definitions as well other de-normalization techniques. * Experience relating to the implications of specific modeling / implementation techniques on both the Oracle and Teradata platforms.
data modeler , Erwin , Data warehouse , Logical, Oracle

Dice - 13 months ago - save job - block