Department Systems Analyst/Programmer III (Part-Time)

City of Scottsdale Department Systems Analyst/Programmer III (Part-Time) SALARY $39.
56 - $57.
50 Hourly LOCATION Scottsdale, AZ JOB TYPE PT Regular JOB NUMBER FY2324-00585 DIVISION CITY TREASURER DEPARTMENT BUDGET OPENING DATE 02/23/2024 CLOSING DATE 3/15/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 https://www.
scottsdaleaz.
gov Department Systems Analyst/Programmer III (Part-Time) 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.
" * Required Question