Define and document the technical architecture of the data warehouse, including the physical components and their functionality. Derives infrastructure system specifications from business requirements, design solutions that support core organizational functions, and ensure their high availability and other performance goals. Provides integrated infrastructure-related technical expertise across the organization, from conceptualization and project planning to the post-implementation support level.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

1. Provides infrastructure system expertise, requirements and assistance to Systems and Database Administrators, other System Architects and application development teams.

2. Partners with line of business (LOB) teams, external vendors, and internal Data Services team to develop system specifications in compliance with corporate standards for architecture adherence and performance guidelines.

3. Provides technical resources to assist in the design, testing and implementation of software code and infrastructure to support Data Infrastructure and Governance activities.

4. Assesses current technical architecture and estimate system capacity to meet near- and long-term processing requirements. Evaluates, selects, tests, and optimizes hardware and software products.

5. Consults with end-users, clients and senior management to define infrastructure requirements for complex systems and infrastructure development.

6. Oversees development and implementation of end-to-end integration of infrastructure solutions.

7. Documents the Bank's existing solution architecture and technology portfolio. Documents and communicates needs for investing in infrastructure evolution, including analysis of cost reduction opportunities.

8. Serves as a liaison with Enterprise Architects to conduct research on emerging technologies, and recommend technologies that will increase operational efficiency, infrastructure flexibility and operational stability.

9. Instructs, directs and mentors other members of the team.

QUALIFICATIONS

Required Qualifications:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

1. Bachelor's degree in a technical or business-related field, twelve years of experience in data warehousing architectural approaches

2. Ability to derive technical specifications from business requirements and express complex technical concepts in terms that are understandable to multi-disciplinary teams, in verbal as well as in written form

3. Strong functional and technical knowledge of information/cyber security capabilities with deep expertise in one or more of the following areas: SQL, Spark, Python, Git, ETL/ELT tools, Data Modeling tools

Preferred Qualifications: :

1. Banking or financial services experience