Salary: $39.56 - $57.50 Hourly
Location : Scottsdale, AZ
Job Type: PT Regular
Job Number: FY2324-00741
Division: CITY TREASURER
Department: BUDGET
Opening Date: 04/12/2024
Closing Date: 5/3/2024 11:59 PM Arizona
Introduction
This is a part-time position that does not include benefits and will be scheduled for 30 hours per week.
The City of Scottsdale is looking for a Department Systems Analyst III that will support the Accounting and Budget systems and operations in the City Treasurer's Office. Normal daily duties may include performing daily/monthly tasks, process analysis, general IT support of Smart Stream, participation in the migration of the ERP and other accounting applications, SSRS/Power BI/Excel development, TSQL query analysis, system testing, as well as meeting with customers and peers to further all the aforementioned efforts.
Minimum Qualifications

Education and Experience

• Bachelor's Degree from an accredited educational institution.
• Five years of experience directly working on computer-based information systems' software, and programming/scripting languages in support of medium to large enterprise applications.
• Any equivalent combination of education and/or job-related experience that meets the minimum qualifications may be substituted.

Licensing, Certifications and Other Requirements

• Depending on the department assignment, obtain and maintain a Level D - Technical Arizona Criminal Justice Information System (ACJIS) Network Terminal Operator certification. Training is provided on duty and testing is completed within first six months of hire.
• Every person employed by the City of Scottsdale shall reside in the State of Arizona during his or her active employment by the City, regardless of whether the employee is approved to remote work.

Other pertinent licenses and/or certifications may be required of some positions depending on division/department/service assignment.
Essential Functions

• Works within the assigned department and provides application support on the designated systems.
• Performs ad hoc database querying for users.
• Designs and develops data reporting/extraction solutions.
• Assists in system analysis, computer configuration, planning and training of employees on the assigned functional area's automated systems to ensure optimal performance of the systems.
• Develops custom SQL Server Reporting Services (SSRS) or PowerBI (PBI) reports based on customer needs and requirements.
• Develops custom ETL (Extract, Transform, Load) process using SQL SSIS and similar tools based on customer needs and requirements.
• Leverages API (Application Programming Interfaces) to extract or transmit data to applications.

Work Environment/Physical Demands

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this position or that an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

• Most work is accomplished in an office environment, but remote working may be accommodated, as needed.
• Operate a variety of standard office equipment requiring continuous and repetitive arm, hand and eye movement.
• Lift and move computer equipment weighing up to 30 pounds.
• Travel to meetings and/or various locations as required.
• Perform off-hours scheduled maintenance downtime.
• Work on call on a scheduled and as needed basis.

EQUAL EMPLOYMENT OPPORTUNITY: It is the policy of the city to provide employment opportunities to all persons based solely on ability, regardless of race, color, religion, sex, national origin, age, sexual orientation, gender identity or disability.

When advised reasonable accommodations will be made in order for an "otherwise qualified applicant" with a disability to participate in any phase of the recruitment process. Please contact Human Resources to request an accommodation. Persons with a disability may request a reasonable accommodation by contacting HR Receptionist at (480) 312-2491. Requests should be made 24 hours in advance or as early as possible to allow time to arrange the accommodation. For TTY users, the Arizona Relay Service (1-800-367-8939) may contact HR Receptionist at (480) 312-2491.

This position description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the position change.
Full-Time Positions:
The City of Scottsdale offers a comprehensive benefit package including vacation, holiday and medical leave as well as insurance for medical, dental, vision, life, short and long term disability insurance. For a more detailed overview of the employee benefits,
Part-Time Positions:
The City of Scottsdale offers paid medical leave for part-time staff.
Commute Solutions Program
City of Scottsdale provides free Valley Metro Platinum passes to employees for the bus and light rail systems when commuting; a vanpool subsidy is also available. Employees can decrease stress, decrease wear & tear on their vehicle, and help the environment all at the same time.
Public Service Loan Forgiveness Program (PSLF).
The City of Scottsdale is considered a qualified employer for the Public Service Loan Forgiveness Program (PSLF). You may find more information about the PSFL program by going to the Federal Student Aid website by clicking
01

Do you have a Bachelors degree in Computer Science or a related field of study? Note: The degree (to include the major) must be listed in the Education Section of the application.

• Yes
• No

02

Do you have at least five years of experience directly working on computer-based information systems' software, and programming/scripting languages in support of medium to large enterprise applications? Note: Employers mentioned here must be shown in the Work Experience section of the application.
03

Do you have medium to expert level experience using Microsoft Office Products to include MS Office 365?

• Yes
• No

04

Do you understand that this is a 30 hour/week position that does not include benefits?

• Yes
• No

05

Please describe your technical experience supporting Accounting and Budget Systems, employee databases and related software programs. List the software programs used and the employer(s) where you had the experience. Note: Employers mentioned here must be shown in the Work Experience section of the application. Do not state "See resume" in lieu of responding to this question. If you don't have this experience, please write "None."
06

Please describe your experience running daily processes, trouble-shooting and resolving technical issues. Please indicate the employer(s) where you performed the work. Note: Employers mentioned here must be shown in the Work Experience section of the application. Do not state "See resume" in lieu of responding to this question. If you don't have this experience, please write "None."
07

Please describe your experience using Structured Query Language (SQL) and SSRS to elicit information from databases, to include the type of report(s) or queries and employer(s) where you performed the work. Note: Employers mentioned here must be shown in the Work Experience section of the application. Do not state "See resume" in lieu of responding to this question. If you don't have this experience, please write "None."
08

Please indicate how you learned about this job opportunity with the City of Scottsdale.

• City Website
• Employee Referral
• Facebook
• Glassdoor
• Governmentjobs.com
• Indeed
• Instagram
• Job Fair (In-Person / Virtual)
• Recruiter
• Other

Required Question