Information Systems Specialist III - Sr. Applications Developer

Characteristics of the Class

Under general direction, performs a variety of advanced technical duties in the design, development, administration, security, and quality control of the Authority’s databases and business applications; develops and maintains procedures and application solutions for multiple functional areas on multiple databases and systems; performs project feasibility research; serves as project leader and provides work direction and guidance to other developers; and performs related duties as assigned.

Essential Functions

• Consults with users of the Agency to identify business and technology needs;
• Leads the execution of systems analysis, design, and programming to develop and maintain data and application systems that meet Agency needs;
• Develops custom queries and reports to meet user and/or business requirements;
• Analyzes system data, system processes, and system interactions, to identify and evaluate impacts of maintenance and changes to ongoing production, methods for accessing, using and/or migrating data, alternatives for establishing interfaces or interoperations with applications utilizing newer hardware, software, communication technologies, and conversion of legacy systems to new technologies;
• Utilizes system analysis business requirements as the basis for the development and documentation of design specifications for business applications and reporting/analytics platforms;
• Defines scope, boundaries, and deliverables for assigned application development projects to meet user data requirements; Identifies data sources and analyzes systems interface requirements for accessing and using enterprise data; Coordinates the exchange of data with other entities and the integration and migration of data between databases;
• Maintains and updates applications data dictionary; Tests data validity, redundancy, and integrity;
• Led IT staff to identify, recommend, evaluate, and document improvements to modify, enhance, develop, or purchase new specialized systems, subsystems, technology alternatives, hardware, network and/or software characteristics and requirements that are significant in complexity and impact that would best deliver the technical solution that meets user/business requirements; when necessary, participates in selecting vendors and consultant/contractor staff; assists in managing and administering development/vendor contracts;
• Analyses and troubleshoots functional and technical problems; Researches enterprise system and interface documentation; Identifies errors and works with other technical staff, vendor representatives, and users to make changes to solve problems; Serves as a technical resource to Authority users and other technical staff for the enterprise system.

Knowledge, Abilities, and Skills

• Advanced principles and methods of systems analysis, including business process and entity relationship analysis tools and methods;
• Software engineering principles and practices for the full Software Development Life Cycle, including coding standards, code reviews, source control management, build processes, testing and operations;
• Standard database software and general database structure and administration;
• Functions, capabilities, characteristics and limitations of standard platforms, operating system software and devices;
• Programming theory, applicable programming languages and software development and maintenance tools and utilities;
• Systems integration design concepts, methods, and practices;
• Relational database theory, concepts, architectures, design rules, and development practices, including data modeling, data flow and entity relationship analysis, data structure analysis, data access methods and database recovery techniques;
• Advanced network architecture, design concepts, system design principles, and applications development methodologies;
• Methods and techniques of troubleshooting applications, network and database-related problems;
• Website development and maintenance technologies and web- or mobile-enabled application design;
• Project management tools and techniques, including preparation and management of detailed project schedules and metrics and change management and control;
• Current industry standards related to areas of responsibility.

Minimum Qualifications

• Graduation from an accredited college or university with a Bachelors or Masters Degree major related to Management Information Systems, Information Technology, Computer Science or a closely related field -AND- ten (10) years progressively responsible experience with cloud platforms (e.g., Azure, AWS), DevOps practices, systems analysis, applications design, and development including project lead responsibilities -OR-
• A combination of education, training, and experience which demonstrates the ability to perform the duties of the position.