Technical Team Lead – Liquidity – DB and Reporting
Previous Job
Previous
Technical Team Lead – Liquidity – DB and Reporting
Ref No.: 18-04909
Location: Buffalo, New York
The Opportunity:
The Technical Team Lead is responsible for the management of all activities related to the successful
planning, documenting, testing and implementation of all work performed by the team, whether by the
request of the client, internal to the department or the result of a problem relating to an application.
Provides detailed direction and performs specialized analysis and research of systems modifications to
solve any scope problem or enhancement.

Responsibilities:
The Technical Team Lead manages and oversees the execution of project plans for any scope; ensures
adherence to all department and technology standards and procedures, including all documentation
requirements.

Performs and oversees application development and supports coding efforts, including the review of
code, preparation and execution of system builds; may be called upon to coordinate the completion of
integrated testing efforts.

Translates requirements to assist staff in preparing detailed low level design for system enhancements.
Recommends designs based on business requirements and functional specification. Identifies issues and
concerns.

Ability to act as a client liaison to review priorities and manage the overall client queue. Builds rapport
within the organization. Effectively communicates and develops a professional level of cooperation across
the organization.

Maintains efficient operation and effectiveness of supported applications. Recommends new technology, policies or processes to benefit the organization and improve deficiencies. Typically will lead technical
evaluations of vendor software.  Demonstrates a strong understanding of the business environment and needs within the area of
responsibility. Ability to understand technical, business and operational impacts of a project or problem.
Responsible for the job growth and career development of staff members by providing training plans,
guidance and sharing knowledge.

Recommends and initiates new policies and procedures which will improve the performance and
effectiveness of the department.

Minimum Qualifications Required:
Bachelor's Degree and ten (10) or more years' relevant experience with project related work, systems
analysis and a systems development environment.
Expertise with Database architecture and design principles including designing tables, views, indexes, etc.
Experience with doing code reviews
Expert level understanding of ETL tools including informatica power center.
Experience with Application Design for applications using Microsoft SQL Server backend
Expert level understanding of complex TSQL in Microsoft SQL Server environment.
Experience with Oracle database environment.
Experience with Team Foundation Server
Requires a complete understanding of the system development life cycle.
Requires familiarity with application development support software and hardware platforms.
Strong written and verbal communication skills to be able to present to a target audience
Must be detail orientated/articulate with strong time management and organizational skills
Ideal Qualifications Preferred:
Previous experience in developing and maintaining a department budget.
Experience with software applications related to calculating liquidity coverage ratio and regulatory
submissions.