Senior Developer Analyst 2

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

Devises 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

Specialities:

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.