Senior Data Modeler

Anticipated Interview Dates: Virtual interviews are anticipated to be held between May 20th and May 31st, 2024.

Telework Information: This position is eligible for hybrid work schedule, with up to two days of remote work and three days or more onsite, per week.

Are you passionate about data quality and have a keen eye for detail, along with exceptional problem-solving and communication skills? Do you want to work in a collaborative and fast-paced environment where you can make a difference with your skills and expertise? If so, we have an exciting opportunity for you!

The Technology Business Management Division (TBMD) at the California Public Employees' Retirement System (CalPERS) is seeking a skilled and motivated Information Technology Specialist II (IT Spec II), Senior Data Modeler to join our team and play a pivotal role in designing, optimizing, and maintaining our data architecture to ensure accuracy, efficiency, and scalability. The Senior Data Modeler will work with stakeholders both in Information Technology Services Branch (ITSB) and in the business areas.

As a Senior Data Modeler, you will develop conceptual, clear physical data models that represent the organization's data requirements and business processes. You will collaborate with database administrators, developers, and stakeholders to implement and optimize database solutions based on the defined models. You will ensure the accuracy, completeness, and consistency of data by implementing data validation rules, integrity constraints, and quality assurance processes. This role requires a keen eye for data integrity, excellent technical skills, and a passion for turning data into actionable insights.

How did you hear about this position? Tell us in this brief survey .
You will find additional information about the job in the Duty Statement .

Minimum Requirements You will find the Minimum Requirements in the Class Specification.
INFORMATION TECHNOLOGY SPECIALIST II
Additional Documents Job Application Package Checklist
Duty Statement

Position Details Job Code #:
JC-427910

Position #(s):
********

Working Title:
Senior Data Modeler

Classification:
INFORMATION TECHNOLOGY SPECIALIST II $8,130.00 - $10,893.00 A

# of Positions:
1

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Department Information The California Public Employees' Retirement System (CalPERS) is the nation's largest public pension fund, providing retirement and health benefits to public employees, retirees, and their families. Headquartered in downtown Sacramento, we are a destination employer with an international reputation for leadership and innovation. At CalPERS, we're committed to people - the people we serve, our team members, and the larger community around us. CalPERS is situated near the Napa Valley, San Francisco, Lake Tahoe, and other desirable destinations, and we offer competitive benefit packages, compensation, and opportunities for advancement.

If you are interested in becoming part of a diverse and inclusive workforce where talent, experience, and expertise are valued, CalPERS invites you to apply for this employment opportunity. To find out more about our Diversity, Equity, and Inclusion efforts, visit our website !

To take a look at CalPERS as a destination employer, view this YouTube video .

Special Requirements Statement of Qualifications

Please provide a Statement of Qualifications (SOQ) for the hiring manager's review. Applications received without an SOQ or those that do not respond to the specific questions below will not be considered.

The SOQ must be typed, titled "Statement of Qualifications", and each response must be numbered and list all relevant experience, education, and training, including places of employment, dates, and duties performed. The SOQ must not exceed two pages in length and must not have font smaller than 11 point. Please describe how your experience and/or education makes you a good fit for this Senior Data Modeler position. In your response, please also describe your experience with Structured Query Language (SQL).
Please describe the steps you've used to ensure the quality and integrity of data within an application or system you've worked with.

Minimum Qualifications

All experience and education relating to the Minimum Qualifications (MQs) listed on the Classification Specification should be included in your application package to clearly demonstrate how you meet the MQs for this position. If you are using education to meet MQs, please include your transcripts with your application package. If you have a degree from outside of the United States, you must submit an evaluation of this degree to determine the US equivalency. If you need an evaluation, you can visit the National Association of Credential Evaluation Services (NACES) website to find organizations that provide these services. The Classification Specification is located on this Job Posting under "Minimum Requirements."

Please Note: You may need to pass an examination to establish list eligibility prior to a final offer of employment. To find and take an exam, visit CalHR's CalCareers website .

Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.
Final Filing Date: 4/28/2024
Who May Apply
Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply
Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Public Employees Retirement System
Attn: JC-427910/SL
Human Resources Division, Recruitment
P. O. Box 942718
Sacramento , CA ********

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Public Employees Retirement System
HRSD, SSU JC-427910/SL
400 Q Street, Lincoln Plaza North
1st floor drop box by security desk
Sacramento , CA 95811

08:00 AM - 05:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job: Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
Resume is optional. It may be included, but is not required.
Statement of Qualifications - In addition to completing your online job application, you must provide a Statement of Qualifications (SOQ) for the hiring manager's review. Please see the Special Requirements section for instructions and questions for the SOQ. Applications received without an SOQ will not be considered.
Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate: Five years of experience with data modeling, database design, and database development, with a proven track record of designing and implementing complex data models in enterprise environments.
Proficient in using the Erwin Data Modeler tool.
Adept in Structured Query Language (SQL) for data manipulation and query optimization.
Ability to evaluate complex datasets, identify patterns and trends, and derive actionable insights to inform data modeling decisions and business strategies.
Excellent verbal and written communication skills with the ability to collaborate with cross-functional teams, articulate technical concepts to non-technical stakeholders, and facilitate productive discussions around data modeling requirements and solutions.
Willingness to stay updated with emerging and technologies, trends, and best practices in data modeling, database management, and data analytics. Adaptability to evolving business needs and technological advancements is essential.

Benefits CalPERS team members are eligible for a number of benefits. Health benefits and leave programs are available for most team members. Benefit eligibility may depend on length of service and collective bargaining agreements.

Some added benefits CalPERS offers include: Alternate Work Schedules
Flexible Work Hours
Onsite childcare facility
Onsite fitness center
Onsite café and nearby restaurants
Free onsite parking available Mondays and Fridays, subject to change
Free offsite parking available with shuttle service Tuesdays, Wednesdays and Thursdays
For more details about employee benefits, visit the California Department of Human Resources website.

Contact Information
The Human Resources Contact is available to answer questions regarding the position or application process.
Human Resources Contact:
HRSD, Selection Services Unit
(916) 795-2444
********

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.
EEO Contact:
CalPERS EEO
(916) 795-3675
********
California Relay Service: ******** (TTY), ******** (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Additional Information
Live Scan
Candidates not currently employed at CalPERS are required to submit to a criminal history review process utilizing Live Scan fingerprinting.

CalPERS Disclosure Requirements
If employed, you may be subject to rules imposed by Personal Trading Regulations and Conflict of Interest Code that apply to CalPERS team members, which require disclosure of certain investment information and use of a designated trading platform for securities transactions, as well as filing a Statement of Economic Interest (Form 700)

Sponsorship
This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for a visa sponsorship now or in the future.

Please do not include any confidential information on any documents in your application package. Confidential information that should be excluded or removed from these documents include, but is not limited to, your social security number, date of birth, marital status, personal photos, a copy of your driver's license, equal employment opportunity data, examination scores, and LEAP status.

Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.