Skip to main content
Menu

Department Applications Analyst III

Human Services Agency- Open Competitive

Recruitment #0718-RI1203-01

Introduction

Calling all web and design developers! Do you possess high level skills in database design, application development, web design and reporting?  Look no further than this exciting opportunity as a Department Applications Analyst III in the Human Services Agency with San Joaquin County.

Department:    Human Services Agency- Information Systems Unit
Location:        102 S. San Joaquin Street, Stockton, CA 95202
Work Schedule:  Days
Department Websitehttp://www.sjchsa.org/

This examination is being given to fill one vacancy with the Information Systems Unit in the Human Services Agency and to establish an eligible list to fill future vacancies. Resumes will not be accepted in lieu of an application. A completed application must be postmarked or received online by the final filing deadline.

Pre-Employment Drug Screening:  Potential new hires into this classification are required to successfully pass a pre-employment drug screen as a condition of employment.  Final appointment cannot be made unless the eligible has passed the drug screen.  The County pays for the initial drug screen.

NOTE: All correspondences relating to this recruitment will be delivered via e-mail. The e-mail account used will be the one provided on your employment application during time of submittal. Please be sure to check your e-mail often for updates. If you do not have an e-mail account on file, Human Resources will send you correspondences via US Mail.

TYPICAL DUTIES

  • Provides professional advanced journey level support in the analysis, design, development, programming, testing, implementation and maintenance of applications across multiple platforms and technologies.
  • Designs data and application structures using appropriate design tools; analyzes current systems to determine methods of integrating new applications into department systems operating environments; designs data structure and application interface; designs on-line screens, maps, reports, forms, menus, and input/output records; develops data flow diagrams and other systems documentation to create application specifications; creates various reports, charts and other materials from multiple layers of data.
  • Develops optimum software configurations to achieve application functional goals; locates, reviews, re-formats and downloads existing system data; tests and de-bugs application; determines whether new application meets the client's business and technology requirements; recommends changes as needed.
  • Evaluates and tests new or enhanced applications; installs or upgrades application software and hardware; troubleshoots hardware, software and database related problems; performs applications testing and documentation duties.
  • Performs complex applications programming duties; ensures data integrity and program structure and reliability are maintained.
  • Prepares specifications and justification for new and enhanced application modifications; coordinates with software vendors to ensure quality and completeness of final product.
  • As assigned, provides highly technical support on applications development projects; analyzes business and functional requirements for new or enhanced applications; meets with users and management staff to ensure complete understanding of department requirements; analyzes current manual or computerized processes; analyzes inter-relationship between new tasks and existing applications; researches internal and external available resources; develops and presents cost-benefit analyses; makes recommendations on applications solutions; performs quality assurance duties; reviews new applications for compliance with applicable quality assurance standards.
  • Installs, maintains, supports and upgrades existing applications; analyzes functional and business requirements for new or enhanced applications design and development; consults and coordinates with users, management staff and vendors to solve complex application problems; determines requirements and tools necessary to complete application systems enhancements.
  • Maintains security and client access to assigned applications; grants and/or revokes user access; ensures compliance with department and mandated data security policies and procedures.
  • Writes documentation on new and enhanced application description and functional capabilities; prepares and updates user materials and procedures manuals.
  • Coordinates and conducts user training education and discussion sessions; recommends proper use and functionality of application; participates in the creation of new courses and classes; evaluates training courses to ensure they are effective.
  • As assigned, may exercise direct or technical and functional supervision over lower level staff; assists in selecting, training, motivating and evaluating assigned staff; provides or coordinates staff training; works with employees to correct deficiencies.
  • Attends and participates in professional group meetings; stays abreast of new trends and innovations in the field of information technology.
  • MINIMUM QUALIFICATIONS

    Note:  Supplemental application must be submitted with employment application.

     

    *On June 13, 2018 the Civil Service Commission approved the following selective recruitment requirements.

     

    Education:  Graduation from an accredited four-year college or university with major course work in computer science, information systems, mathematics, business administration or a related field.

     

    Experience: Two years of increasingly responsible professional analytical computer experience in the following areas:

    • Microsoft SQL Server and TSQL
    • Systems analysis and design
    • Intranet development and maintenance
    • Reporting services
    • Interfaces/integration of in-house to third-party systems
    • HTML/CSS
    • JavaScript 

    Substitution #1:  Possession of an approved information systems technology certificate, or completion of an approved information systems training course may substitute for part or all of the required education.  A list of approved certificates and/or courses shall be maintained within the Human Resources Department.

     

    Substitution #2:  Additional qualifying experience may substitute for the above required education on a year-for-year basis to a maximum of two years. 

     

    KNOWLEDGE

    Operations, services and activities of information systems programs; advanced principles and practices of applications development, programming and installation; advanced principles and practices of computer science and information systems; advanced methods and techniques of installing, configuring and troubleshooting applications, hardware, software and databases; principles and practices of quality assurance; principles and practices of system security and client access to assigned applications; methods and techniques of using application design and development tools; operational characteristics of multiple operating system environments; a variety of complex application programming languages; principles and practices of structured programming, analysis and design; operational characteristics of a variety of computer systems, networks and associated hardware, software, and databases; database principles and concepts; methods and techniques of developing and writing technical documentation; principles and practices of customer service; pertinent Federal, State and local codes, laws and regulations.

    ABILITY

    Provide advanced journey level support in the design, development and maintenance of department applications; independently perform complex applications analysis and programming duties; analyze and resolve complex application problems using logical and methodical processes; recommend, install, troubleshoot and upgrade applications; integrate multiple data sets and designs into individual applications; design training materials and conduct training programs; assess and analyze department technology resources and needs; design software to meet client needs; create and develop technical manuals and documentation; create various reports, charts and materials; operate a variety of computer systems and equipment; learn principles and practices of relational database management; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work.

    PHYSICAL/MENTAL REQUIREMENTS

    Mobility-Frequent use of data entry devices; frequent sitting, standing or walking for long periods; occasional pushing/pulling, bending, squatting and crawling; driving; Lifting-Frequently 5-30 pounds; occasionally 70 pounds or less; Vision-Constant use of good overall vision; frequent reading/close-up work; occasional color, depth and peripheral vision; Dexterity-Frequent repetitive motion; frequent writing; frequent grasping, holding, reaching; Hearing/Talking-Frequent talking/hearing in person and on the telephone; Emotional/Psychological-Frequent decision making and concentration; frequent public contact; occasional working alone, working nights and traveling; Environmental-Frequent exposure to noise.

    BENEFITS

    Employees hired into this classification are members of a bargaining unit which is represented by SEIU Local 1021

    Health Insurance:  San Joaquin County provides employees with a choice of three health plans:  a Kaiser Plan, a Select Plan, and a Premier Plan.  Employees pay a portion of the cost of the premium. Dependent coverage is also available. 

    Dental Insurance:  The County provides employees with a choice of two dental plans:  Delta Dental and United Health Care-Select Managed Care Direct Compensation Plan.  There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense.

    Vision Insurance:  The County provides vision coverage through Vision Service Plan (VSP).  There is no cost for employee only coverage; dependent coverage is available at the employee’s expense.

    For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Employee Benefits. 

    Life Insurance:  The County provides eligible employees with life insurance coverage as follows: 

     1 but less than 3 years of continuous service:                   $1,000
     3 but less than 5 years of continuous service:                   $3,000
     5 but less than 10 years of continuous service:                 $5,000
    10 years of continuous service or more:                           $10,000
     

    Employee may purchase additional term life insurance at the group rate.

    125 Flexible Benefits Plan:  This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan (Health Flexible Spending Account $2550 annual limit with a $500 carry over); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit). 

    Retirement Plan:  Employees of the County are covered by the County Retirement Law of 1937.  Please visit the San Joaquin County Employees’ Retirement Association (SJCERA) at www.sjcera.org for more information.  NOTE:  If you are receiving a retirement allowance from another California county covered by the County Employees’ Retirement Act of 1937 or from any governmental agency covered by the California Public Employees’ Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance.

    Deferred Compensation:  The County maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $18,000 or 100% of your includible compensation, whichever is less.  Individuals age 50 or older may contribute to their plan, up to $24,000. The Roth IRA (after tax) is also now available.

    Vacation:  Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years.

    Holidays Effective July 1, 2017, all civil service status employees earn 14 paid holidays each year.  Please see the appopriate MOU for details regarding holidays, accruals, use, and cashability of accrued time.

    Sick Leave:  12 working days of sick leave annually with unlimited accumulation.  Sick leave incentive:  An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one- half of the cumulative amount that the employee is eligible to accrue.  The employee must also be on payroll during the entire calendar year.

    Bereavement Leave3 days of paid leave for the death of an immediate family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child.

    Merit Salary Increase:  New employees will receive the starting salary, which is the first step of the salary range.  After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step.

    Job Sharing:  Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources.

    Educational Reimbursement Program:  Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year.  Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year.

    Parking Supplemental Downtown Stockton:  The County contributes up to $17 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area.

    School Activities:  Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities.

    Selection Procedures

    Applicants who meet the minimum qualifications will go through the following examination process:

    • Written Exam: The civil service written exam is a multiple choice format.  If the written exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list.
       
    • Oral Exam:   The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise.   The oral exam selection process is not a hiring interview.   A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list.  Top candidates from the eligible list are referred for hiring interviews.  If the oral exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. 
       
    • Written & Oral Exam:  If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement.  Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list.
       
    • Rate-out:  A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. 

     Note:  The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points.

    Testing Accommodation:  Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date.   

    Veteran’s Points:  Eligible veterans, unmarried widows and widowers of veterans of the United States Armed Forces who have been honorably discharged and who have served during wartime shall be given veteran’s points in initial appointment to County service.  Eligible veterans receive 5 points and eligible disabled veterans receive 10 points. Disabled veterans must submit a recent award letter stating a 10% service connected disability issued by the United States Veterans Administration.  Note:  A copy of your DD214 showing the discharge type must be received in the Human Resources by the date of the examination.

    Acceptable wartime service dates:

    • September 16, 1940 to December 31, 1946

    • June 27, 1950 to January 31, 1955

    • August 5, 1964 to May 7, 1975

    • Persian Gulf War, August 2, 1990, through a date to be set by law or Presidential Proclamation.

    Eligible Lists:   Candidates who pass the examination will be placed on an eligible list for that classification.  Eligible lists are effective for one year, but may be extended up to two additional years by the Civil Service Commission.

    Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods.

    • Rule of the Rank: The top three ranks will be referred for hiring interviews.  If there are less than 5 names in the top three ranks the next rank is referred.  This applies only to open competitive recruitments.
    • Rule of Five:  The top five names will be referred for hiring interviews.  This applies only to department or countywide promotional examination.

    Physical Exam:  Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities.

    Pre-Employment Drug Screening Exam:  Some classifications require a new employee successfully pass a pre-employment drug screen as a condition of employment.  Final appointment cannot be made until the eligible has passed the drug screen.  The County pays for the initial drug screen.

    Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when;

    • They are related to the Appointing Authority or

    • The employment would result in one of them supervising the work of the other.

    Department Head may establish additional limitations on the hiring of relatives by departmental rule.

    Proof of Eligibility:  If you are offered a job you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S.

     

    HOW TO APPLY

    Apply Online:       

    www.sjgov.org/department/hr

    By mail or in person:  

    San Joaquin County Human Resources

    44 N. San Joaquin Street Suite 330

    Stockton, CA 95202                                  

     

    Office hours:               
    Monday – Friday 8:00 am to 5:00 pm; excluding holidays.

    Phone:  (209) 468-3370 

     

    Job Line:

    For current employment opportunities please call our 24-hour job line at (209) 468-3377. 

    When a final filing date is indicated, applications must be filed with the Human Resources Division before 5:00 p.m. or postmarked by the final filing date. Resumes will not be accepted in lieu of an application. Applications sent through county inter-office mail, which are not received by the final filing date, will not be accepted. (The County assumes no responsibility for mailed applications which are not received by the Human Resources Division).  

    San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees.

    Equal Opportunity Employer:  San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation.  For more information go to
    www.sjgov.org/department/hr/eeo.



    Click on a link below to apply for this position:

    Fill out the Supplemental Questionnaire and Application NOW using the Internet.
    View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here.
    View and print the official application form as an Acrobat pdf file. scannable paper application A San Joaquin County application form is required for this recruitment. You may print this Acrobat PDF document and then fill it in.
    Contact us via conventional means. You may contact us by phone at (209) 468-3370, or by email, or apply for a job in person at the San Joaquin County Human Resources Division.

    Powered by JobAps



    San Joaquin County
    Human Resources Division  Stockton, CA 95202
    E-mail | Phone: (209) 468-3370 | 8am - 5pm M-F | Powered by JobAps