Information Technology Applications Analyst Level I/II

Information Technology Applications Analyst I/IIperforms professional duties related to the analysis, design, development, maintenance and administration of computer applications to meet business needs. Incumbents may perform duties within Application Development and/or Database Architecture.

The Information Technology (IT) Applications Analyst is a single class with two salary levels. Positions in this class are flexibly staffed and the level at which appointments are made are at the discretion of the appointing authority.

Examples of Knowledge and Abilities

Knowledge Of:

• General operations, services, concepts, terms and activities common to a comprehensive, state-of-the-art information systems program
• Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems
• Software systems development lifecycle
• Data processing techniques, including the types of hardware and software currently used to process data with different levels of complexity
• Basic project management principles and techniques such as organizing and managing a project, developing schedules, identifying critical paths, and breaking down a project into individual tasks
• Structured analysis and database concepts
• Industry standard hardware, software , operating systems and database software
• Tools and equipment used in testing the functionality of computer applications
• Principles, practices, and techniques of troubleshooting computer software problems and of providing quality customer service
• Methods and techniques of developing and presenting technical documentation and training materials
• Principles and practices of technical documentation
• Modern office procedures, methods and equipment
• Various programming and scripting languages
• Program design and analysis
• Test plan and test case development and use
• The software development lifecycle which includes planning the application layers, designing distributed applications, configuring state management, and designing a caching strategy
• Mobile and web application design and development
• Database architecture and administration; design methods and techniques; security methods, procedures and best practices
• Related data/file management tools
• Techniques for defining logical relationships among data, processes or events
• Installing and configuring databases
• Maintaining databases (backups, restores, configuration, integrity, snapshots, maintenance plans), server instances and security
• Data management tasks (import and export data, manage partitions, data compression, maintain indexes, manage collations)
• Optimizing databases for performance
• Implementing high availability, data warehousing and business intelligence platforms

Ability To:

• Recognize problems; gather, analyze and evaluate data and information in order to reason logically; draw valid conclusions; take appropriate actions and/or make appropriate recommendations
• Research, design, implement and maintain various software technology solutions, including new technology, in order to improve County processes or services
• Communicate technical information to a wide variety of users
• Interpret and explain pertinent County and Department policies and procedures
• Explain the values and limitations of services requested
• Recognize that changes made on a local level can affect services and equipment at the system wide level and take appropriate precautions
• Plan, organize, and prioritize multiple projects/assignments to ensure that deadlines are met
• Learn and utilize specialized terminology if needed by the specific assignment
• Interpret and apply technical information pertaining to computer and network systems
• Adapt quickly to changes in policies, procedures, assignments and work locations including the environment
• Communicate effectively, both verbally and in writing
• Establish and maintain effective working relationships with those encountered during the course of the work; promote and maintain a team environment
• Prepare and maintain documentation for procedures, processes, and tables related to area of assignment
• Read, comprehend, apply, and retain technical publications and documentation
• Read and interpret source code from the County's commonly used programming languages; develop a working knowledge of new programming languages
• Write, revise, and maintain computer programs based on established specifications, using various computer languages and/or database platforms
• Work with source code control systems to store and retrieve application's source code
• Troubleshoot and repair a variety of application issues using appropriate program testing methods and tools
• Troubleshoot database related problems
• Ensure maximum database availability and that data integrity is maintained
• Design and modify database structures
• Manage complex databases and develop queries for common purpose
• Use Enterprise Database Management Studios, A valid California Driver License, Class C or higher, may be required at the time of appointment. Failure to obtain or maintain the appropriate California Driver License may constitute cause for personnel action in accordance with Civil Service Rules or applicable bargaining agreement. Individuals who do not meet this requirement due to disability will be reviewed on a case-by-case basis.

Physical Requirements:

Some positions in this class may require the incumbent to be able to:

• Distinguish between different colors.
• Lift equipment that weighs up to 50 pounds.

Individuals who do not meet these requirements due to disability will be reviewed on a case-by-case basis., * Employment applications and all documentation requested in this announcement must be submitted by 5:00 p.m. on the cut-off date.

• Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date.
• Your application should highlight all relevant education, training, and experience, and clearly indicate how you meet the minimum qualifications for the position as of the cut-off date.
• Application information must be current, concise and related to the requirements in this job announcement. You may only apply for this recruitment once. Duplicate and incomplete applications will be disqualified.
• A resume may be included with your application, however it will not substitute for the information requested on the application.

SUPPLEMENTAL QUESTIONNAIRE

Applicants are required to provide a full and complete response to each supplemental question. The Supplemental Questionnaire is located in the tab marked "Supplemental Questions". Please be descriptive in your response.

Note: Responses of "See Resume" or "See Application", or copy and paste of work experience are not qualifying responses and will not be considered.

