Department Systems Analyst - Programmer II
City of Scottsdale
- Scottsdale, AZ
- $74,630-108,514 per year
- Permanent
- Full-time
The Transportation & Streets department is seeking a skilled technologist with a strong understanding of SQL database, asset management, work management, automation and data analysis.Under direction of assigned supervisor, manager or director, provides complex analytical support, maintenance and/or modification of existing systems and development of new modules/functions in one or more areas/systems. Provides coordination with the Information Technology Department serving as liaison between business users and information technology staff, vendors and service providers; and performs related work as required.Minimum QualificationsEducation and Experience
- Bachelor's Degree from an accredited educational institution.
- Three years of experience directly working on computer-based information systems' software and programming/scripting languages in support of medium enterprise applications.
- Any equivalent combination of education and/or job-related experience that meets the minimum qualifications may be substituted.
- 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.
- Provides support required for all functional area related software applications including working with vendors to upgrade systems or training new users on the system.
- Provides guidance on system or workflow modifications and changes needed to support operational, program and/or regulatory compliance.
- 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.
- Assists in the coordination and implementation of system upgrades and leads or participates in the testing of such upgrades.
- Communicates clearly and concisely, both verbally and in writing.
- Provides departmental business subject-matter expertise as they relate to technical and systems operations.
- 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.
Benefits Highlights:
The City of Scottsdale offers a comprehensive benefits package including:
- 12 Paid Holidays, which includes 1 Floating Holiday
- Vacation Accrual; starts at 10.3 hours/month
- Sick Leave Accrual; 8 hours/month
- Medical (which includes behavioral health coverage), Dental and Vision Benefits
- City Paid Basic Life Insurance (equal to one times employee annual salary); option of Supplemental Life Insurance
- Tuition Reimbursement; $2,500/year
- Participation in the Arizona State Retirement System (ASRS) Defined benefit plan with mandatory employer and employee contributions currently at 12.29% which includes a Long-Term Disability benefit
- Supplemental Retirement Plans through Nationwide; 457
- Pet Insurance
- Bilingual pay compensation
Selection Process:
The application and supplemental questions are an integral part of the selection process and must be completed in full in order for you to be considered as a candidate. Please complete each section and answer all questions as thoroughly as possible. DO NOT state “See Resume” in lieu of answering. Unanswered questions, incomplete responses, omissions, or partial information may result in disqualification from the selection process.Applicants whose education, training and experience most closely meet the needs of the position may be invited to participate in a selection process that may include a panel interview. Successful candidates will receive a post-offer, pre-employment background screening that may include:
- Fingerprinting search of the national FBI Database
- Criminal Background screening
PLEASE NOTE: Years of experience are based on a work schedule of 2,080 hours per year for full-time positions and 1,040 hours per year for part-time positions, and while work experience may substitute for education on a year-for-year basis, depending upon the job classification, education may not be substituted for work experience.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 .