Short Description:
BWC’s IT Enterprise Solutions Management department is in search of a Product Specialist 5 with a lot of experience with Cognos.
Complete Description:
This is a new position not currently staffed. Approximately 520 hours projected for FY13. We prefer a candidate with whom you already have experience, not Internet solicitations. The successful candidate will be a self-starter, and requires a person who is detail oriented. Candidate must be able to work both independently and as a team member to produce on time results to meet all project deadlines. Critical deadlines for this RFQ are provided below. Vendors need only respond if all deadlines are attainable, regardless of non-workdays, holidays, weather conditions or other interferences.
BWC is preparing to rebuild our data warehouse and replace our business intelligence reporting tools in conjunction with our implementation of Stone River’s PowerSuite application agency-wide. We are moving from a DB2/Hyperion data warehouse to an Oracle/Cognos data warehouse. We need a consultant who is a Cognos or data warehouse architect and who has set up an organization with Cognos before. This consultant should also be familiar with setting up security for Cognos (identifying the security levels and how to administer the security). This person will not write reports; but will help BWC determine how to set up Cognos with our Oracle data warehouse.
*BWC is planning a 1,500-query user implementation, with about 100 report developers.
*In the current data warehouse, BWC 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.
*BWC will rebuild about 4,500 existing reports in Cognos.
Candidate MUST have strong communication skills in addition to proven experience to perform the following duties:
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 BWC staff on these topics and provide on the job training and mentoring to them, both teaching BWC staff and coaching them as they do this work on their own.
*Make sure BWC 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.
*BWC expects the work of the consultant to be done on-site here in the William Green building.
*Consultant 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 BWC employees to do all of the following:
*Confirm BWC’s implemented architecture.
*Recommend how to provide strategy to migrate objects (models / reports / etc) from test to production.
*Design and construct the data abstraction layers to support reporting, including but not limited to cubes, data marts, data models, etc.
*Determine which Cognos tools will best support BWC’s business requirements.
*Set up and manage Cognos security at all levels.
*Assist with performance analysis and tuning.
*Assist with the development of a 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
*Three years of experience in Cognos 8 or 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.
*Prefer: 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
Interviews planned for Monday February 25th and Friday March 1, 2013.
(Please Note: If your candidate is not available to interview at this time, please don’t apply)
Skills:
Skill
Required / Desired
Amount
of Experience
Experience in Cognos 8 or higher
Required
3
Years
Cognos 10.x experience
Required
1
Years
Experience building Cognos cubes
Required
1
Years
Experience building a Cognos data warehouse that uses cubes, data marts, data models, and reports.
Required
2
Years
At least one complete Cognos implementation including, installing, configuring, and tuning Cognos architecture that is distributed over multiple ser
Required
Experience with a project migration from another data warehouse tool to Cognos
Required
Experience using Cognos with Oracle databases.
Required
Experience with the new features and functions of Cognos 10.2.
Required
Certification as IBM Certified Solution Expert - Cognos BI
Highly desired
Certification as IBM Certified Administrator - Cognos 10 BI
Highly desired
Certification as IBM Certified Developer - Cognos 10 BI Metadata Models
Highly desired
Certification as IBM Certified Developer - Cognos 10 BI OLAP Models
Highly desired
Certification as IBM Certified Designer - Cognos 10 BI Reports
Highly desired
Certification as IBM Certified Designer - Cognos 10 BI Multidimensional Reports
Highly desired
Basic Insurance Industry Knowledge-General Workers' Compensation Industry Knowledge
Nice to have