Job: Departmental Systems Analyst - Limited Term (Open)

This posting has expired and is no longer available.

Job Description

Overall Job Objective

Job Title:Departmental Systems Analyst - Limited Term (Open)
Closing Date/Time:Tue. 08/01/17 11:59 PM Pacific Time
Salary:$43.72 - $54.65 Hourly
$3,497.60 - $4,372.00 Biweekly
$7,578.13 - $9,472.67 Monthly
$90,937.60 - $113,672.00 Annually
Job Type:Full-Time
Location:Redwood City, California
NOTE: This recruitment schedule was amended on Thursday, July 27, 2017 from a continuous recruitment to closing. The Final Closing Date will be Tuesday, August 1, 2017.  

Please note: These positions have been

Note: This recruitment schedule was amended on June 27 to extend the Final Filing Date.  This recruitment has been changed to "Continuous."  Application screenings and panel interviews will be conducted on an ongoing basis, with the first round of screenings occurring on June 28 on applications received through June 27.  First round of panel interviews will follow as advertised.  Subsequent screenings and interviews will occur as needed.   If you are interested in this important career opportunity, please apply immediately.

This is a continuous recruitment which may close at any time. The final filing date will be posted five days in advance on this job announcement.
Apply immediately. This recruitment is open on a continuous basis and selections may be made at any time within the process.

The Controller's Office of the County of San Mateo is seeking well qualified candidates for the position of Departmental Systems Analyst.  There are currently two vacancies in the Information System Division of the Controller's Office.

In general, a Departmental Systems Analyst provides complex analytical support to the maintenance and/or modification of existing systems and to the development of new systems by serving as the liaison between system users and information technology staff, vendors and service providers.  In addition, a Departmental Systems Analyst:
  • Provides technical and analytical support and training to system users
  • Performs system administration functions to ensure security and effective operation
  • Develops and maintains a variety of automated files, records and databases
  • Prepares and distributes new procedures, training materials, and a variety of scheduled and ad hoc reports
  • Performs other related duties as required and/or assigned
The Departmental Systems Analyst must have a general knowledge of both departmental and/or program operations and information system capabilities, which enables effective interactions between technical and non-technical staff, the ability to explain the needs and requirements of each to the other, and the ability to participate in the development of systems that effectively support department and/or program operations.

For the current vacancies the Departmental Systems Analysts will provide complex analytical support for the adaptation for the reporting tool of County's financial accounting system to the newly incorporated BI Cognos reporting tool. Knowledge of reporting tool for the County's current financial accounting system and/or current or previous experience working with a reporting tool for a financial accounting system such as SAP Crystal Report or BI Cognos is critical to success in these positions. The current vacancies will also provide complex analytical support for the County ONESolution Financial Accounting System (OFAS) and the system upgrade. 

The ideal candidate will have:
  • Advanced technical skill to research, test and configure
  • Experience working with reporting tools such as BI Cognos or SAP Crystal Report
  • Demonstrated ability to improve a system's functionality and streamline process efficiency
  • Experience with technical system support for a large organization financial and payroll system
  • Knowledge of financial or payroll laws and regulations
  • Strong analytical skills to investigate system problems or issues, evaluate alternatives, and develop effective solutions
  • The ability to be creative and think "outside the box" to solve problems
In addition, the ideal candidate will:
  • Possess strong analytical skills
  • Have independent judgment
  • Work well under pressure and meet deadlines
  • Monitor and troubleshoot potential issues
  • Be detailed-oriented and organized
  • Maintain accurate data and configuration
  • Work effectively in a fast-paced environment
  • Have government experience
  • Possess strong written and oral communication skills
NOTE: The current vacancies are limited term, at-will positions. Limited Term Employees are assigned to assignments not to exceed three years. They receive medical and dental benefits, similar to regular employees, and a defined contribution retirement plan. The eligible list generated from this recruitment may be used to fill future extra-help, term, unclassified, and regular classified vacancies.
Current and regular San Mateo County Employees who are interested in this assignment must submit an application and compete in the recruitment process. If you are successful in the recruitment and are being considered for the assignment, HR will work directly with you and/or your department for options. Please note that there is no guarantee that you will be allowed by your department to rotate into this assignment nor are your departments obligated to allow you to take on this assignment. The salary range for this position is "as is" and non-negotiable.
 Examples Of Duties:
