Applications System Analyst I or II

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

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

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

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

Other Responsibilities