What are the responsibilities and job description for the Applications System Analyst I or II position at Muscatine Power and Water?
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
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
- 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:
- 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.
- Ensure Utility database integrity, stability, and system availability; implement data models, database designs, data access, and table maintenance codes.
- 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.
- Eliminate data redundancies.
- Maintain database backup and recovery processes.
- Level II - Plan database upgrades by maintaining, evaluating, and improving processing models.
- Make requested changes, updates, and modifications to database structure and data.
- Maintain, modify, and extract data from databases using various report-writing tools. This includes:
- Develop automated and reusable routines for extracting requested information from databases systems; compile detailed reports using data reporting tools such as Power BI.
- Level II - Prepare technical reports by collecting, analyzing, and summarizing information and trends using data from multiple internal and external sources.
- Work with Utility end users to clarify and evaluate current operating procedures and/or problems, analyze system hardware and software to develop technical solutions.
- Prepare detailed documentation by translating user and/or system requirements into functional technical specifications.
- Collaborate with various functional teams to achieve business results.
- Analyze complex business problems and assess how automated systems can be implemented to solve them; develop solutions by preparing and evaluating alternative workflow solutions.
- Contribute expertise to applications and technical support teams.
- Install, encode, test, and debug applications as necessary.
- Recommend system changes and enhancements.
- Maintain documentation through standard operating procedures, documented data elements, data flow, relationships, and dependencies for new and modified systems.
- Research and recommend programming and end-user tools that will assist in database and report development and data reporting.
- Preserve the integrity of all IT files through effective program development techniques.
- Other duties as assigned.
