Overview
Skills
Job Details
| TITLE OF POSITION | Data Engineering and myCalPERS Support (Project Role: Sr. Technical Specialist) |
| AGENCY NAME | The California Public Employees' Retirement System (CalPERS) TMBD |
| PERIOD OF PERFORMANCE | 1 Year |
| RTR | Required |
| REFERENCES | Three |
| INTERVIEW | Virtual or Client location (As client's Discretion) |
| PLACE OF PERFORMANCE | Remote |
| SCOPE OF WORK | The Enterprise Analytics and Data Services team seeks a senior consultant with deep expertise in Oracle SQL and PL/SQL development to manage and execute high-volume, time-sensitive data requests across pension, health insurance, customer service, finance, and risk domains. The ideal candidate must be skilled in designing complex queries, analytical models, and data solutions aligned with business and legal requirements. Design, develop, and optimize complex SQL and PL/SQL programs for data extraction, transformation, and validation. Support over 850+ annual data requests, including Public Records Act inquiries, court orders, audits, and legal requests. Build and maintain Pension-specific data marts to support recurring pension data demands and public-facing reports like the ACFR. Work under strict SLAs (10-day turnaround) for high-priority and legally bound data delivery. Ensure alignment with change management, BI development practices, and SDLC standards. Collaborate with program areas and legal teams to fulfill urgent, ad hoc enterprise data needs. Must Have: Advanced Oracle SQL & PL/SQL development experience. Proven ability to work with large-scale data operations and perform ad hoc analytical data services. Strong understanding of public pension systems, health insurance processes, and financial data workflows. Hands-on experience with data marts, enterprise reporting, and data governance. Familiarity with CalPERS or similar public agency environments is highly desirable. Ability to manage tight timelines and multiple concurrent priorities in a production-like support environment. The scope of this project encompasses the following tasks: |
| *Mandatory Experience | |
| Please see attachment A- Evaluation Criteria- Separately attached (Candidate needs to fill out the form) | |
| Role and Responsibilities | |
| Deliverable 1: Fulfill high-volume, one-time, ad hoc requests for business data requested by CalPERS business divisions. Monthly fulfillment of business data requests is expected to consist of fulfilling 70-80 requests per month. This estimate is based on counts from 2024 and is expected to be representative of the workload in the 2025/2026 fiscal year. Most of the business data requests use SQL queries to query records from the myCalPERS database and/or the CalPERS data warehouse. The myCalPERS data model includes 2,000+ tables that contain business transactions and related information. The CalPERS data warehouse model consists of 30+ fact tables and 100+ dimension tables. Business data requests have a 10-day service level agreement that the vendor will be bound to. Deliverable 2: Design and deliver a set of data marts that will support myCalPERS analytics. Data marts will be handled in phases. Phase I is the design phase. CalPERS and the vendor will agree to the design and scope of the data marts. Phase II is the development phase. The vendor will develop data models for the data marts and the code needed to refresh the data in the data marts based on Phase I. Phase III is the review and acceptance phase where the data in the data marts is validated and the refresh code is integrated into the existing data platform's ETL batch window. Deliverable 3: Knowledge Transfer Knowledge transfer between the vendor and CalPERS will be facilitated through an existing process called Data Request Centralization where (1) requests for business data are submitted via ServiceNow, (2) requests are routed to the fulfiller, (3) request fulfillment artifacts such as technical documents and SQL scripts are added to the Data Request Library and (4) data is transferred securely to the requestor via a Data Locker. Any data issues that are identified during fulfillment of business data requests are reported to CalPERS and recorded in the Data Request Library. |
EVALUATION CRITERIA FOR BEST VALUE AWARD
| Qualifications
| Writeup By Consultant |
| 1. At least five (5) years of experience supporting the design and development of analytical models, tools, or programs using Oracle tools
|
|
| 2. At least five (5) years of experience with interpreting requirements and developing complex PL/SQL and SQL
|
|
| 3. Proven ability to reason logically and creatively and use a variety of analytical and research techniques to solve complex problems; visualize data sets; analyze situations and propose an effective course of action; analyze data; identify the need for and provide creative thinking related to complex problems, develop and evaluate alternatives.
|
|
| 4. Proven ability to communicate effectively both verbally and in writing with a variety of audience types using different mechanisms including informal updates, formal presentations, business case documents, and other analytical and technical documents.
|
|
| 5. At least five (5) years of experience in some or all areas of Pension, Health Insurance, Customer Service, Finance or Risk
|
|