IT Analyst - RPU

POSITION DESCRIPTION The City of Rochester welcomes applications for IT Analyst Rochester Public Utilities RPU, a division of the City of Rochester, MN, is the largest municipal utility in the State of Minnesota.
RPU serves over 57,000 electric customers and 41,000 water customers in a 60 square mile service area and has revenues nearing $161 million annually.
Vision- "We Will Set the Standard for Service" www.
rpu.
org The City of Rochester is committed to a community where all members feel a sense of belonging.
We commit to recognizing the diversity of our community members, listening to ALL voices and providing equitable services to create an inclusive place to live, play and work.
We believe EQUITY should be at the center of all our work.
We strive to represent our community in our teammates, as we know that diverse and inclusive teams are more innovative, and have an empowering impact on the work, progress and culture of our community.
It takes us all working together Nature of Work This position is responsible for developing, implementing and supporting software application systems.
Responsibilities include business process analysis; project management; software application design, implementation and support; data analysis and reporting.
Pay The 2024 starting salary range is $79,171 to $93,142 with advancement to $116,429.
Application review will begin on February 5th, 2024.
Applications will be accepted until the position is filled.
DUTIES AND RESPONSIBILITIES The work below is representative of the scope of work performed within this job classification.
Individual job duties will vary based on work assignment.
*Work closely with stakeholders to understand, document and communicate requirements and expectations.
Work effectively with users to ensure that open communications are maintained.
Provide guidance regarding business process and technical feasibility.
Provide ongoing status reports to users to ensure that user expectations are being met.
*Manage projects effectively following IT Project Management requirements and best practices.
Lead and participate in projects throughout the organization.
Effectively plan, execute, and close projects to successful outcome.
Effectively document, update and report throughout the project lifecycles, including project definition, scope, deliverables, budget, timeline, work breakdown structure, risks, constraints.
Facilitate communications throughout the project lifecycles, e.
g.
, meetings, updates, schedules, charts, reports, etc.
*Design applications and solutions.
Review and analyze business processes.
Provide recommendations based on research and applications knowledge that will improve the effectiveness, efficiency, and security of the business process in alignment with customer requirements and expectations.
Identify guidelines to be used for preparing specifications and implementation schedules.
*Prepare specifications and implementation.
Prepare specifications for presentation and output, workflow, business rules and data management based upon the design guidelines.
Ensure that specifications meet internal standards and user approval.
*Implement applications.
Configure, code, test and debug applications to specifications.
Prepare documentation to accurately describe the application and internal process flow.
Install applications and ensures that they interact properly with existing applications.
Develop and provide training to users as required.
Provide maintenance support.
Troubleshoot processing problems and recommend appropriate solutions independently or with service providers as needed.
Enhance applications to conform to changing requirements.
Support ongoing maintenance and upgrades as needed.
*Data analysis and reporting.
Design, develop, implement and maintain databases/data systems; ETL (Extract, Transform, and Load) systems and processes to support operational and analytical applications.
Acquire, wrangle, and analyze data using statistical techniques and tools.
Identify and interpret trends or patterns in data sets.
Work closely with users to develop, implement and provide the on-going support for queries, reports and dashboards.
Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
*Understand the current operating environment and work effectively with development tools.
Stay abreast of changes in the industry and provide recommendations to improve the performance and utilization of information system resources.
Perform other duties as assigned or necessary.
*ESSENTIAL FUNCTIONS MINIMUM QUALIFICATIONS Education and Experience A Bachelor's degree in computer science or closely related field from an accredited four-year college or university AND one (1) year of full-time employment experience; OR An Associate's degree in computer science or closely related field from an accredited post-secondary program AND five (5) years of full-time employment experience; OR An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may also be considered.
Desirable Qualifications Experience in business analysis, project management, and technical training; application development, implementation, and support; database management, data engineering, and data analytics.
Project Management Certification Experiences in application development in Microsoft Azure, Office 365, Power Platform, SharePoint SQL, Java, JavaScript, Python, Data Analytics Expression (DAX).
ADDITIONAL INFORMATION KNOWLEDGE, SKILLS AND ABILITIES Knowledge of: business principles and analysis, systems analysis, design and implementation, database design, queries, and reporting, data analytics and visualization, compatible software application tools, programming languages, computer hardware and operating systems; compatible network and workstation equipment and operating software.
Skill in: working with development tools; communicating effectively in both written and verbal formats; being well organized; relating interpersonally with others; web development, Java, JavaScript, Python, database development, report writing; SQL Reporting Services, SSIS, Team foundation server source control, HTML 5, Graphic Arts, Object oriented programming and mobile application development; application design, system analysis; and project management.
Ability to: analyze business processes and application system technical problems and develop satisfactory solutions; develop multi-tiered applications; work collaboratively with others, establish and maintain effective working relationships; create and maintain appropriate documentation; have a strong focus on customer service; entertain be curiosity and be willing to learn new information.
PHYSICAL AND ENVIRONMENTAL CRITERIA In compliance with the Americans with Disabilities Act, the following represents the physical and environmental demands for this position.
The employee must be able to perform the essential functions with or without accommodation.
In consideration of the overall amount of physical effort required to perform this position, the work is best described as Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
Sedentary work involves sitting most of the time.
Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Physical demands that may be required continuously (2/3 or more of the time), frequently (1/3 to 2/3 of the time), and occasionally (up to 1/3 of the time) are noted below: Continuous demands: sitting, fine dexterity, Occasional demands: standing, walking, reaching, handling, lifting, carrying Sensory requirements necessary in the performance of the essential functions of this position include: sight, hearing, and touch.
Environmental conditions that may exist in the performance of the essential functions of this job include: NONE (not substantially exposed to environmental conditions)