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.
EXAMPLES OF ESSENTIAL FUNCTIONS – Essential responsibilities and duties may include, but are not limited to, the following:
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.
Leads 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;
Analyzes 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.
Creates software design models and selects technical standards including coding standards, tools and platforms; Writes program code to extend system functionality, using appropriate software development tools and programming languages; designs menus, screens, and reports; designs and codes mobile and web-enabled applications; designs and codes interfaces to vendor software programs; Establishes applications security protocols and privileges; Performs maintenance, performance tuning, and recovery on applications databases.
Ensure code quality, security, and compliance with best practices and troubleshoot and resolve technical issues in a timely manner.
Stays informed of industry trends and maintains up-to-date technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, and participating in professional associations.
Develops user and application documentation including training guides and training processes; Provides application production and user support for enterprise systems and other assigned applications.
Provides daily project work instructions, direction, and technical guidance to project team members and less experienced staff; trains new employees on system and software standards and requirements.
Collaborate with cross-functional teams to gather requirements and deliver scalable solutions.
Performs other related duties as required.
KNOWLEDGE, ABILITIES, AND SKILLS:
Knowledge of: