Salary : $7,569.47 - $9,658.13 Monthly
Location : 1200 Concord Avenue Suite 300, Concord CA 94520, CA
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: CCR96
Department: Member Services
Opening Date: 07/10/2026
Closing Date: 7/24/2026 11:59 PM Pacific

Definition and Class Characteristics

Definition

Under direction, performs a variety of complex systems and data audit tasks within CCCERA's pension administration system (PAS); receives, reviews, audits, and posts all incoming data submitted by member agencies or entered into the system by CCCERA staff authorized to do so; reconciles a variety of demographic and financial transaction data within the systems; and performs related duties as assigned.

Supervision Received and Exercised

Receives direction from the Member Services Supervisor and/or Member Services Manager. Exercises no supervision over staff.

Class Characteristics

This class is distinguished from the Member Services Specialist and the Retirement Counselor/Senior Retirement Counselor classes by the performance of the full range of systems technical duties which include responsibility for the timely completion and transfer of data, and quality control with respect to the integrity of the data to be used by CCCERA and its member agencies.
Examples of Typical Job Functions

(Illustrative Only)
Management reserves the right to make reasonable accommodations so that qualified employees can perform the essential functions of the job.

• Receives files from member agencies for import into CCCERA's PAS; adjusts raw data files to ensure proper format; audit member submissions relative to data in the PAS; troubleshoots files to identify and resolve data errors; interfaces with staff in member agencies to verify and correct electronic data files; uploads member files to the PAS.
• Identifies factors contributing to recurring data errors; participates in researching errors to enhance and improve data flow, and to test and implement solutions which result in improved data accuracy.
• Performs system monetary validation and transfers; verifies monies received for purchases against calculated costs, and posts the receivable amount to the PAS; transfers retiree contributions; validates interest postings to employee accounts; transfers funds from purchase contracts and reciprocity transactions.
• Audits posted member accounts to ensure accuracy by reviewing and reconciling multiple data points between member files and the PAS records including, but not limited to, member demographics, earnings and wages, salary and deduction totals, contribution rates, and related transactions; balances imported files and adjusts data as needed; works with the Accounting Department to reconcile data posted into the PAS with the payments received.
• Maintains the member data within the PAS by ensuring that all information in the system is verified and entered in an accurate manner; researches and verifies information including, but not limited to, service credit discrepancies, contribution status, monetary corrections, and account adjustments.
• Collaborates with information technology staff on system changes, maintenance and upgrades, and the resolution of system errors; participates in project meetings; undertakes system testing within the Member Services Department.
• Audits, updates, and generates data for use in the preparation of CCCERA fiscal and operational statements, forms, and reports.
• Performs data entry for a variety of tasks related to member account maintenance.
• Performs related duties as assigned.

Qualifications
Knowledge of:

• Methods and techniques of importing and converting files to required format.
• Methods and techniques of auditing and reconciling system files and accounts.
• Operational characteristics of pension system databases.
• Principles and practices of database maintenance and testing.
• Intermediate to advanced level knowledge of Excel spreadsheet applications.
• Methods and techniques of troubleshooting data files, including query reports.
• Methods and techniques of data entry and retrieval.
• Accepted principles, practices, purpose, and operations of an Employees' Retirement System.
• Principles and practices of effective customer service.
• Principles and practices of maintaining confidential member records.
• Mathematical techniques.
• Modern office practices, methods, and computer equipment and applications related to the work performed.
• English usage, grammar, spelling, vocabulary, and punctuation.

Ability to:

• Perform a variety of database functions.
• Identify, troubleshoot, and correct data errors.
• Review, audit, and validate or correct system data.
• Perform accurate mathematical calculations.
• Organize own work, set priorities and meet critical deadlines.
• Learn and apply the applicable rules, regulations, policies, and procedures of the County Employees' Retirement Act of 1937 relevant to work performed.
• Maintain confidentiality.
• Operate modern office equipment including computers and specialized software applications relevant to work performed.
• Use English effectively to communicate in person, over the telephone, and in writing.
• Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.
• Demonstrate strict confidentiality, professionalism, integrity, and compliance with applicable laws and regulations at all times.

