Applications System Analyst I or II

Description

Job Purpose

Responsible for database administration and analysis providing maintenance and supplemental development including the determination of end-user requirements and instruction on end-product use. Provide solutions to data integration needs across platforms. Maintain, modify, and extract data from various databases using a variety of report-writing tools. Level I and II are differentiated by overall knowledge, skill level, and a demonstrated ability effectively manage and administrate the specific applications in use throughout MPW, as well as the ability of the Level II to train and mentor less senior level I department members.

Specific Responsibilities

1. Responsible for assigned MS SQL Server database administration and development, including configurations, performance monitoring, data transformation services, backup and recovery, security, and stored procedures. Develop and maintain various applications and related databases with full life cycle responsibility, including data integration. This includes:
   1. Support database performance by managing, monitoring, and maintaining Utility databases; evaluating and resolving processing and programming problems; utilizing database management tools; and answering user questions.
   2. Ensure Utility database integrity, stability, and system availability; implement data models, database designs, data access, and table maintenance codes.
   3. Level II - Assess database performance by developing a protocol for measurement of results and identification of problem areas. Resolve database performance and capacity, replication, or other distributed data issues.
   4. Eliminate data redundancies.
   5. Maintain database backup and recovery processes.
   6. Level II - Plan database upgrades by maintaining, evaluating, and improving processing models.
   7. Make requested changes, updates, and modifications to database structure and data.
2. Maintain, modify, and extract data from databases using various report-writing tools. This includes:
   1. Develop automated and reusable routines for extracting requested information from databases systems; compile detailed reports using data reporting tools such as Power BI.
   2. Level II - Prepare technical reports by collecting, analyzing, and summarizing information and trends using data from multiple internal and external sources.
3. Work with Utility end users to clarify and evaluate current operating procedures and/or problems, analyze system hardware and software to develop technical solutions.
   1. Prepare detailed documentation by translating user and/or system requirements into functional technical specifications.
   2. Collaborate with various functional teams to achieve business results.
   3. Analyze complex business problems and assess how automated systems can be implemented to solve them; develop solutions by preparing and evaluating alternative workflow solutions.
   4. Contribute expertise to applications and technical support teams.
4. Install, encode, test, and debug applications as necessary.
5. Recommend system changes and enhancements.
6. Maintain documentation through standard operating procedures, documented data elements, data flow, relationships, and dependencies for new and modified systems.

Other Responsibilities

1. Research and recommend programming and end-user tools that will assist in database and report development and data reporting.
2. Preserve the integrity of all IT files through effective program development techniques.
3. Other duties as assigned.

Position Requirements

Qualifications

Knowledge

1. Bachelor's degree in information technology, business systems, or related field or equivalent combination of education and experience.
2. Minimum 3 years (Level I) or 5 years (Level II) of IT experience in a client/server environment, including application analysis, development, and administration.
3. Minimum 3 years (Level I) or 5 years (Level II) of experience in an ERP administrative role. Experience with Finance and Customer Information System applications preferred.
4. Working knowledge (Level I) or proven expertise (Level II) in MS SQL database design, development of stored procedures, jobs, and maintenance of databases.
5. Must have development skills in SharePoint, SQL Server, Crystal Reports, and Power BI.
6. Level II - Must have SQL Server Report Services (SSRS) experience.
7. Must be familiar with ODBC, Java Script, and HTML.

Skills

1. Excellent verbal and written communication skills.
2. Excellent interpersonal and listening skills, with ability to build productive professional relationships and promote a team atmosphere.
3. Proficiency with use of Microsoft Office Suite at an intermediate level.
4. Good judgment and reasoning skills.
5. Problem identification, analysis, and solving.

Abilities

1. Ability to work as part of a team, either as team leader or a member of a team.
2. Ability to think strategically but also focus on tactical and operational issues.
3. Ability to drive results and ensure work is accomplished properly, safely, and in a timely manner.
4. Ability to work independently, effectively prioritize work, manage multiple tasks, meet deadlines, and adjust work priorities as needed to meet department/organizational objectives.
5. Ability to use discretion in maintaining confidentiality and handling sensitive information.

Other Position Requirements

1. Must be able to attend work on a regular basis and work extended hours as needed.
2. Must maintain a method of communication in order to be contacted by MPW outside normal work hours.

Work Environment

1. Work environment is primarily in an office environment.
2. Must comply with all safety and site rules at all locations.

Full-Time/Part-Time
Full-Time

Salary
Applications System Analyst I $71,000 - $84,000; Applications System Analyst II $82,000 - $98,000 Depending on Qualifications

Number of Openings
1

Location
Administration and Operations Center

EOE Statement
Don't meet every single requirement? Studies have shown that diverse candidates are less likely to apply to jobs unless they meet every single qualification. At Muscatine Power and Water, we are dedicated to building a diverse, inclusive, and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

MPW is an Equal Opportunity Employer. The Utility does not discriminate in its hiring or employment practices, and all qualified applicants will receive consideration for employment without regard to race, creed, color, sex, affectional or sexual orientation, gender, gender identity or expression, ethnicity, religion, national origin, ancestry, nationality, age, disability, marital status, veteran status, genetic information, or on any other basis prohibited by federal, state, or local law (except where an attribute is a bona fide occupational qualification). EOE M/F/D/V

This position is currently accepting applications.