JOB FUNCTION / SUMMARY:

Provides technical direction and support in developing business systems software and procedures; Responsible for analysis, design, programming, and implementation of complex programming projects involving a sizable group of users by performing the following duties. This job may be a specialist in one (or more) of three areas. Please see the “Specialties” section for specifics.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Plans and conducts analyses of complex and unique business systems projects
• Devise new sources of data and develops new approaches and techniques for use by others
• Conducts reviews of computer technology developments applicable to systems design and prepares long range forecasts
• Studies broad areas of work processes that cut across organizational information systems
• Acts as an internal consultant providing technical guidance on business systems projects
• Determines and resolves problems with other systems analysts, programmers, and systems users
• Maintains, develops, modifies, and documents programs according to general specifications and guidelines
• Provides guidance to lower-level programmers and systems specialists

Secondary Duties

• Consults with managerial and systems analysis personnel to clarify program intent, identify problems, suggest changes and determine extent of programming and coding required
• Revises or directs revision of existing programs to increase operating efficiency or adapt to new requirements
• Trains entry level coworkers in programming and program coding
• Consults with internal clients to analyze and understand functions to be automated, client needs, objectives, desired features and input and output requirements
• Analyzes, defines and documents system requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls and outputs
• Researches and evaluates software and hardware to assist in programming or to use as program platforms

Specialties:

A. Web Specialist

• .Net, SharePoint, HTML, java script, VB script
• Ability to create and modify graphics in Photoshop
• Fundamental PC knowledge and navigation
• Visual Basic a plus
• Argo a plus
• Crystal a plus
• Asp.net and J# and C# a plus
• Knowledge of relational databases using SQL language and ODBC connectivity a plus

B. Core Banking Systems Specialist

• COBOL
• CA-Easytrieve
• JCL
• CICS
• TSO/ISPF
• VSAM
• Fidelity Banking Applications a plus
• API and RPI a plus
• CICS COBOL a plus
• Assembler a plus

C. Electronic Delivery Specialist

• COBOL
• CA-Easytrieve
• JCL
• CICS
• TSO/ISPF
• VSAM
• Networking
• Server a plus
• Tandem a plus

D. Data Architect

• TSQL
• MDX
• Microsoft SQL Server
• OLAP cubes (SSAS)
• Microsoft SSAS, SSIS, and SSRS
• SharePoint dashboards, KPIs, and scorecards
• Data warehousing and data modeling
• OLTP & OLAP databases
• Advanced SQL development skills
• VB.Net/C#
• SQL Profiler
• Oracle deployment and support

E. Business Intelligence Architect / OLAP Developer

• Demonstrated ability to deliver solutions based on customer requirements
• Ability to present high-level ideas clearly and concisely.
• Proven experience developing and delivering dashboards and scorecards
• Familiarity with data visualization concepts
• SQL Server Reporting Services and PerformancePoint
• Liaison between lines of Business and I.T.
• Coordinate deployment of reporting solutions
• Microsoft Report Builder and/or BIDS (desired)
• Develop and optimize OLAP cubes using SQL Server Analysis Services
• Microsoft Excel preferably 2010

SUPERVISORY RESPONSIBILITIES:

None

MINIMUM REQUIRED EDUCATION, EXPERIENCE & KNOWLEDGE:

• Bachelor’s Degree, major in Accounting or Finance preferred
• Minimum 2 years of relationship management experience selling banking product
• Proficient in credit underwriting fundamentals and prior credit experience including financial analysis
• Knowledge of commercial loan products & lending / compliance regulations

ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS:

• Excellent communication and client service skills
• Ability to manage time and competing priorities in a retail environment
• Strong interpersonal skills with the ability to interact with all levels of an organization
• Collaborative professional skills that lead to a collegial and partnered approach to meeting objectives
• High motivation with ability to successfully meet individual and team goals while maintaining individual performance over the long term
• Ability to understand and interpret a P&L and financial statements
• Adaptability, flexibility and ability to work branch hours, including weekends and some evenings.