Enterprise Data Reporting Specialist

SUMMARY :

The California Public Employees' Retirement System (CalPERS) Technology Business Management Division (TBMD) needs services from one contractor to provide analytical and programming support to develop, maintain and execute the Enterprise Data Reporting services. The services include maintenance and enhancement of the my CalPERS reporting system, Business Intelligence (BI) system, and other enterprise reporting systems as needed. The consultant will develop reports, framework packages, repository metamodel, and enhance my CalPERS and BI reporting solutions to meet the changing needs of business customers.

Roles and Responsibilities

Deliverable 1 : Design, develop, and deliver reports and dashboards supporting my CalPERS application users

• Meet with customers, gather requirements, business analysis, create report specification documents, design and develop SQL for reports, design and develop reports in Cognos and Power BI. Integrate external application to Cognos to trigger / run reports, integrate Cognos to batch processes to be able to run / create and save reports using Cognos SDK. Technical documentation, unit and user acceptance testing, security, and packaging of all reports and dashboards is required and will adhere to internal standards.

Deliverable 2 : Maintenance, Operations Support and Functional administration of Production Reporting systems

Deliverable 3 : Knowledge Transfer between the vendor and CalPERS staff