IT Analyst - RPU

IT Analyst - RPU Print (Apply IT Analyst - RPU Salary $75,358.00 - $110,822.00 AnnuallyLocation Rochester MN 55906, MNJob TypeRegular FTDepartmentRochester Public UtilitiesJob Number20220045Description Benefits Questions POSITION DESCRIPTIONThe City of Rochester welcomes applications forIT AnalystRochester Public Utilitiesa 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''Our vision is based on six core values which are Safety, Integrity, Service, Stewardship, Accountability, and Skill.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 togetherNature of WorkThis position is responsible for developing, implementing and providing ongoing support for software application systems. Responsibilities include business process analysis; database and application design, implementation and support; data analysis and reporting.Starting SalaryThe 2022 starting salary range is $75,358 to $88,656 with advancement to $110,822. Applications will be accepted until the position is filled.DUTIES AND RESPONSIBILITIESThe 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.*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.Prepare implementation scope, budgets, and timelines based upon detail specifications.*Implement applications.Maintain project management controls to ensure that implementation scope, budgets, and timelines are met.Configure, code, test and debug applications to specifications.Prepare documentation to accurately describe the application and internal process stall 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.*Offer 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 FUNCTIONSMINIMUM QUALIFICATIONSEducation and ExperienceA 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;ORAn 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;ORAn equivalent combination of education and experience sufficient to successfully perform the essential duties of the job may also be considered.Desirable QualificationsExperience in business analysis, project management, and technical training; application design/development, implementation, and support of software applications; database management, data engineering, and data analytics.Experiences in application development in Microsoft Azure, Office 365, Power Platform, SharePoint are highly desirableProgramming languages SQL, Java, JavaScript, Python, R, Power BI/Data Analytics Expression (DAX).Project Management Certification, Microsoft Certification in related areas.ADDITIONAL INFORMATIONKNOWLEDGE, SKILLS AND ABILITIESKnowledge 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 CRITERIAIn 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 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, carryingSensory 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)IT ANALYSTROCHESTER PUBLIC UTILITIESCITY OF ROCHESTEREMPLOYEE BENEFIT AND RETIREMENT SUMMARYBenefits Eligibility: Most employees are eligible for benefits described in this summary if they are classified as a regularly scheduled full-time or part-time employee working at least twenty (20) hours or more per week. All insurance takes effect the first of the month after the start of employment. Many of the plans offer coverage for eligible dependents, including:A spouse Dependent children, including stepchildren, legally adopted children, and children placed with the employee for adoption. The maximum age for dependents is based on the specific benefit.Vacation: Vacation hours will accrue each pay period and can be used as accrued, subject to supervisor approval. Depending on your collective bargaining agreement, employees may not be eleigble to take vacation until after the 6 month probationary period.Holidays: City Offices Closed New Year''s Day Independence Day Day after ThanksgivingMartin Luther King Day Labor Day Christmas Eve - 1/2 Day Presidents'' Day Veteran''s Day Christmas DayMemorial Day Thanksgiving Day New Year''s Eve - 1/2 DaySick Leave: Sick leave is accrued at one (1) day per month worked with no maximum. Sick leave may be used for personal illness, dental and medical care and for serious illness of immediate family.Paydays: The City deposits payroll every other Friday. Insurance premiums are deducted from the first and second payroll checks of each month to pay for the coverage for that month. Retirement savings plan deductions are taken from all 26 pay periods.Health and Dental Insurance: The City offers one self-insured medical plan with two coverage options, the Base Plan Option or the High-Deductible Health Plan (HDHP) Option. Each plan option has four coverage tiers beginning with employee only, employee plus children, employee plus spouse, and family coverage. In addition, eligible preventative services are covered at 100%. Dental Insurance is provided to employees at no cost, and a small cost is incurred for family coverage. Please refer to the chart below for premium information.-Base Plan - Employees carrying single coverage are subject to a $200 deductible. Employees enrolled in any other tier of coverage are subject to a $400 combined family unit deductible. This plan option covers eligible expenses on an 80/20 basis after meeting the deductible amount. Out-of-pocket maximums are $3,000 per person or $6,000 per family. Once meeting the maximum out-of-pocket amount, the plan covers eligible expenses at 100%.-High-Deductible Health Plan (HDHP) - Under this plan option, the City contributes to a Health Savings Account (HSA) for the employee based on the coverage tier selected. Individuals choosing employee-only coverage are subject to a $3,000 deductible. All other coverage tiers are subject to a $6,000 combined family unit deductible. After reaching the deductible amount, eligible expenses are covered at an 80/20 basis until the out-of-pocket maximum of $5,000 per person or $10,000 for all other coverage tiers. Once the maximum out-of-pocket amount is met, eligible expenses are covered at 100%.Flexible Benefits: Employees can set aside pre-tax money from their paycheck for certain eligible expenses. Each year employees determine how much to set aside. The City offers two types of FSA options, the medical FSA, which you can use to reimburse health, dental, vision, and out of pocket health care expenses, and the dependent care FSA.Life Insurance & AD&D Insurance: At no cost to the employee, the City provides eligible employees with basic life insurance and accidental death and dismemberment (AD&D) benefits, an important element of income protection planning. Employees can buy additional supplemental life insurance for themselves, their spouse, and dependent children. As part of this benefit, employees may access travel assistance, health advocacy and elder care or special need services, and alternative legal and financial consultation and referrals.Long Term Disability: Employees may purchase long-term disability benefits, which protects you from loss of income if you are unable to work. Benefits may begin in the fourth month of an eligible disability due to injury or sickness and may continue up to your normal retirement age. You can elect coverage between $500 and $5,000 per month or up to 60% of your base monthly income.Retirement Planning Options: Public Employees Retirement Association (PERA): As a public employee, you will automatically be enrolled in a PERA plan. Under the Coordinated plan, employees contribute 6.5% of their pre-tax earnings, and the City contributes 7.5%. For more detailed plan information, including vesting and retirement benefits, visit PERA at Compensation: As a voluntary retirement program, the City offers several 457(b) IRS qualified deferred compensation retirement savings plans. A 457 retirement plan is a great way to supplement future retirement income by contributing pre-tax or after-tax earnings through automatic payroll contributions. Employees determine how much to contribute and can change this amount monthly. The City offers a choice of three 457 plan vendors: Empower, Mission Square, and Minnesota State Retirement Services (MSRS).Equal Opportunity Employer01 The following supplemental information may be used as a scored evaluation of your knowledge, skills and experience. Be certain that the choices you make correspond to the information you have provided in your application and resume. Please be as honest and as accurate as possible in answering the supplemental questions and do not type ''see resume''. You may be asked to demonstrate your knowledge and skills in a work sample or during an interview for this position. By completing this supplemental questionnaire you are attesting that the information you have provided is true and accurate. Information provided may be reviewed by the hiring manager. Any misstatements or falsification of information may eliminate you from consideration or may result in dismissal. Do you understand and agree with this statement? YesNo02 City of Rochester policy limits certain family and dating relationships in the workplace. While these relationships do not automatically disqualify an applicant from consideration, they may limit the departments where they are eligible to work. For the purposes of this question, the following definitions apply: Immediate Family: A relationship, whether by blood, adoption, marriage or domestic partnership, including: spouse or domestic partner; parent (including foster, or step); children (including adoptive, foster, or step); brother or sister (including in-laws). Extended Family: A relationship, whether by blood, adoption, marriage or domes-tic partnership, including: grandparents and grandchild; aunts and uncles; nieces and nephews; cousins; all other family relationships not included in the definition for Immediate Family Relationship. Personal Relationship: Includes marriage, cohabitation, dating or any other intimate relationship beyond mere friendship. Are you in a personal relationship with, or related to any current City of Rochester employees who work in the department where you are applying? (Select all that apply). Yes, an immediate family member currently works in the department where I am applying.Yes, I am in a committed relationship with someone who currently works in the department where I am applying.No, I am not dating, in a committed relationship with or related to any current City of Rochester employees in the department where I am applying.Unknown, I do not know if any immediate or extended family members currently work in the department where I am applying for employment.03 If you answered ''Yes'' to any of the questions above, please list the City of Rochester employee name(s), their position title(s), and the department(s) where they work, and your relationship to them, (if they are a family member). If you answered ''No'', type ''N/A''. 04 What is your preferred name? 05 Which of the following best describes your level of education? High school diploma or equivalent G.E.D.Less than 2 years post-secondary training including certifications in computer science, computer technology, computer networking, computer/management information systems, or a related fieldCompletion of an accredited 2 year program in computer science, computer technology, computer networking, computer/management information systems, or a closely related fieldCompletion of 4 year degree, or higher, in computer science, computer technology, computer networking, computer/management information systems, or a closely related fieldCompletion of a 2 or 4 year degree in an area NOT related to computer technologyNone of the above06 List the specific degree(s) that you completed or possess. Include the name of the educational facility and location. Do not type ''See Resume''. If no program attended, type ''N/A''. NOTE: if asked to interview or upon hire, proof will be required. 07 Which of the following best describes your years of full-time equivalent employment experience as an IT Analyst? No experienceLess than 6 monthsMore than 6 months, but less than 1 yearMore than 1 year, but less than 2More than 2 years, but less than 3More than 3 years, but less than 4More than 4 years, but less than 5More than 5 years, but less than 6More than 6 years, but less than 7More than 7 years, but less than 8More than 8 years, but less than 9More than 9 years, but less than 1010 or more years08 Does your work experience include any of the following? (Select all that apply) Software developmentSoftware implementationSoftware supportDatabase administrationDatabase design and developmentBusiness analysisProcess improvement/engineeringWorkstation/Server managementHelp desk functionsSolution supportProject managementPrioritizing projects, tasks, timelines and budgetsEvaluating and recommending technology solutionsNegotiating contracts for goods and servicesCyber securityRegulatory complianceNERC compliancePCI complianceN/A - none of the above09 Does your experience include working with any of the following applications? (Select all that apply.) C/C++/CHTMLJavaPythonSQLCongosSAPCayentaPower BITableauESRI ArcGISROtherN/A - None of the above10 If you answered ''Other'' to question number 6, list the specific applications and/or systems that you have worked with. If no experience, type ''N/A''. 11 In detail, describe your employment experience that directly relates or applies to this position, including: The name of your employer(s), Your position title(s) Your duration of employment, The actual duties you performed Your specific experience with regulatory, NERC or PCI compliance, and Your specific experience with any of the applications selected for question 6 Do not type, ''see resume'' or cut and paste from your resume. Type ''N/A'' if you have no experience. 12 Which of the following computer-related certifications/designations do you currently possess: (Select all that apply) Project Management Professional (PMP)CISCO Certified NetworkAssociate(CCNA)Microsoft Certified Database AdministratorSix SigmaMicrosoft Certified Systems Engineer (MCSE)Microsoft Certified Solution DeveloperOther (List/specify below)N/A - I do not possess any computer-related certifications/designations13 Please indicate when you obtained the certifications/designations listed above. If you answered ''Other'' to the above question, list the other specific certifications/designations that you currently possess and when they were obtained. If no experience, type ''N/A''. 14 As far as project management experience, have you led and completed a technology-related project? YesNo15 Please describe one experience in project management. Please include a description of the project, duration of the project, number of people on the team, and the project''s outcome. Do not type ''See Resume''. If no experience, type ''N/A''. 16 Which of the following best describes your employment experience working for a utility company as an employee, subcontractor, independent contractor or consultant: N/A - I have no experience in this areaI have worked for a communications utility companyI have worked for a natural gas utility companyI have worked for a water utility companyI have worked for an electric utility company17 Did your experience working for a utility company, as an employee, subcontractor, independent contractor or consultant, include maintaining cyber security compliance as required by the North American Electric Reliability Corporation (NERC)? YesNo18 Which of the following best describes your years of fulltime employment experience working for a utility company as an employee, subcontractor, independent contractor or consultant: No experienceLess than 1 yearMore than 1 year, but less than 3More than 3 years, but less than 5More than 5 years, but less than 7More than 7 years, but less than 10More than 10 years19 Describe your experience with a utility company as an employee, subcontractor, independent contractor or consultant. Please include the utility name, size of the utility (i.e. number of customers and/or meter units), duration of employment and description of actual duties performed, including any NERC compliance. Do not type ''See Resume''. If no experience, type ''N/A''. 20 Do you have a valid driver''s license or valid driving privileges? YesNo21 OTHER QUALIFICATIONS: Describe any other special training you''ve completed or skills and experience you currently possess that you feel would make you the best-qualified person for this position. 22 CONDITIONS OF EMPLOYMENT: If selected as a finalist, are you willing to undergo a background investigation which may include, but not limited to: verification of employment and educational records, identification verification, driver''s license record and a criminal history? YesNoRequired Question AgencyCity of RochesterAddress201 4th Street SE Rochester, Minnesota, 55904 Phone(507) 328-2555 WebsiteApply Please verify your email address Verify Email

Created: 2025-10-04