Data Modeler

Employer
Location
New York
Posted
Apr 17, 2013
Closes
May 17, 2013
Contact
. .
Duration
Full Time
The primary function of this role will be to design and model metadata for predictable reporting and analysis results as well as document the data warehouse reporting entities, including:

Requirements:

Design dimensional data relational and DMR models
Create, enhance, and maintain Framework Manager models according to best practices and optimized for reporting performance
Develop a dictionary of the meta data for available structures
Strong communication and technical skills
Work with DBA and Business SME to understand and document the key relationships and hierarchies in the data
Experience with Big Data a plus.


Duties:

· Gain understanding of business data, relationships and processes, and develop data dictionary definitions

· Design and document new data structures in support of the business requirements. Work with DBA to implement.

· Design and implement Cognos framework models based on business reporting and data requirements

· Develop standards and guidelines to ensure optimize reporting performance. Review reports to ensure they meet performance goals.

· Interface directly with business personnel, technical personnel or team members to develop requirements, design specifications. Develop and maintain professional relationships with other department staff and clients.

· Continuously develop and enhance technical and business skills and expertise. This can be through the following venues: 3rd party training; internal training; professional text books; trade journals; WEB sites. Staff continuously develop and enhance technical and business skills and expertise. This can be through the following venues: 3rd party training; internal training; professional text books; trade journals; WEB sites. Staff skill sets and expertise in specific areas is an asset to the business and a requirement to keep the business competitive in the market place.

Experience:

Typically has 5 to 10 years of IT and business/industry work experience.
Has 5+ years developing Cognos framework models for business analytics for intermediate to complex level reporting
Has database experience with MS SQL Server, Oracle, SQL queries, stored procedures, for interfacing with the database and database designs.
Must have a high level of logical thinking, problem solving ability, analytical skills.
Must have ability to function within a dynamic environment containing priorities and business needs.
Ability to handle multiple tasks/projects/support items concurrently.
Must possess excellent communication (verbal and written), interpersonal and problem solving skills.
Provide detailed information in a clear and concise manner.
Experience in publishing, digital media is a plus. Experience with ‘Big Data’ is a plus







More jobs like this