Job Description :
Senior Cognos Administrator STZ 3938
Columbus, OH
Long trm

Job Description:

Position Description:

Expert COGNOS ADMINISTRATOR. This person will not write reports; but will instead help determine how to set up Cognos with our Oracle data warehouse. Customer is planning a 1,500-query user implementation, with about 100 report developers. In the current data warehouse, has about 600 tables, including about 300 code tables. These tables are made available to data warehouse users in about 50 data models. The largest tables contain over 20 years of history and exceed 100 million records. The current reporting tool includes about 2,000 reports in 400 documents. will rebuild about 4,500 existing reports in Cognos.

Assignment Responsibilities:
•Suggest the best time to set up data marts, cubes, and dashboards (before go-live or after), given constraints on scope, resources, time, and quality.
•Work with staff on these topics and provide on the job training and mentoring to them, both teaching staff and coaching them as they do this work on their own.
•Make sure is on the right foundation and sets up data marts, cubes, etc. appropriate to most effectively and efficiently meet business requirements, recommend how to set up security, how to deploy reports, how to more efficiently run reports, do tuning and indexing, etc.
• expects the work of the consultant to be done on-site
•Would be available for other questions as needed about security and architecture. –Position requires 40 hours a week. Consultant will help define and also coach
•Determine which Cognos tools will best support business requirements.
•Set up and manage Cognos security at all levels.
•Assist with performance analysis and tuning, -Assist with the development of high-availability reporting environment and disaster recovery plan .Help define the version control strategy for data marts, cubes, data models and reports.
•Help define strategy for converting BWC’s current Hyperion/Brio reports to Cognos.

Skill Sets Required :
10+ years of experience in Cognos.
•3+ years of Cognos 10.x experience required.
•3+ years experience building Cognos cubes
•3+ years experience building a Cognos data warehouse that uses cubes, data marts, data models, and reports.
•At least one complete Cognos implementation in an enterprise environment including, installing, configuring, and tuning Cognos architecture that is distributed over multiple servers.
•3+ years experience with a project migration from another data warehouse tool to Cognos.
Either Cognos Certified and/or public sector

•Experience using Cognos with Oracle databases.
•Experience with the new features and functions of Cognos 10.2.
•Prefer: These IBM Cognos Certifications (Note: The consultant may have earned the certification in Cognos 8: IBM Certified Solution
•Expert - Cognos BI IBM certified Administrator
•Cognos 10 BI IBM Certified Developer
•Cognos 10 BI Metadata Models IBM Certified Developer
•Cognos 10 BI OLAP Models IBM
•Certified Designer- Cognos 10 BI Reports IBM Certified Designer-
•Cognos 10 BI Multidimensional Reports Additional Knowledge/Experience Advantageous to this placement
•Basic Insurance industry knowledge. General Workers'' Compensation Industry knowledge preferred