Data Modeler: Date Created : 11/13/2014 5:46:25 AM Category : IT Location/City : OH - Cincinnati Job Type : Contract Id : 3026812 The Application Analyst - Data Specialist is responsible for leading in all facets of the data modeling for application enhancements and existing production systems of various sizes and complexities. The Data Specialist performs many of these tasks independently and communicates with the appropriate teams to ensure that assignments are delivered with the highest of quality and in accordance to standards. The Data Specialist may complete data modeling/analytics assignments when necessary to meet the needs of the business.The data modeling/data administration group works with application teams to develop data structures that meet the business requirements. In addition to this, the group maintains the data naming glossary, enforces naming standards, ensures metadata definitions exist for all entities and attributes, generates efficient SQL against master data entities, and profiles and analyzes data to help design data models. For SOA applications, the data modeling group defines web services? inputs/outputs, creates and maintains WSDLs and designs stored procedures.Essential Job Functions: Develop conceptual, logical, and physical data models for OLTP, DSS relational and DSS multidimensional database solutions. Develop and implement strategies and methodologies in support of Master Data Management initiatives. Lead or actively participate in end-user requirement gathering meetings Facilitate modeling sessions and design walk-throughs with DBA and development team members Work with DBA to convert logical data models to physical data models for implementation Gather and maintain accurate metadata in Erwin models. Work with Data Architecture team to ensure proposed database implementation conforms to corporate data strategy. Provide operational support for existing models including impact analysis, logical and physical data model changes and metadata updates. Follow corporate best practices for Data Administration and Data Modeling to support the corporate methodologies. Write efficient SQL and store procedures against database tables on various platforms. Profile and analyze data during the application development. Act as a data SME for developers, testers and business analysts. Create and maintain the XML schema and collaborate with SOA developers during WSDL creation. Tutor and mentor less experienced data models on data modeling best practices.Minimum Position Qualifications: 3 - 5 years of transactional and dimensional data modeling experience on UDB, Oracle or SQL Server platforms. Solid understanding of Master Data Management principles. Demonstrated experience gathering and translating requirements into conceptual, logical and physical data models using Computer Associates Erwin data modeling tool. Solid understanding of canonical model for an Enterprise Message System. Strong communications skills both oral and written, with the ability to influence peers to senior level managers. Must be able to handle multiple projects and assignments concurrently while maintaining high levels of quality and effectiveness with a minimum of supervision. Experience using metadata repositories a plus. Proven customer service skills. Highly motivated and service oriented. Knowledge of SOA governance and design practices a plus. BS in Computer Science or equivalent experience. Knowledge of Service Oriented Architecture (SOA) and complex workflows. Proven communication and presentation skills to effectively communicate information to customers and to all levels within the organization. Ability to interact well in a team environment. Experience with project planning. dlvr.it/7VzCmZ
Posted on: Thu, 13 Nov 2014 13:48:27 +0000
Trending Topics
Recently Viewed Topics
© 2015