Education and Experience:

Any combination of training and experience that would provide the required knowledge, skills, and abilities is qualifying. A typical way to obtain the required qualifications would be:
Equivalent to the completion of the twelfth (12th) grade and two (2) years of experience as a Member Services Specialist; or four (4) years of increasingly responsible technical experience researching and reconciling records, performing calculations, accounting support, transaction processing, and database management.
Licenses and Certifications:

None.
Physical Demands
Must possess mobility to work in a standard office setting and use standard office equipment, including a computer; to read printed materials and a computer screen; and hearing and speech to communicate in person and over the telephone. This is primarily a sedentary office classification although standing in work areas and walking between work areas may be required. Finger dexterity is needed to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard office equipment. Positions in this classification occasionally bend, stoop, kneel, reach, push, and pull drawers open and closed to retrieve and file information. Employees must possess the ability to lift, carry, push, and pull materials and objects up to 25 pounds with use of proper equipment.
Environmental Elements
Employees work in an office environment with moderate noise levels, controlled temperature conditions, and no direct exposure to hazardous physical substances. Employees may interact with upset staff and/or public and private representatives in interpreting and enforcing departmental policies and procedures.

Disaster Service Worker:

All Contra Costa County Employees' Retirement Association (CCCERA) employees are designated Disaster Service Workers through state and local law. Employment with CCCERA requires the affirmation of a loyalty oath to this effect. Employees are required to return to work as ordered in the event of an emergency, therefore, employees must be residing within 200 miles of Concord, CA on scheduled work days.

Additional Information

Preference will be granted to applicants with experience in the County Employees' Retirement Law of 1937 (CERL or 1937 Act).

This position has 6 steps in the salary range. CCCERA generally starts new hires at step 1, or step 2 based on qualifications. The salary increase from step 1 to step 2 is assessed at 6 months and annually thereafter.

After an initial training period, CCCERA allows employees to request to work remotely up to 2 days per week. Everyone is required to work in the office on Tuesdays.
EMPLOYEE BENEFITS

BENEFITS: CCCERA offers a wide range of competitive benefit options to meet the needs of our diverse workforce and their families. These benefits include but are not limited to:

For your Health & Welfare Benefits:

• Medical - through CalPERS
• Dental
• Vision
• Basic Life Insurance
• Supplemental Life Insurance (with optional dependent coverage)
• Health Care Spending Account (Flexible Savings Account for medical expenses)
• Dependent Care Assistance Program
• Employee Assistance Program

For your Financial Future:

• Short-term Disability Insurance
• Long-term Disability Insurance
• Retirement Plan - (Defined Benefit Pension Plan and Social Security)
• Deferred Compensation Plan

For your Work/Life Balance:

• Paid Holidays
• Personal Holiday Accrual
• Vacation Accrual
• Sick Leave Accrual

This information is intended to provide a general summary of benefits available to employees, is subject to change, and is not legally binding. Eligibility is determined by CCCERA and offerings may vary by Memoranda of Understanding (MOU) between CCCERA and the employee organization/union representing the employee's job classification.

To find more information on the benefits provided to CCCERA staff please read
01

The purpose of this supplemental questionnaire is to provide applicants the opportunity to elaborate on their qualifications for DATA TECHNOLOGY SPECIALIST. Your supplemental questionnaire responses will be evaluated and may be used to determine your score and rank on the employment list. A completed supplemental questionnaire is required for this position and any applications received without a completed supplemental questionnaire will be considered incomplete and will be disqualified. Although you may submit a resume or additional information, such items may not be substituted for the information requested in this questionnaire. I have read and understand the above instructions:

• Yes
• No

02

Please describe any experience you have with calculating retirement contributions, adjustments and reciprocity.
03

Please describe any experience you have with a pension administration software system or similar software system (e.g. systems related to the management of government records, payroll, or health care).
04

Please describe any experience you have with importing and processing data files, reconciling and auditing information and resolving errors.
05

Provide the amount of years you have completed tasks related to the maintenance of customer or employee records and describe this experience.
Required Question