Dept Systems Analyst / Programmer III/II/I (Part time Underfill)

• Design, develop, and maintain reports using Oracle OTBI, BI Publisher, and related reporting tools (primary focus of the role)
• Analyze business requirements and translate them into technical reporting solutions
• Write and optimize queries to extract and analyze data from Oracle Fusion and related systems
• Support reporting enhancements, system configuration, and continuous improvement initiatives
• Collaborate with business users, IT staff, and vendors to deliver effective and scalable solutions
• Troubleshoot reporting and data issues, ensuring accuracy and reliability of outputs
• Support Oracle EPM-related reporting and budgeting processes

Do you have a valid Driver’s License license?, Do you have experience in Software administration?, Do you have a Associate’s degree?, Are you a highly technical, data-focused professional who enjoys building robust reporting solutions and working directly with enterprise financial systems?

The City of Scottsdale’s Budget Department, within the City Treasurer’s Office, is a high-performing team responsible for delivering accurate, timely, and actionable financial data that supports decision-making across the organization. We leverage Oracle Fusion ERP and Oracle EPM to support core financial processes, strengthen reporting capabilities, and provide departments with reliable data for planning and analysis.

We are seeking a technically skilled analyst with strong report development experience to join our team. This role is heavily focused on reporting, with approximately 60% of responsibilities dedicated to designing, building, and maintaining reports using Oracle OTBI, BI Publisher, and related tools.

This position is ideal for candidates who:

• Enjoy hands-on report development and data analysis
• Have experience working with enterprise ERP/EPM systems
• Can translate business needs into scalable reporting solutions
• Thrive working both independently and collaboratively in a fast-paced environment

In this role, you will partner with Budget staff, IT, and stakeholders across the organization to deliver high-quality reporting solutions, improve data accessibility, and support critical financial processes., * 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, 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., * 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 Requirements

• Depending 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., * Associate’s Degree is required.
• One year of experience working directly on computer-based information systems’ software, with a focus on system administration and management.
• 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, 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.

Pulled from the full job description

• Loan forgiveness
• Health insurance
• Vision insurance
• Dental insurance
• Life insurance
• Disability insurance, IMPORTANT: This position is part-time and fully on-site. It is not eligible for remote work. This is an unclassified, at-will position that serves at the discretion of the City. Part-time positions have limited benefits as required by law.

Applicants who do not meet all the minimum requirements for the Department Systems Analyst/Programmer III position may be considered for an underfill as a Department Systems Analyst II or I, depending on applicant qualifications. If the position is underfilled, the salary offered would be commensurate with the lower-level classification. The minimum requirements and salary range for the underfill position are listed below in the minimum qualification section.

Anticipated starting salary for this position may be up to mid-point depending on candidate’s experience and internal equity. Although the full salary range is listed above, the salary range to midpoint for each position is listed below., 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

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.

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.

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).