BUSINESS ANALYST II

Recruitment #2309-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 current systems implementation team at the Tucson Water Department. This position resides within the Customer Service Division and will provide technical support during and after the implementation of 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 position has a unique opportunity to join the implementation team to gain first-hand knowledge and experience from the software solution architects. Long term this this will turn into a support-based role for the ongoing needs and requirements of the user base by providing technical assistance to end users, updating/maintaining testing and training materials, system related documentation and data reporting for business analytics 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.    

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

General Description

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

Essential Functions

Manages enterprise transactional based applications and relational databases.

Develops system integration strategies.

Analyzes and modifies XML and JSON structures/XSLT programming.

Serves as technical lead on software 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 CIS modules and systems.

 

Performs maintenance and makes modifications to the systems web based dynamic customer portal. 

 

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 CIS 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

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


*Any combination of relevant education and experience may be substituted on a year-for-year basis.

Preferred Qualifications

Developer skills with a curious and innovative attitude and the desire to constantly look for ways to improve processes to resolve business issues.

Experience with web technologies and Web API, to using ASP.NET MVC pattern, VB.NET, C#, HTML.

Knowledge of transactional programming using Extensible Markup Language (XML) and JavaScript Object Notation (JSON) structures. 

Extensive knowledge of Visual Studio.

Experience with database technologies, predominantly Structured Query Language (SQL) server.

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

A strong working knowledge of Business Intelligence software, e.g., Birst, Cognos, Tableau, Power BI, Qlik, Crystal Reports. 

A strong working knowledge of Office 365 suite applications.

Strong written and oral communication skills and the ability to convey complex technical material to non-technical users in a friendly manner.

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 an Oral Board Interview.

  • Panel interview will be held October 24, 2023

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 panel 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 Ashley.Tellez@tucsonaz.govThe 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 Ashley Tellez at Ashley.Tellez @tucsonaz.gov at least 48 hours prior to the evaluation.

    Pre-employment Medical Testing Requirements

    None

    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.