• Supplemental Questionnaires must be submitted by 5:00 p.m. on the cut-off date. Employment Services is not responsible for any issues or delays caused by an applicant's computer or web browser. Applicants will be automatically logged out if they have not submitted their applications and all documentation prior to 5:00 p.m. on the cut-off date.
• The supplemental questions are designed to elicit specific information regarding a candidate's experience, education, and training. Responses should be consistent with the information on your application and are subject to verification.
• Please provide place of employment, pertinent dates, and concise, descriptive and detailed information for each question.
• If a job included responsibilities applicable to several questions, separate the different functions of the job to answer all the questions completely.
• Resumes or referral to the application or other questionnaire responses will not be accepted in lieu of completing each question.
• If you have no experience, write "no experience" for the appropriate question.
• For many individuals, it is more efficient to develop responses to the supplemental questions in a word processing document and then paste them into the final document to be submitted. Changes or corrections to your Supplemental Questionnaire cannot be made once your application packet has been submitted.
• If the Supplemental Questionnaire is used in the Formula Rate exam, failure to complete all of the questions or incomplete responses will result in a lower score. While scoring the Supplemental Questionnaire, the candidate's application and/or attachments will not be reviewed , therefore, a candidate's responses to the questions should be accurate, thorough, detailed, and complete., Possession of a valid California Driver License may be required for some positions.

Either: 1. A Bachelor's Degree or higher from an accredited college or university in Computer Science, Information Technology, or other field closely related to the intent of the class.

Or: 2. Four (4) years of full-time, paid technical experience that demonstrates the ability to perform duties in design, development, maintenance or administration of computer applications and/or database architecture.

Or: 3. Four (4) years of full-time, paid experience in Sacramento County service providing user support in technology; system, software/application and legacy troubleshooting; problem resolution; review of business processes and communication of user requirements/problems to a vendor or statewide system.

Note: Education from an accredited college or university with major course work in Computer Science, Information Technology, or other field closely related to the intent of the class, may be substituted for the required experience on a year-for-year basis; 30 semester units (45 quarter units) equal one year experience.

Note: If the word "experience" is referenced in the minimum qualifications, it means full-time paid experience unless the minimum qualification states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements., Entitles a regular County employee, with at least one year of continuous employment, to schedule a paid parental leave of up to 160 hours upon the birth or during the process of an adoption of a minor child. Parental leave shall be approved by the employee's appointing authority, except where the granting of the parental leave request would unduly interfere with or cause severe hardship upon department operations., "Experience" means full-time paid experience unless the announcement states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements., As required by the Immigration Reform and Control Act, all County employees must be United States citizens or aliens lawfully authorized to work in the United States. Proof of citizenship or authorized status will be required prior to appointment., Persons who have special skills required by some (but not all) positions in a class may be certified ahead of others provided that:

Such special skills are based on the duties and requirements of the positions and are in conformance with merit system and equal opportunity principles, and The certification of eligibles who possess special skills have been approved by the Civil Service Commission.

Some positions in this class may require the incumbent to:

• Work weekends, holidays, and non-routine hours.
• Travel occasionally., The beginning salary and the top of the salary range are usually shown on the job announcement. Upon satisfactory service, salary increases of approximately 5% are given annually until the top of the salary range has been attained., The County provides a comprehensive dental benefit program for regular full-time and part-time employees and their eligible dependents. This plan pays on a set fee schedule that varies by procedure. Any amount over the fee schedule is the employee's responsibility. The yearly maximum is $2,000 per person, not including orthodontia. The orthodontic benefit is 50% of covered charges with a lifetime maximum of $1,000 per person., The County of Sacramento provides an Employee Assistance Program (EAP) for employees and their eligible dependents. The EAP offers confidential, professional counseling services in areas such as:
• Legal Advice/Difficult Decisions
• Marriage or Family Relationships
• Financial or Credit Worries/Elder Care
• Alcohol and Drug Abuse

WELLNESS INCENTIVE PROGRAM: The County will recognize and award time off to eligible employees who maintain an excellent attendance record.

FLEXIBLE SPENDING ACCOUNT: The County offers regular employees two separate Flexible Spending Accounts (FSA's). These accounts allow employees to set money aside, on a pre-tax basis via payroll deduction, to pay for medical, dental or dependent care expenses.

• DEPENDENT CARE REIMBURSEMENT ACCOUNT: Employees may set aside pre-tax dollars to pay for qualified childcare or dependent care expenses that are necessary for the employee and/or spouse to continue working.

• MEDICAL REIMBURSEMENT ACCOUNT: The Medical Reimbursement Account allows pre-tax dollars to be set aside to pay for out-of-pocket expenses that are not paid by insurance or reimbursed by any other benefit plan.

Sacramento County is about enriching communities to thrive. We strive to create inclusive workplaces that reflect the communities we serve. We value and celebrate the unique perspectives, backgrounds, abilities, and diverse dimensions of our employees and residents. Through transparency, courage, innovation, and trust we are committed to advance equity and transformational change., The County of Sacramento is a great place to work, grow and thrive professionally. We are an equal opportunity employer of more than 12,800 full-time employees dedicated to providing a variety of services for a diverse and vibrant County. Services include public safety and protection, community and municipal services, health services, voter registration, and many more.