SYSTEMS PROGRAMMER ANALYST (DOQ)

Under general direction and working in an integrated computer network environment, performs a full range of programming and analytical functions in software development and maintenance for the financial, operations, and administrative systems and in-house applications and integrations in support of enterprise operations. Responsibilities Systems Programmer Analyst Analyzes users' needs and designs, constructs, tests, and maintains computer application software, systems, reports, and/or interfaces to support users' applications and tasks. Assists as required in the solution of operational difficulties encountered in executing programs. Takes action to improve program performance or to correct deficiencies. Prepares the required logical interface between related programs. Completes all programming tasks required to implement changes, including testing, and updating of documentation. Prepares all elements of application testing, which includes program documentation, execute, coordinate program testing and assess quality assurance. Analyzes program performance during testing and design conversion procedures and takes action to improve deficiencies to ensure that the program functions effectively. Prepares training material and trains operators and/or program users. Researches technical reports, manuals, and other documentation to expand knowledge and skills that will be used to develop programs to better meet user requirements. Formulates plans outlining steps required to develop applications using structured analysis and design. Completes other job duties as assigned. Senior Systems Programmer Analyst (in addition to duties listed above) May provide guidance and direction to less experienced or entry level staff. Conducts technical planning, research, and analysis to identify deficiencies and opportunities for the automation of business processes or other integrations. Coordinates the development and execution of integrations using planned approaches to provide expertise options and recommendations. Oversees the implementation of new technologies and ensures alignment with organizational goals. Collaborates with cross-functional teams to ensure seamless integration of new systems. Lead Systems Programmer Analyst (in addition to all duties listed above) Provides leadership, training, and guidance, to less experienced staff. May assume the duties of the supervisor/manager in their absence. Leads the development and deployment of integration projects and ensures adherence to best practices and standards by providing leadership and guidance. Supports and leads integration projects and corresponding strategies between business units and development teams to coordinate efforts and ensure alignment of technology solution with business needs. Develops and enforces coding standards and best practices within the team. Manages project timelines and ensures deliverables are met on schedule., Must currently possess database SQL certification such as Oracle DB SQL Certified Associate, Azure Database Administrator Associate or equivalent and Developer certification such as Azure Developer Associate, JavaScript Developer Associate or equivalent. Lead Systems Programmer Analyst (in addition to all licenses/certifications listed above) Must currently possess a Database Foundations certification such as Oracle Database Foundations Associate, Azure Database Administrator Associate or equivalent and Node.js Developer & Angular Certification or equivalent. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Limited amount of physical effort is required and is associated with walking, lifting and carrying light objects (less than 25 lbs.). Eligibility for Employment In addition to any and all other qualifications required for employment stated under the Brownsville P.U.B Personnel Policies and Procedures Policy No. 39:

• Prohibit the hiring of any person who is related to BPUB Executive Management within the third degree of Consanguinity or second degree by Affinity; and

• Based on certain prohibitions of the Charter and Statute on nepotism, no person can be hired who shall be related to any member of the Board of Directors or City Commission within the third degree of consanguinity or second degree by affinity.

Knowledge of Windows and Linux operating systems, Oracle, and SQL databases. Knowledge in multiple programming languages such as .NET, Python, Java, and SQL. Knowledge of internet technologies including IIS, NGINIX, and REST & SOAP web services. Knowledge of open-source full stack technologies such as React/Angular, Node.js, Express, and MongoDB (NoSQL). Knowledge of Azure Cloud services for deploying web app solutions and APIs to the cloud. Knowledge of business intelligence (BI) and data visualization tools used for reporting and dashboard creation. Knowledge of version control systems and project management tools. Knowledge of business principles. Strong problem-solving and analytical skills to design new functional software programs. Strong communication, teamwork, and time management skills. Strong oral and written communication skills in English. Ability to work under pressure, make decisions, set priorities, and meet deadlines. Ability to establish and maintain effective working relationships with others. Ability to work evenings and weekends in response to needs of the systems being supported. Ability to remain on call or standby for a reasonable period of time and to adhere to an on-call schedule. Must be able to maintain confidentiality with regard to the information being processed, stored, or accessed by the network. Education & Experience Requirements Bachelor's degree from an accredited four-year college or university with major course work in Computer Science, or a closely related field. One (1) year of programming experience is required. An equivalent combination of appropriate education and relevant experience may substitute for the minimum experience requirement. Senior Systems Programmer Analyst Three (3) additional year of experience is required. Lead Systems Programmer Analyst Five (5) additional years of progressively responsible experience are required. Certificates, Licenses, Registrations A valid Texas Driver License or receipt of a valid Texas Driver's License within 90 days of relocation to Texas and a safe driving record, as measured by company policy.