Job Title: Data Engineering and my|CalPERS Support - Data Consultant/Expert
Location: 400 Q Street, Sacramento, CA
Duration: 12+ Months
Job Description: Project Scope/Tasks
The engagement requires services to provide the following for the Enterprise Analytics and Data Services team: a consultant proficient in the design and development of Oracle SQL.
The team requires a consultant proficient in the design and development of Oracle SQL, PL/SQL, analytical models, tools, and programs. This consultant must have advanced experience interpreting business data requirements and developing complex SQL queries and PL/SQL programs, with experience in Pension, Health Insurance, Customer Service, Finance, and/or Risk. This includes a strong understanding and experience with information technology, business intelligence development, change management best practices, project management, and system development lifecycle fundamentals.
To quantify the need, the Data Engineering team fulfilled over 857 business data requests in 2025. This volume is expected to continue in 2026. Many requests are time-sensitive and must be delivered within a 10-day service level agreement window or sooner. In addition, each month includes many high-priority business data requests. Not fulfilling these requests within the SLA is a risk because of potential legal liability and business/operational impact. These services consist of ad hoc requests that do not fit into regular project and application support activities.
Scope of the project encompasses the following tasks:
Deliverable 1:
Fulfill high-volume, one-time, ad hoc requests for business data requested by various business divisions. Monthly fulfillment of business data requests is expected to consist of 70 80 requests per month. Most requests use SQL queries to query records from the primary database and/or the data warehouse. The database model includes 2,000+ tables that contain business transactions and related information. The data warehouse model consists of 30+ fact tables and 100+ dimension tables. Business data requests have a 10-day service level agreement.
Deliverable 2:
Design and deliver a set of data marts that will support analytics. Data marts will be handled in phases:
- Phase I: Design phase, where scope and design are agreed upon.
- Phase II: Development phase, where data models and refresh code are developed based on Phase I.
- Phase III: Review and acceptance phase, where data in the marts is validated and refresh code is integrated into the existing ETL batch window.
Deliverable 3: Knowledge Transfer
Knowledge transfer will be facilitated through an existing process called Data Request Centralization:
- Requests for business data are submitted via ServiceNow.
- Requests are routed to the fulfiller.
- Request fulfillment artifacts, such as technical documents and SQL scripts, are added to the Data Request Library.
- Data is transferred securely to the requestor via a Data Locker.
Any data issues identified during fulfillment are reported and recorded in the Data Request Library.
Never miss an opportunity! Create an alert based on the job you applied for.
