Job Description :
Position: Cognos Developer
Location: Oakland, CA
Duration: 3 Months w/ strong possibility of extension

The Cognos developer is responsible for support and maintenance and documentation of existing reports in the data warehouse, and administration of the reporting environments. Serve as Cognos administrator.
Maintain the existing reporting portfolio, including production support.
Installation, upgrade, configuration, and monitoring of the reporting environment. Maintain the ongoing operational stability of the environment and ensure all components are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery.
Administer the Cognos development, quality assurance, and production environments, including managing Cognos securities using LDAP, the Cognos Connection folder structure, deployment of content from development to production, and report scheduling and bursting. Apply thorough understanding of performance tuning for the Cognos Environment. Apply fixes, patches or upgrades. Handle planned and unplanned outages. Grant user access to the Cognos environment.
Create, enhance, and maintain Framework Manager models (relational and dimensional) which connect to a star schema DB2 warehouse database, including packages designed for report development and for ad hoc reports. Promote/publish the Framework Manager packages to the Cognos environment.
Collaborate with members of the ERMIS team, including Cognos developers, the BI functional lead, SDSC data center staff, system analyst and ETL developers to transition existing reporting operations from current vendor to in-house.
Document existing processes and reports. Participate in the project management estimation and tracking. Train other Cognos report developers.
Understand and apply industry practices, community standards and department/unit policies and procedures in depth.

Minimum five years of experience as a senior Cognos report developer.
Experience with multi-dimensional star schema and relational database management systems.
Must be able to come up to speed very quickly.
Ability and willingness to train other Cognos developers.
Expert level knowledge of Cognos Version 10.2 environment (including Framework Manager Solid background and experience with Cognos Windows Administration.
Experience with DB2, SQL, BI reporting tools.
Detailed understanding of a distributed Cognos systems architecture. Experience with LDAP providers. Experience with deploying and maintaining Cognos under Apache application servers.
A basic understanding of ETL development is also required.
Broad knowledge of the IT environment. Ability to follow guidelines and adhere to the established software development standards and conventions.
Ability to plan and organize technical work and deliverables. Ability to prioritize and multi-task across numerous work streams.
Self-motivated and independent. Able to work with minimum supervision and to work well with stakeholders and project staff. Strong interpersonal skills; ability to work on cross-functional teams.
Strong verbal and written communication skills.
Experience with enterprise risk management data is preferred.