Stay at the forefront
of market
Get the latest updates on AI-powered hiring, career growth, and technical deep-dives delivered to your inbox.
Get the latest updates on AI-powered hiring, career growth, and technical deep-dives delivered to your inbox.
City of Scottsdale
IntroductionUnder 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.
The Programmer II assigned to Planning, Research & Accreditation (PRA) for the Scottsdale Police Department, serves as the department’s primary data systems specialist and technical reporting authority.
This role develops and maintains SQL-based reporting solutions, dashboards, and automated data processes that support official departmental statistics, executive-level ad-hoc requests, accreditation reporting, and Council briefings.
In collaboration with City IT, this position also serves as the Department’s Web Content Manager, ensuring that published data, dashboards, and web-based reporting tools are accurate, timely, and aligned with City standards. The Programmer II plays a critical role in safeguarding the integrity and defensibility of information released on behalf of the Department.
Housed within PRA, this role ensures data development remains aligned with performance management, compliance requirements, and strategic priorities, while reducing reliance on manual processes and preserving institutional technical knowledge.
Please note: Be sure to check your email junk/spam folders regularly for possible notifications and/or self-schedule interview invitations from Governmentjobs.
Anticipated starting salary for this position may be up to mid-point depending on candidate’s experience and internal equity. The full salary range is listed above and mid-point for this position is $48.18/hour or $100,152.00/annually.
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.
Licensing, Certifications and Other
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.
Selection ProcessThe 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.
EducationApplicants 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 DatabaseDrug Screen 39-Month Motor Vehicle Department Records CheckThe timeframe for reapplication with the Police Department varies based on the position and the needs of the organization.
The City of Scottsdale reserves the right to change this process at any time, potentially without advance notice.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.
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 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 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 PositionsThe 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, click here.
Part-Time PositionsThe City of Scottsdale offers paid medical leave for part-time staff.
Commute Solutions ProgramCity 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 here.01What experience do you have developing SQL queries, ETL processes, or SSRS/PowerBI reports?02What experience do you have supporting enterprise applications in a public sector or law enforcement environment03What experience do you have translating business requirements into technical solutions?04Do you have knowledge of CJIS, data governance, or regulatory compliance environments?
YesNo05Do you have a Bachelor's Degree from an accredited university?
YesNo06Which best describes your experience in applying for a position with the Scottsdale Police Department?
No ExperienceSubmitted ApplicationTested and/or InterviewedSubmitted Background Packet07How did you learn about this job opportunity with the Scottsdale Police Department?
YesNo10Are you a current City of Scottsdale employee?
YesNo11I understand that any communication for this recruitment may come via an email from governmentjobs.com and I will check my email junk/spam folders regularly for possible notifications and/or self-schedule interview invitations.
YesNo Required Question
Most resumes get rejected by the ATS before a human sees them. Check yours free in 30 seconds.
Matched to your profile
We surface this role because it matches profiles like yours, not because we vet the employer. Always confirm the pay, location, and remote details on City of Scottsdale's official site before you apply.
Most large employers screen resumes with software before a recruiter ever sees them. Check yours against this role in seconds. Free, no sign-up.
See the exact keywords from this posting your resume is missing, with an instant ATS score.
Open free toolUpload your CV for an instant 0-100 score and the fixes recruiters and ATS look for.
Open free toolGenerate a clean, single-column resume that parses correctly and gets past the filters.
Open free toolOther live openings in the same field. All are still accepting applications.