Cognos Data Reporting Specialist

Description

Job Description Research, analyze, design and implement appropriate Cognos data reporting solutions for business users based on any outstanding/future requestsEnhance and maintain my CalPERS Production Reporting systemDesign and develop reports using CognosIntegrate external Application to Cognos to trigger/run reportsIntegrate Cognos to batch processes to be able to run/create and save reports using Cognos SDKMaintain the existing package(s) and suggest for ways of improving the performance and maintainabilityPerformance tuning of Cognos BI applications both on reports, framework side and server/infrastructure aspectsMaintain existing Framework Manager packages and build new packages as per reporting needsUpdate design and technical specification documents for ongoing report modificationsMaintain knowledge of CalPERS data models and data dictionary for the purpose of maintaining Cognos packages and enhancing user awareness of business data;Create and update Report Data column mapping to database tables and columns documentationMaintain security of CalPERS data assets through the administration of Cognos featuresMaintain proper security of Cognos Objects (Reports, Folders and Packages) within Cognos and implement data level security on reports to restrict data visible to usersEducate and provide knowledge transfer to report developers and business users on Cognos tool and best practicesWork with Business Intelligence/Data Warehouse/OBIEE developers to validate if it caters to current report needs and build/assist in redesigning the reports to source from warehouseWork with Application team to identify performance bottlenecks and suggest improvement plansDesign, develop and deliver data extracts from CalPERS databases and data warehousesWork with MiddleTier team and manage software upgrades, patches and backup as neededWork with product vendors to provide application support and bug fixes as neededProvide weekly accomplishment/status report to management every weekAttend project and team meetings as requested.Desired QualificationAt least 5 years of applied experience developing reports using CognosAt least 5 years of applied experience using Cognos Report Studio and Framework ManagerAt least 3 years of applied experience developing data reporting packages in Cognos 10 or greaterAt least 3 years of applied experience with Cognos functional administrationAt least 1 year of applied experience using Cognos 11At least 5 years of applied experience with SQL and SQLtuning;At least 3 years of applied experience with Oracle 11gAt least 3 years of applied experience developing JavaScript for reportsAt least 5 years of CalPERS, or similar retirement systems, business knowledge