Randstad Cognos Developer in Oakland, California
Wednesday, September 28, 2016
The Enterprise Risk Management Information System (ERMIS) data warehouse serves as the data repository for risk and controls related information from claims data, corporate data, human capital, and many other information sources.
Under the direction of the ERMIS Manager, and other members of the ITS Data Services team, the Cognos developer is responsible for support and maintenance and documentation of existing reports in the ERMIS data warehouse, and administration of the reporting environments. Serve as Cognos administrator.
This position is funded for three months with a strong possibility of extension. The position is located in Oakland, CA and requires full time on-site attendance.
Selected candidate will be required to pass a criminal history background check.
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.
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.