Administrative Special Services Staff II - Application Analyst (TASS)

This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates.

Applicants for open positions at the Detroit Water and Sewerage Department must be authorized to work for ANY employer in the U.S. The Detroit Water and Sewerage Department is unable to sponsor or take over sponsorship of an employment Visa at this time. 

SUMMARY:
The Applications Analyst plans, designs, configures, develops, and implements new applications and application enhancements and supports existing applications.

ESSENTIAL JOB FUNCTIONS:
Meet with customers to define business requirements, applications and systems goals, and to identify and resolve applications and systems issues. Review and analyze the effectiveness and efficiency of existing applications and systems, and develop strategies for improving or further leveraging these applications and systems. Assist in the deployment of new applications and in delivering enhancements to existing applications.

Perform application design, configuration, and integration. Able to develop and maintain programs written in common programming languages including stored procedures and web services. Conduct cost-benefit and return on investment analyses for applications and systems in order to aid management in making acquisition and implementation decisions. Coordinate and perform tests for existing and new applications, including user acceptance tests. Provide training to end users.

Identify potential risks and dependencies between applications, systems and business processes and provide solutions, impacts and recommendations to resolve conflicts if they should arise. Develop application prototypes and mockups to present to the project user group in an effort to collect functional clarifications and requirements. Plan, design, and implement additions, upgrades, replacements, or retirement of applications including the database management environment on the Web to support the capacity to store a substantial amount of data. A valid Michigan Driver's License and the ability to drive a motor vehicle on all terrain. Follow security and safety policies and procedures in carrying out work duties. Provide on the job training.


Examples of Duties
Assist other IT staff and IT management as needed with overflow activities involving the support and maintenance of computers, printers, applications, databases, networks, servers, storage, and data center facilities, and the installation, decommissioning, and relocation of related IT equipment. Perform related work duties as assigned.

SKILL TO:
•    Independently, and as part of a team providing timely, high quality customer-focused services
•    Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
•    Work in a professional manner with access to confidential and other data types
•    Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
•    Work in a team environment that provides the capacity for IT project delivery
•    Resolve technology and user issues both verbally and in writing to end-users of varying computing skills
•    Deliver quality written and presentations, including the ability to make technology understandable to end-users
•    Understand and translate the needs of varied users into IT system requirements
•    Use advanced technology

ABILITY TO:
•    Organize, perform and or coordinate technology tasks and projects
•    Install, remove, and make modifications to technology
•    Instruct groups or individuals on technology
•    Deliver quality customer service to users
•    Write technical and non-technical documentation
•    Interact and communicate with IT staff and business users
•    Apply IT policies and programs in a manner aligned with the Department mission, goals, and strategies
•    Learn new application software packages, operating systems, and IT processes and procedures
•    Effectively utilize appropriate security and safety equipment and procedures
•    Communicate effectively, both verbally and in writing
•    Understand and follow verbal and written instructions
•    Establish and maintain effective working relationships with others
•    Communicate frequently with team members and other units across the Department about process, equipment or potential problems
•    Develop proficiency in unit specific operations and software
•    Direct team activities or to work as a team member
•    Maintain regular and reliable attendance
•    Consult, coordinate and communicate with business units and IT staff to refine business requirements into tangible, functional requirements and technical specifications that both business and IT staff are able to interpret
•    Responsible for capacity planning and management, security planning and management, data management, systems maintenance, and performance management of one or more systems
•    Plan, design, and implement IT-related policies and procedures
•    Participate in information technology planning for hardware, software, and infrastructure
•    Coordinate with staff in various areas in different roles (application, project and technical management) developing different components of the functional design and requirements
•    Provide solutions and recommendations which integrate with current and future database, application, and infrastructure architectures
•    Identify potential risks and dependencies between applications, systems and business processes and provides solutions, impacts and recommendations to resolve conflicts if they should arise
•    Demonstrate ability to compose and provide project and technical documentation, including functional requirements and use cases, and technical specifications
•    Develop application prototypes and mockups to present to the project user group in an effort to collect functional clarifications and requirements
•    Provide production support for new and existing applications/interfaces.
•    Provide technical support resolving incidents, and creating / closing tickets
•    Maintain working knowledge of current industry information, vendor direction, new and emerging products, and technical architectures and approaches related to current and future organizational need
•    Plan, design, and implement additions, upgrades, replacements, or retirement of applications including the database management environment on the Web to support the capacity to store a substantial amount of dataMinimum Qualifications
REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)
• Bachelor's Degree in Computer Science, Information Technology or related field
•    Three (3) to five (5) years of related work experience; or combination of related work experience and education
•    Valid Michigan Driver's License
•    Ability to work irregular hours, commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responsesSupplemental Information

Business Systems:

• Advanced configuration and support of core software platform (ERP, CMMS, CIS, etc.)

Web Systems:

• Design, implement, layout, code, and update websites
• Programming
• Process Improvement of Search Engine Optimization

Enterprise Reporting:

• Dashboard and Business Intelligence
• Reporting and Analytics

Enterprise Content Management:

• Analyze, design, and support Data Capture and ECM applications
• Imaging Technologies

Business Process Integration:
•    Develop, configure, test, and deploy data integrations
•    Knowledge of SQL and API preferred (this is particularly for Applications Analyst-Integration)