Position: Data Modeler (Ref Code: 112112-JANQUI-IO40E-JOH)

Location: BLUE ASH, Ohio

Duration: 6 Months

Description:

The Data Modeler 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 Modeler 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 Modeler 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 client's 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.
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.
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.
Experience with project planning.
Ability to travel independently (10%)
Desired Previous Job Experience
IS related associate degree, or a bachelors degree, or comparable work experience in an Information Systems position or related business position.
Experience with large-scale system design and integration tasks, comprising design and implementation of major systems.
Prior experience with project planning with large size or large level complexity projects.

==========================================================================================

 

Available candidate please respond to johnsonm@iormyx.com ASAP