Job Title: Data Modeler (Ref Code: 3/30/12 QJ )

Location: BLUE ASH, Ohio

Duration: 3 Months

Responsibilities :

This 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.

Experience using metadata repositories a plus.

Knowledge of SOA governance and design practices a plus.

Knowledge of Service Oriented Architecture (SOA) and complex workflows.

Strong communications skills both oral and written, with the ability to influence peers to senior level managers.

BS in Computer Science or equivalent experience.

 

 

Send Resumes to Careers@iormyx.com with the Ref Code