Duties may include, but are not limited to, the following:
  • Participate in the modification of existing systems and/or the implementation of new systems by developing, writing and disseminating procedures that utilize new or changed system applications; and by evaluating system deadlines, modifications in response to operational, program and/or regulatory changes
  • Receive requests for assistance related to the use of department and/or program systems and software applications; determine severity of problem and resolve or refer to appropriate personnel or vendor for resolution
  • Participate in a variety of system user and work groups to identify user needs and operational, programmatic and/or regulatory changes affecting application requirements and other related issues
  • Interact with vendors, outside agencies, auditors and other staff regarding requests for data or special reports
  • Provide or arrange for the training of staff on the information systems used by the department and/or program; requests ad hoc reports
  • Perform system administration functions including monitoring applications, adding and deleting users, modifying user profiles, re-setting passwords and file maintenance
  • Maintain a variety of departmental and/or program databases, files and records; queries and generates reports on a scheduled and ad hoc basis
  • Prepare and track requests to information technology staff, vendors and/or service providers for routine system changes and reports
  • Perform related duties as assigned


Knowledge of:
  • Principles, practices, policies, procedures, regulations and applicable state and federal laws pertinent to assigned operational and/or program area
  • Principles and practices used in the analysis and development of procedures and information systems associated with assigned operational and/or program area
  • Principles and practices of programmatic analysis and report preparation
  • Information systems and data processing concepts
  • Modern office practices
  • Job planning and prioritizing techniques
Skill/Ability to:
  • Provide technical and analytical support to users of department systems and applications
  • Communicate with department personnel to identify and translate information needs into system requirements
  • Communicate departmental information system needs to system providers for the design, development and/or enhancement of system applications
  • Evaluate the effectiveness of newly developed systems and/or applications
  • Develop and present comprehensive training materials
  • Analyze administrative and management problems, evaluate alternatives, reach sound conclusions and effectively implement changes
  • Prepare clear, concise and accurate documentation, instructions, correspondence and other written materials
  • Organize work, set priorities and meet critical deadlines
  • Maintain accurate records and files
  • Communicate effectively, orally and in writing, with both technical and non-technical personnel
  • Establish and maintain effective working relationships with those contacted in the course of the work
Education and Experience:
Any combination of education and experience that would likely provide the required knowledge, skills and abilities is qualifying. A typical way to qualify is:
  • Education: Equivalent to graduation from a four-year college with major coursework in public administration, business administration, information systems, or closely related field
  • Experience: Three years of responsible experience in a position that would provide knowledge of department-specific programs, processes and/or operations, including at least one year of experience in the planning, implementation, oversight and/or utilization of automated information systems and applications used to support departmental activities

Anyone may apply. A supplemental application form must be submitted in addition to our regular employment application form. The examination process will consist of two parts: an application screening and a panel interview.  The application screening is weighted as pass/fail and is based on the candidates' application and responses to the supplemental questions. Candidates who pass the application screening will be invited to a panel interview, weighted at 100%.

Depending on the number of applicants, an application appraisal of education and experience may be used in place of other examinations, or further evaluation of work experience may be conducted to group applicants by level of qualification. All applicants who meet the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination. All examinations will be given in San Mateo County, California, and applicants must participate at their own expense.

IMPORTANT: Applications for this position will only be accepted online. If you are currently on the County's website, you may click the "Apply Online" button above or below. If you are not on the County's website, please go to to apply.

Deadline for Applications: June 27, 2017 by 11:59 p.m.
Application Screening (Tentative): Week of June 27, 2017
Panel Interview (Tentative): July 12 and/or 13, 2017

As noted previously, this recruitment is now continuous.  Application screenings and panel interviews will occur on a regular basis as applications are received.  The first round of screening will occur on June 28, with interviews to follow on July 12, and/or July 13, 2017. 

These two positions could be filled at any time.  Please apply immediately if you are interested in this important career opportunity.

The County of San Mateo does not require job applicants to disclose conviction history information until after the applicant successfully completes all examination phases for the recruitment. All passing applicants will receive instructions by email only from Human Resources staff to complete and submit a conviction history questionnaire online within a specified deadline of two business days. Failure to do so within the time frame will disqualify you from the rest of the process.  Please visit to find out more information about the conviction history questionnaire so that you can prepare accordingly.

Note: Positions in criminal justice agencies currently required by law to pass background checks are exempted from this bill, and applicants may be required to submit conviction information at the time of application.
County of San Mateo is an Equal Opportunity Employer
Analyst: Lucy Fung (061317) (Departmental Systems Analyst – V233)

Career Sites by