Data Modeler

Description

1. Requirements Gathering Participate and / or performs a lead role in the gathering, review, interpretation of functional requirements and translate these into IT requirements. Develops and manages relationships with the business users to ensure strategic use of the organizations data assets. Provide problem solving expertise including the formulation and testing of hypothesis, and the complex analysis of data. 2. Data Model Development Uses industry standard data modeling tools, best practices and techniques to design and develop relational data models (conceptual, logical and physical). Establish/enforce the Enterprise information architecture standards through the development of data models, Data flow diagrams, CRUD diagrams and specifications for data integrity and referential integrity. Reviews completed data models using data model scorecards to ensure quality and integrity of the models and alignment with organizational goals of developing an enterprise data model. 3. Metadata Management Assist with development of business naming standards, consistent data definitions, data aliases and documenting the business rules of the enterprise. Ensures the business metadata definition of all data attributes and entities are electronically catalogued in the metadata repository and that the data asset metadata is accurate and available to those who need it. Actively participates in the identification of data and solution patterns as well as taxonomies. 4. Enterprise Data Management Develops policies and procedures for the creation of an Enterprise Data Management Framework and systems interoperability including mapping artifacts to a data architecture framework and managing data/message requirements in an Enterprise Application Integration environment. Assist in the development and enforcement of Data Governance standards, policies and procedures. Technical Skills Data modeling tools ERwin or IBM InfoSphere Data Architect; UML based object modeling, Metadata Management tools; RDBMS Oracle, SQL, MSSQL Server; Business Intelligence and Data Warehousing technologies. Benefits of the Engagement The contract Sr. Data Modeler will play a critical role in the design and development of focused subject area data models that are part of key deliverables for data modeling projects. In addition this resource will also be responsible for several other ongoing and planned capital projects that require the development of data models