Department Systems Analyst/Programmer III - #1335741

City of Scottsdale

Department Systems Analyst/Programmer III

SALARY

$39.56 - $57.50 Hourly

LOCATION

Scottsdale, AZ

JOB TYPE

Full-Time 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.

Agency

City of Scottsdale

Address

9191 E San Salvador Dr

Scottsdale, Arizona, 85258

Website

http://www.scottsdaleaz.gov

Department Systems Analyst/Programmer III Supplemental Questionnaire

QUESTION 1 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

QUESTION 2 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.

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

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

QUESTION 5 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."

QUESTION 6 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."

QUESTION 7 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."

QUESTION 8 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