Job Details

Email to Friend Save Back

Data Architect

NEW YORK-10018, NY, US
06/07/2019

-

Required Skills

VBA, Python

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

Data Architect Lead - Senior Consultant

Job Description:

The successful candidate will be responsible for the overall design of the bank-wide data/information architecture which maps to the future to be data solution.

This key position will report to the Data Officer and work closely with the Head of IT and Business on both tactical and strategic enterprise-level data design and implementation.

Responsibilities:

Focuses on bank-wide data modeling and database design (Conceptual, Logical and Physical Design) using traditional and advance data warehouse approach.

Defines data/information architecture standards, structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects.

Advises on consistent business analysis, data acquisition, and access analysis and design, Data Management Systems optimization, load strategy design and implementation, as well as data-related security and change management

Collaborates with Engineering and ETL teams on data model, its maintenance and optimization as well as end-to-end data driven integration strategy.

Develops a metadata management and repository strategy to manage all enterprise information architecture project artifacts.

Collaborates with Product and Enterprise Data Teams

Ensure the to-be model is inclusive of integration of data across systems, collection, storage, processing, management, governance and analysis of data

Basic Qualifications:

8+ years of experience as data warehouse data architect or other senior data management role.

Experience using architecture repository tools.

Knowledge of Application design patterns, data modeling, service-oriented integration, business intelligence domains.

Experience with banking applications such as Core Banking system, transactional monitoring system such as Actimize, Mantas, Prime.

Document hands-on experience with ETL and MDM tools master data management solutions with 1 or more of the following e.g. Informatica, Teradata, DataStage, Microstrategy, Cognos, etc

Experience with Data Governance, Data Management Tools

Relational and Non-relational Data Warehouses (SQL, Oracle, NoSQL, MongoDB, Cassandra)
and Big Data Technologies

Professional Skill Requirements:

BA/BS Degree in science major such as Computer Science with MBA is a big plus

Previous Big 4 Consulting experience &/or hedge funds &/or Leading Bank

Python, VBA, SQL experience for GRC tool and reporting

Other regulatory requirement BASEL accord (Client 239, DFS504, DFS500, GDPR…)