Previous Job
Data Architect
Ref No.: 18-04290
Location: New York, New York
Position Type:Contract
Senior Data Architect
Long Term Contract

New York, NY 

Job Description:
Our client is looking for a Senior Enterprise Architect to serve as our SME and to support a data architecture platform review for a leading financial institution.  Will be responsible for reviewing Enterprise Data technology processes, platforms, associated downstream systems and identifying improvement opportunities consistent with standards and best practices.  
Job Duties: 
  • Work closely with and assist the application owners to evaluate overall production data and QA processes including data distribution to downstream systems.
  • Conduct overall platform assessment while outlining gaps and areas for improvement. 
  • Evaluate overall performance and process optimization objectives.
  • Evaluate existing standards against industry practices. 
  • Evaluate integration with other solutions including Teradata, Informatica ETL capabilities, and mainstream RDBMS platforms.
  • Evaluate data model and physical implementation as required.
  • Evaluate operating principles, guidelines, and gaps in best practices.
  • Determine operational improvements recommendations.
  • Review roadmap, implementation plan, and upgrade path.
  • Facilitate adoption and implementation of performance, technical enhancements and/or any recommended upgrades or implementation of new features.
  • Define desired Future State and create implementation plan with key milestones
Required Skills/Background:
  • 10-15 years Data Architecture and Enterprise Architecture
  • Must have experience moving enterprises from batch centric to Real-Time Architecture
  • Relevant experience in:
    • Enterprise Data Architecture
    • Enterprise Data Warehousing (EDW) Practices
    • EDW Solutions (preferably Teradata)
    • Relational Database Technologies (MS SQL Server, IBM DB2,)
    • Knowledge of Data Architecture & Data Modeling
    • ETL Tools & Utilities (Informatica)
    • Distributed & Batch Computing Best Practices
    • Enterprise Data & Infrastructure Standards
  • Experienced and knowledgeable in Enterprise Data & Infrastructure Standards
  • Experienced in analyzing, troubleshooting and apply best practice for usage
  • Excellent written and verbal communication skills with ability to engage well with senior management as well as line staff
  • Financial Services Experience a must (Wealth Management preferred)


The key is someone who is an SME with experience moving enterprises from Batch Centric to RT Architecture 
- High Visibility. 
- 3 year project to be completed in 2021. 
- New mainframe kit for 2019, install Q1/Q2 2019(proposed)
- "Service Enablement” versus "Affinity Remediation” 
- They should engineer the services away from legacy code and then sunset the legacy code (instead of fixing affinities). 
- They are working on getting end-to-end traceability with granularity at the PROID level 
- Dynamic connection routing not solved 
- "Vision to Execute” 
- Security Assessment / Architecture 
- Begin the march to a more real time architecture. 
- The batch window is expanding again and is effectively 10pm – 6am. Batch production and non-production. 
o This would involve removing "Batch Completion Dependencies” from certain processing. 
o This can be influenced by having proper data architecture 
o "Non-production test environment capability