Job Description :
Required Skills:
Good understanding of the financial sector, specifically the trade life-cycle.
10-15 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies
10-15 years of data architecture experience including logical data modelling and dimensional modelling.
Strong understanding of data profiling skills (fluent in SQL)
Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
Knowledge of Agile development methodology and concepts
Experience working as a member of a distributed data architecture team
Desired Skills:
Experience with any commercially available industry data model (i.e. IBM’s Financial Services Data Model)
Good understanding of the concepts in the financial industry, especially in trade, clearing and settlement
Experience with any data profiling/data discovery tool
Education/Certification:
Bachelor’s degree in an appropriate area of specialization (Computer Science or Information Systems)
Data management and data architecture related certifications (i.e. TOGAF) is a plus
The four most important needs are:
1. A data architect who is fluent in data warehousing techniques with excellent communication skills.
2. Very strong understanding of data modelling techniques (logical, physical, dimensional)
3. Fluent in SQL.
4. Fair understanding of the trade life cycle and securities market.
Position Summary:
The Data Architect (DA) will consult with information technology, data analytics, business/ product creation and development staff to design and implement the blueprint of a database to store information for a specific system that will support the work of the enterprise.
The DA will develop a detailed knowledge of the underlying data as well as business events within the enterprise and become the subject matter expert (SME) on content, current and potential future uses of data, and the quality and interrelationship between core elements of the data repository and data products.
The DA should be able to understand how the information is captured, retained and exploited.
Job Duties:
Build a new data warehouse for the Equities Clearing division.
The job entails reviewing business requirements and/or conducting in-person interviews, profiling source system (s) data, documentation, analysis, and design of the proposed system.
The candidate must have a very good understanding of logical and physical data modelling and must be able to de-normalize the information in a very organized way to build the needed dimensions, fact tables, etc.
Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable objects first logically, then dimensionally
Translate the business requirements into design artifacts, employing the core design principles
Write "best practices" documents based on DTCC''s standards and conventions along the way while designing the new data warehouse environment
Develop mapping documents that demonstrate data lineage
Revising data dictionaries, governance practices, and standards
Attend daily scrum calls to report progress on the work that has been assigned to the candidate