Cognos Architect (37394)

IDEALFORCE has a CONTRACT position available immediately for a Sr Cognos Architect (Product Specialist 5/PS5) to join our customer in Columbus, OH. This is an ONSITE position and will require an in person interview. Please find below additional details about this job.

Our Client is looking for an expert Cognos Resource. This person will not write reports; but will help Client determine how to set up Cognos with their Oracle data warehouse. Client is planning a 1,500-query user implementation, with about 100 report developers. In the current data warehouse, Client 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. Client will rebuild about 4,500 existing reports in Cognos.

• 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 Client staff on these topics and provide on the job training and mentoring to them, both teaching Client staff and coaching them as they do this work on their own.

• Make sure Client 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.

• Client 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 Client's 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 Client's current Hyperion/Brio reports to Cognos.

Skill Sets Required 

• Three years of experience in Cognos higher.

• One year of Cognos 10.x experience.

• One year experience building Cognos cubes 

• Experience building a Cognos data warehouse that uses cubes, data marts, data models, and reports. 

• At least one complete Cognos implementation including, installing, configuring, and tuning Cognos architecture that is distributed over multiple servers. 

• Experience with a project migration from another data warehouse tool to Cognos.

Prefer: 

• 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

Interview Process: Initial 15 minute phone call for 1st Round. 2nd round face to face. No Skype Interview. 

Additional Information : 

- "All your information will be kept confidential according to EEO guidelines". 

- All candidates who are authorized to work in US are encouraged to apply.

- Candidates must clear the Background check prior to commencing the assignment. 

THIRD PARTY CANDIDATES:

Email your candidate/s resume to  joseph dot shelton at idealforce.com along with the following details: Rate, Current location and Availability.

Disclaimer : 

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.