Rate Card Title: Product Specialist 5
The State recognizes that some aspects of the role, responsibilities and experience requirements are beyond the typical PS5. Considering the unique needs for this position, candidates exceeding this rate will not necessarily be excluded from consideration.
Interview Process: First round 15 minute phone screen. 2nd Round mandatory on site interview. Resumes will be sent to Manager on Friday March 25th
Position Description:
Expert Cognos Resource. 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.
Additional Information Updated
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
• 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 BWC'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 BWC’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
