Data Architect / Modeler

  • Salary

    $130,000 - $140,000 Per Year

Experience

10 to 15 Years

Posted On

Nov 14, 2022

Company

Techvilla Solutions

21 View

4 Applicants

Job Overview

Required Skills

  • Data Architect
  • data modeling
  • Data Warehouse
  • OCI
  • ETL
  • MDM
  • NoSQL
  • MongoDB

Job Type

Full-time

Work Authorization

NA

Location

Irving, TX/ Jacksonville, FL

Job Description

Responsibilities:

  • Focuses on bank-wide data modeling and database design (Conceptual, Logical, Physical) using traditional and advance data approach.
  • Understanding of Financial Industry Business Ontology (FIBO) and mapping to Conceptual model
  • 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
  • Collaborates with SMEs and Data Stewards, defines & implement data strategy, policies, controls, and program to ensure the enterprise data is accurate, complete, complete, secure, and reliable.
  • Ensure the to-be model is inclusive of integration of data across systems, collection, storage, processing, management, governance, and analysis of data

 

Basic Qualifications:

  • 10+ years of experience as conceptual data architect or other senior data management role. Experience using architecture repository tools.
  • Knowledge of conceptual data design patterns, UML, data modeling, service-oriented integration, business intelligence domains. Data Warehouse design concepts, data warehouse and large-scale reference data models, OCI, ETL tools. 
  • SME on most of the following major financial products’ areas such as Deposit, Lending, Cards, Investment. Great experience for GCB Deposits, Loan, and others along with the product associated Adjustment Reduction.
  • SME on bank’s Reporting, Capital Adequacy, GL Posting, Monitoring & Reporting, Stress Testing/Business Planning, FRY-9C, FRY-14 A/Q/M, FR 2052a, Ledger Rep(10Q/10K) and/or RWA Aggregation.
  • Experience with banking system and applications transactional and warehouse system.
  • Experience with Master and Reference data management
  • Hands-on experience with conceptual data architecture, taxonomy 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 Quality, Data Management Tools 
  • Relational and Non-relational Data Warehouses (SQL, Oracle, NoSQL, MongoDB, Cassandra) and Big Data Technologies. Distributed technologies and Internal cloud technologies like Open shift, PCF, Big Data platforms like Hadoop, demonstrated understanding of Data Analytics.
  • Assist in data management, governance, and data quality of master & reference data requirement with other functional data owners across financial systems (Cards, Deposits, Mortgage, Lending)
  • Familiar with one of the following modeling tools (e.g. MagicDraw, ER/Win, Power Designer, ERStudio)

Job ID: TVS00110

  • Posted By

    James William

Designation

Sr. HR

Company

Techvilla Solutions

Last Login

Sep 26, 2023

Posted On

Nov 14, 2022


Related Jobs