Intelligence Analyst

Programmer IIUnder 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.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.Minimum QualificationsEducation and ExperienceBachelor'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 RequirementsDepending on the department assignment, must possess and maintain a valid, unrestricted driver's license with no major citations within the past 39 months prior to the start date. The Arizona Department of Motor Vehicles requires that out-of-state driver's licenses must be surrendered within 10 days of relocating to the State of Arizona.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.Essential FunctionsPerforms duties and responsibilities commensurate with assigned functional area within a department(s) which may include, but are not limited to, any combination of the following:Provides guidance on system or workflow modifications and changes needed to support operational, program and/or regulatory compliance.Performs ad hoc database querying for users.Evaluates and analyzes assigned functional area related processes, procedures and workflow to determine the feasibility of different technology options and solutions to meet their requirements.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.Participates in a variety of system user groups, work groups and/or project teams to identify user needs and operational, programmatic and/or regulatory changes affecting application requirements and other related issues.Maintains and develops a variety of departmental and/or program files, records, queries and generates reports and dashboards on a scheduled and/or ad hoc basis.Work Environment/Physical DemandsThe 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.Benefits Highlights: The City of Scottsdale offers a comprehensive benefits package including:12 Paid Holidays, which includes 1 Floating HolidayVacation Accrual; starts at 10.3 hours/monthSick Leave Accrual; 8 hours/monthMedical (which includes behavioral health coverage), Dental and Vision BenefitsCity Paid Basic Life Insurance (equal to one times employee annual salary); option of Supplemental Life InsuranceTuition Reimbursement; $2,500/yearParticipation in the Arizona State Retirement System (ASRS) Defined benefit plan with mandatory employer and employee contributions currently at 12% which includes a Long-Term Disability benefitSupplemental Retirement Plans through Nationwide; 457Pet InsuranceBilingual pay compensationSelection 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 DatabaseDrug Screen39-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.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 at View phone number on click.appcast.io. 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 View phone number on click.appcast.io) may contact HR at View phone number on click.appcast.io. 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.