Address:

Strategy, Sustainability & Research
701 East Jefferson Street
Phoenix, Arizona 85034
https://corrections.az.gov/

Salary:  $78,000.00

Grade: 24

Closing Date: 06/23/2025

The Arizona Department of Corrections, Rehabilitation, and Reentry (ADCRR) is looking for an experienced programmer analyst with a strong background in Database management. We are seeking someone who is driven to help contribute to reimagining our Strategy, Sustainability, and Research (SSR) Team.

Over the past year, our SSR team has strived to become a more valuable resource for the agency and all its divisions. We have concentrated our efforts on helping these divisions compile, analyze, and utilize data to make informed decisions. As we continue to grow, we are seeking dedicated individuals who want to make a difference and contribute to the evolution of technology and data usage to improve corrections.

This position involves extracting data from relevant correctional systems to produce output files. Most data extraction will be done using Personal Computer (PC) based Statistical Analysis System (SAS),but it will also include data extraction from the mainframe system used by ADCRR. You will be responsible for manipulating and analyzing the data obtained from these output files. You will also produce regular reports on a monthly, quarterly, and/or annual basis, as well as complete various ad-hoc requests. We are seeking a candidate who is excited to collaborate and communicate with all the teams within the ADCRR, including the IT Bureau, to enhance the efficiency and accuracy of software system development.

- Interprets project functions in computer application programming code that meets project requirements
- Designs efficient ways of accessing and extracting data for research and specialized reports
- Prioritizes and plans work activities. Most work will be done on PC-based Statistical Analysis System (SAS), Statistical Package for the Social Sciences (SPSS), Structured Query Language (SQL), or something equivalent
- Analyzes current and proposed database designs to ensure project objectives and requirements are met
- Plans and designs accurate and efficient database tables and flat files in SAS format for historical research
- Creates test data and test computer programs to ensure the validity of the data and the program
- Meets with users to formulate, clarify, and finalize project objectives and requirements
- Act as liaison to aid in continued improvements to systems, validating data, and programs
- Writes, tests, and debugs code ensuring software functionality and reliability (i.e, ACIS, Recidiviz, and any new systems utilized by ADCRR)
- Utilizes Power BI to create visualizations that analyze data, identify trends, and generate reports to inform business decisions
- Ensures management is kept informed about the progress of projects
- Addresses any issues related to the projects promptly and effectively
- Generates required reports using word processing and spreadsheet software
- Prepares and presents findings to management
- Produces both regular reports and ad-hoc reports in response to legislative inquiries and public records requests
- Participates in meetings and discussions to gather information and insights regarding the data
- Communicates technical information clearly and effectively to both technical and non-technical audiences
- Creates and maintains Standardized Operating procedures for tasks relevant to your position (i.e systems, applications, report writing, and running/ updating code)
- Drives on State business and travels throughout the state, potentially involving overnight stays
- Performs other duties appropriate to the assignment

Knowledge of:
- Proficiency in multiple Programming languages (R, Python, C++, SQL, SAS, Visual Basic for Applications (VBA))
- Advanced SAS functions for data processing, including SAS macros
- Experience with data analysis expressions (DAX) and M is helpful for Power BI Development
- Experience with SPSS, as well as Microsoft Access is helpful
- Experience with cloud platforms is helpful
- Computer capabilities and communications systems
- Document and report layout within word processing and spreadsheet software
- Department policies and procedures
- Familiarity with LAN/WAN technology (Local Area Networks)

Skill in:
- Personal computer applications and operation/utilization of personal computer hardware, software, data analysis, and information reporting
- Aptitude in the utilization of Internet-accessible file formats and search tools such as portable document format (PDF, Adobe Acrobat), web browsers, and their differences, and Hyper Text Markup Language (HTML) table formatting for reporting data
- Data Structures and Algorithms
- Diligence and attentiveness to detail
- Multitasking
- Organizational interpersonal relations
- Debugging and Problem-solving
- Decision making
- Verbal and written communication skills
- Conflict resolution
- Experience with querying relational database management systems (intermediate to advanced SQL skills)

Ability to:
- Demonstrate a collegial attitude and a sense of teamwork and accomplishment
- Recognize and resolve problems and conflicts
- Flexible and creative regarding the assignment of work activities and tasks
- Effectively communicate with other staff when determining appropriate troubleshooting techniques and problem resolution strategies
- Provide clear and concise advice and direction regarding project and task completion, system requirements, and work assignments
- Uses time efficiently
- Balance, prioritize, and organize multiple tasks
- Work collaboratively in teams
- Synthesize feedback and adjust accordingly
- Analyze business requirements, design solutions, and develop software systems

- Two plus (2+) years of experience as a programmer analyst or software developer, or equivalent experience in a related field
- A Bachelor's degree in Computer Science, Software Engineering, or a related field, or equivalent experience

Employment is contingent on the selected applicant passing a background investigation.

If this position requires driving or the use of a vehicle as an essential function of the job, then the following requirements apply. Any employee operating a motor vehicle on State business must possess and retain a current, valid class-appropriate driver’s license, complete all required training, and successfully pass all necessary driver’s license record checks. The license must be current, unexpired, and neither revoked nor suspended. Employees who drive on state business are subject to driver’s license record checks, must maintain acceptable driving records, and must complete all required driver training. An employee who operates a personally owned vehicle on state business shall maintain the statutorily required liability insurance (see Arizona Administrative Code (A.A.C.) R2-10-207.11).

In an effort to maintain a safe environment, all employees are required to take a Tuberculosis (TB) test during their New Employee Orientation and every year thereafter.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

We offer an excellent and affordable comprehensive benefits package to meet the needs of our employees:
- Vacation and sick days with 10 paid holidays per year
- Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
- Robust and affordable insurance plan to include medical, dental, life, short-term and long-term disability options
- Exceptional retirement program
- Optional employee benefits such as deferred compensation plans, credit union membership, and a wellness program
- An incentivized commuter club and public transportation subsidy program

Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Positions in this classification participate in the Arizona State Retirement System (ASRS). Enrollment eligibility will become effective after 27 weeks of employment.

Current ADC Employees: Consult with your respective Human Resources Liaison if you are in a different retirement plan than the one indicated above.

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by calling (602) 255-2430. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.