TUCSON WATER BUSINESS ANALYST II

Business & Organizational Support Services Division (BOSS)

Recruitment #2205-0857-001

Introduction

Tucson Water is the second largest water utility in Arizona, serving over 730,000 customers over a 390 square mile service area. Tucson Water is recognized internationally as a leader in water conservation, sustainability, and service. Our employees are proud stewards of our community’s most precious natural resource, working to embody the utility’s motto of “Pride In Service.” 

The City of Tucson is seeking a highly motivated Business Analyst II to join our team at the Tucson Water Department. This position resides within the Business and Organizational Support Services Division and will provide technical support to enterprise level systems.  The new enterprise level systems coming online in the upcoming years will offer more functionality, improve business processes, and will have a vast integration framework that leverages people, process and technology to improve reliability, increase efficiency, reduce cost, drive innovation and improve the customer experience.   

This is a hybrid telecommuting position where approximately 50% of work is completed in the office and 50% is completed virtually. This model may change based on future business needs. Successful candidates will work from home and must abide by the terms and guidelines in the City of Tucson Telecommuting Administrative Directive 2.01-19 to include:

  • Must have a minimum of 50 Mbps to connect to the internet 
  • Shall designate and maintain a dedicated workspace that is quiet, clean, and safe, with adequate lighting and ventilation

 

The City of Tucson offers a wide range of generous benefits for eligible employees. Some of those benefits include:

  • Medical: Choice between a high deductible plan (HSA or HRA), or Network plan
  • Dental: Choice between a national dental PPO and a local dental HMO
  • Vision: Coverage for annual eye exam and glasses or contacts, plus LASIK
  • Life: City-paid coverage for you & dependents, plus option to buy more
  • Long-Term Disability: Income replacement of up to 60% of your base salary in the event of a qualifying disability
  • Employee Assistance Program: Enhance your wellbeing when life doesn’t go as planned
  • Flexible Spending: Pay for qualified health and dependent care expenses using pretax dollars
  • Colonial Voluntary Benefits: Financial help in the event of cancer, hospitalization, accident, and more

 

Your Security and Future

  • Pension: Generous pension plans that help both civilian and public safety employees retire more comfortably
  • Deferred Compensation: Save more toward a comfortable retirement with a 457(b) plan
  • Training & Tuition Assistance: Pursue your dream through internal training or financial help toward a degree
  • Back-Up Care: Care for your loved ones when your regular care is unavailable

 

Your Peace of Mind

  • Paid Parental Leave: Six (6) weeks paid leave when you welcome a child, plus other generous leave policies for FML, Medical and USERRA
  • Paid Time Away: New hires enjoy 37 days of paid time off in the first year, with time increasing steadily thereafter (In year one: 13 accrued days of vacation, 13 accrued days of sick leave, and 11 paid holidays)
  • Employee Discounts: Generous discounts, ranging from car rentals to computers, gifts to groceries, electronics to entertainment
  • Social Connectedness: Forge connections with the community we serve through paid volunteerism and payroll-deducted charitable giving

For a full description of benefits offered to eligible employees, or to inquire further about the City of Tucson's benefits options, please visit: https://www.tucsonaz.gov/hr/employee-benefit-snapshot

General Description

This position will support the ongoing needs and requirements of the user base as it relates to data by providing technical assistance to end users, update/maintain training materials, and system related documentation as needed.  Additionally, this position will be responsible for gathering requirements and making recommendations for any new requests or enhancements for the sustainability and the technology’s continued growth with the utility.   

Essential Functions

The essential duties include but are not limited to:

  • Serves as technical lead on ERP-level implementations, maintenance, and upgrades.
  • Analyzes departmental business issues and data challenges, elicits requirements from management and internal customers to develop functional and system configuration specifications utilizing technological solutions.
  • Develops, tests and implements new systems or modified system enhancements to meet changing requirements.
  • Performs daily systems duties to include loading data and generating reports, ensuring system applications processed in a timely manner and solves daily production system problems as they occur.
  • Performs maintenance and makes modifications to reference tables in the ERP-level modules and systems.
  • Creates complex non-routine queries and maintains a variety of system reports, scripts, workflow, and automated tasks using structured query language and various database management tools.
  • Advises on system capability, compiles data, and implements data driven decisions and strategies for management.
  • Troubleshoots end-user, functional and technical problems.
  • Serves as liaison with Information Technology, departmental staff, and vendors to evaluate, test and support new functionality, developments, and enhancements of ERP-level modules or systems.
  • Plans and publishes monthly calendars and fiscal year end schedules.
  • Monitors and approves system security, updates, and maintains system security records and permissions.
  • Creates procedural documentation and provide training to end-users


This description is not intended to limit or in any way modify the right of management to assign, direct and control the work of employees under supervision. The listing of duties and responsibilities shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty. They are intended to describe the general nature and level of work performed by individuals assigned to this position.

Minimum Qualifications

