Data Technology Specialist

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.

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

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. (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.

• 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.

• Perform a variety of database functions.
• Identify,…