General Summary

Provides support to credit union business units through analysis of software applications to identify areas for development and changes; performs database design, program design coding and other programming tasks based on findings; and, identifies new applications to meet the needs of the business units. Provides support to Help Desk Technical Support Specialist by acting as Tier 3 support for all credit union systems and applications. Possess the skills and knowledge required to independently resolve complex issues, inquiries, and requests.

Principal Accountabilities (95%)

• Is involved with all phases of software development from concept to implementation.
• Acts as Programming Lead for small, mid, and large scale projects.
• Completes research, trouble-shoots and resolves complex issues relating to software applications.
• Provides support to all credit union applications.
• Develops, enhances and documents current reporting architecture.
• Works in conjunction with other members of the IT Team to understand functionality, scalability, performance, security and integration requirements from a programming and reporting perspective. Translates requirements into functional, scalable and reusable components for application development framework.
• Gathers application requirements from business unit owners to ensure alignment of application performance and business goals. Develops and maintains programs and processes for business units.
• Documents procedures and operational methods for software developed and/or enhanced; provides input to assist with instructing use of updated and/or new software.
• Assists other members of the programming team; shares knowledge and best practices. Provides enterprise-wide programming services through software research, analysis, and development. Meets, reviews and completes software programming based on business unit specifications. Enhances application usability, effectiveness, and integration.
• Completes full cycle of programming tasks from conception to implementation, including coding, testing, debugging, and documentation.
• Provides database support to Core System (OSI/DNA) through physical changes from the backend; development of data-load programs; and ad-hoc database programming only when native DNA or DNA Apps are not available.
• Follow Agile standards and utilize the Jira platform for tracking and Confluence for Documentation
• Act as the liaison between business owners and IT on key projects relating to software applications that have significant impact to internal applications and member service.
• Ability to compose effective updates to outside vendors, internal staff and/or executive staff.
• Serves as the subject-matter expert for assigned areas of responsibility.

Secondary Accountabilities (5%)

• Participates in special projects to include testing, analysis and integration of internal systems and applications.
• Performs other duties as assigned.
• Complies with BSA requirements as commensurate with position.

Position Requirement and Qualifications

Abilities:

• Excellent abilities in analysis, problem-solving, technical skills, organization, process management, time-management, customer service and creativity.
• Working knowledge of information security principles and practices, including access controls, incident response, penetration testing, security technologies, security monitoring, industry-related regulations and compliance with information security and data encryption.
• Strong working knowledge of core-system batch job and reporting functions.
• Must be able to identify core-system processing issues and complete basic diagnostics
• Must be able to troubleshoot, install, connect, configure, upgrade, diagnose and remedy hardware and software issues for various technology devices.
• Must have excellent skills in the following: communication, research, analysis, problem-solving, team work and time management.
• Must be able to work with all levels within the organization and to relay technical information in an easy-to-understand manner.
• Must adhere to established SLAs and other service standards as established by management.
• Must exhibit a commitment to maintaining established uptime standards.
• Must be available to respond to alerts, notifications, or other communications regarding downtime or disaster situations that may require your intervention or participation outside of scheduled working hours.

Skills, Knowledge, Education, Certifications, Licenses:

• In-depth knowledge of programming languages, troubleshooting techniques, business rules for financial institution relating to compliance or equivalent, products and services, and database programming.
• Advanced SQR Workbench skills for report development, debugging, optimization, file processing, batch automation, and output formatting.
• Strong Oracle SQL skills, including complex queries, safe data updates, performance tuning, and data transformation.
• PL/SQL development skills for stored procedures, functions, packages, exception handling, and auditing
• A degree in Computer Science, Information Systems, Information Engineering or equivalent work experience required. Applicable certifications preferred.

Experience:

Requires a minimum of five to seven years of work experience as a programmer-analyst at the senior level and in a comparable environment to gain the necessary knowledge, skills and abilities to fulfill all aspects of the position. Financial institution experience desired.

Working Conditions and Physical Demands

Work is performed in a general office environment. This position does not require significant physical efforts. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job. Refer to the Safety & Health Policy found in North Island Credit Union’s Employee Handbook & Resource Guide.