1 year contract in Sacramento for OBIEE Analyst.

W2 or 1099

US Citizens only

On location in Sacramento CA.

Project Scope/Deliverable Base Tasks

The scope of this project encompasses the following deliverable base tasks:

Deliverable 1:

BI Functional administration:

Functional administration of the BI dashboarding environments (accounts, roles, server maintenance coordination, promotion of code from one environment to another, etc.) in production and non- production servers. Maintenance of the existing data reporting inventory and Provide data and technology support necessary to enable CalPERS to meet BI related business objectives.

Deliverable 2:

Design and development (programming, testing, enhancements, and maintenance) of specialized BI software solutions for an advanced analysis of CalPERS business transactions. Evaluate existing dashboards and reports, identify issues, and recommend actions to resolve problems.

Deliverable 3:

Design and development of Business Intelligence reports and dashboards. The report and dashboard requests are received from the CalPERS business areas. Fulfillment includes requirement interpretation, working with the business requester to confirm requirements, design and development of the report or dashboards, testing and deployment of the report or dashboard to CalPERS business users.

Design and development of the BI semantic layer. The semantic layer is a complex component of each BI environment that translates:

• complex database table structures,
• relationships between database tables,
• data types (example: numbers, characters),
• grains (example: monthly, weekly, and daily data records),
• centralized business calculations (example: real time pension account balance calculation) and o data records into business-oriented data fields with business-friendly labels that are used to create reports, dashboards and analyses without the need for users to learn computer programming languages for the need to understand complex database tables.

Deliverable 4: Knowledge Transfer

On an ongoing basis, through the end of the contract, all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to state personnel. Knowledge transfer to State staff is part of each project when the projects are completed and released into maintenance mode.

Provide resume and available start date when applying.