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.
Closing Date/Time: 5/3/2024 11:59 PM Arizona