Minimum Education Level & Type: Bachelor's Degree

Minimum Experience Qualifications: At least 5 years of experience in technical support involving ERP or large database systems.

Valid and unrestricted Class D - Driver’s License

An equivalent combination of education, training and experience, which provides the required knowledge, skills and abilities to successfully perform the essential functions of this position may be considered.

Preferred Qualifications

The ideal candidate will possess the above minimum qualifications and additional relevant experience in the areas of:

  • A working knowledge of enterprise class relational databases, e.g. Oracle, Microsoft SQL Server, IBM DB2 and the interaction of enterprise applications with their respective databases. (Note: Desktop database applications such as Microsoft Access or Open Office Base do not fulfill this requirement).
  • Strong written and oral communications skills and the ability to convey complex technical material to non-technical users in a friendly and non-threatening manner.
  • A curious and innovative attitude and the desire to constantly look for ways to improve processes to resolve business issues.
  • A strong working knowledge of Business Intelligence software, e.g., Tableau, Power BI, Qlik, Crystal Reports.
  • A strong working knowledge of Office 365 suite of applications.

Selection Plan

**You are encouraged to print this bulletin because it contains important dates and information that will not be available online once this position closes.**

All applicants will be required to submit a resume under the "Resume" tab as part of the online application, as your resume will be reviewed and scored during the testing process.  Please ensure your application contains the required resume prior to submission. 

Applicants who meet the minimum qualifications will be evaluated on the education and work experience in their employment profiles and the responses to their supplemental questions. The highest scoring applicants will then be invited to participate in a Virtual Oral Board Inrterview.

  • Virtual Oral Board Interviews will be held July 13 and July 18, 2022 (as needed)

Upon completion of all examination processes, the highest scoring applicants will be placed on the Civil Service Employment List.  An applicant’s ranking on the Civil Service Employment List will be based on their final score which will be calculated as:

  • 10% of the rating for Education and Work experience
  • 90% of the rating for the Oral Board Interview

This recruitment will establish a civil service list that may be utilized to fill vacancies occurring at Tucson Water within the next 6 months. Hiring interviews maybe conducted post list and prior to final selection.

Veterans, Native American, or Disability preference points will be added to the final score for those that are placed on the Civil Service Employment List.  If you qualify for preference points as outlined in the Employment Profile, you must upload your documentation as part of the application process or email it to Roxie.Escarcega@tucsonaz.gov. The DD 214 must be a copy that indicates characterization of service.  

If you are in need of an Americans with Disabilities Act-related accommodation during the testing process, please contact Roxie Escarcega at Roxie.Escarcega@tucsonaz.gov at least 48 hours prior to the evaluation.

**The City of Tucson values the safety of our employees, our residents, our community, and our visitors.  In support of these values, if you are selected for this job, you must be fully vaccinated against COVID-19, except when vaccination is not medically advised or violates your sincerely held religious beliefs. If you are invited to join our team, you must submit proof that you are fully vaccinated against COVID-19 to your initial HR representative, or you must request an exemption from your representative. New employees must either provide proof of vaccination or be granted a medical or religious exemption before working with the City of Tucson.**

Conclusion

NOTE: Communication during this process will be sent via email to the email address on file, so please ensure your browser accepts emails from jobs@tucsonaz.gov and check your email account regularly; this may include your junk box/spam filter.  Failure to respond or follow instructions may result in disqualification.

Pre-employment Medical Testing Requirements

None

**The City of Tucson values the safety of our employees, our residents, our community, and our visitors.  In support of these values, if you are selected for this job, you must be fully vaccinated against COVID-19, except when vaccination is not medically advised or violates your sincerely held religious beliefs. If you are invited to join our team, you must submit proof that you are fully vaccinated against COVID-19 to your initial HR representative, or you must request an exemption from your representative. New employees must either provide proof of vaccination or be granted a medical or religious exemption before working with the City of Tucson.**

Bulletin Footer

To ensure accurate payroll information for tax purposes, the successful candidate will need to provide their original Social Security Card or original letter from the Social Security Administration with their social security number prior to beginning work with the City of Tucson.

The City of Tucson hires lawful workers only - US citizens or nationals and non-citizens with valid work authorization - without discrimination. Federal immigration laws require all employers to verify both the identity and employment eligibility of all persons hired to work in the United States. In its efforts to meet the law's requirements, the City of Tucson participates in the E-Verify program established by the Department of Homeland Security (DHS) and the Social Security Administration (SSA) to aid employers in verifying the eligibility of workers.

Retired City of Tucson employees receiving benefits from the Tucson Supplemental Retirement System who are considering reemployment with the City should be aware that pursuant to Section 22-37(g) of the Tucson City Code, retirement benefits shall be suspended during the period of reemployment with the City of Tucson unless you have been separated at least twelve consecutive months before returning to work AND you return to a non-permanent employment classification. Creditable service does not accrue during any reemployment period.