TUCSON WATER BUSINESS ANALYST II

 

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

Tucson Water's Enterprise Asset Management (EAM) is seeking an enthusiastic and motivated individual to join our team. The EAM team is currently working to migrate from Oracle WAM to Infor EAM and to implement the recommendations related to EAM set out in the recent Information Technology Business Operation Plan (ITBOP) effort. This is an exciting time for Water and the successful candidate will have an opportunity to help set the future direction of technology at Tucson Water.

A senior level or lead position within the Business Analyst structure. This position leverages the return on enterprise level systems by providing technical support to analyze business processes and technology requirements.

• Serves as technical lead for implementations, maintenance, and upgrades on enterprise level applications. 
• 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 enterprise level applications.
• 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 enterprise level applications.  
• 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 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.

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

• A strong 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.

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 Writing Exercise.

• Writing Exercise will be emailed no later than 4:00 pm (Tucson time) on July 16, 2021
• Deadline to return completed assignment is 12:00 pm (Tucson time) on July 19, 2021 

The highest scoring applicants will then be invited to participate in a Virtual Teams Oral Board Interview.

• Virtual Oral Board Interviews will be held the week of July 26, 2021

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 
• 40% of the rating for Writing Exercise 
• 50% 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.

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

Additionally, 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.

None

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.