Data Architect

Description

Main skills 1) Senior level designer with expertise in logical, physical, and dimensional modeling2) Expertise in the CASE tool (ERWin)3) Superb communications skills (oral & written)4) Very proficient in SQLImportant to note We are not looking for people who have added a bullet point or two to their resumes, claiming that they've done design. We are looking for individuals whose main role on projects was to design systems.Therefore; the resume should have plenty of details of how they modeled a system. The Data Architect (DA) at DTCC 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 will be captured, retained and exploited. Job Duties Reviewing business requirements and/or conducting inperson interviews, profiling source system (s) data, documentation, analysis, and design of proposed systems. This role encompasses all aspects of data management; conceptual, logical, and physical data model creation. The individual will be involved in endto end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standards. Some of the daily activities include Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data modelsTranslate the business requirements into design artifacts, employing the core design principlesProfiling the data in the source system(s) by writing SQL statementsDesigning logical data models that conform to existing standards and conventionsDevelop mapping documents that demonstrate data lineageRevising data dictionaries, governance practices, and standardsConverting logical data models into working physical data models and, document and maintain lineage between the two artifactsConduct weekly walkthroughs of the data models with different stakeholdersRequired Skills 715 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies515 years of data architecture experienceThorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE toolWorking knowledge of data warehousing concepts and the ability to convert a physical design into a dimensional designKnowledge of Agile development methodology and conceptsExperience working as a member of distributed data architecture teamsUnderstanding of information systems and data lifecycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC)Handson SQL experienceGood understanding of the cloud technology and some of the tools used in that spaceExperience with three or more of the following DBMS technologies Oracle, Microsoft SQL Server, Greenplum, Sybase and UDBEffective communication skills and customer relationship management skillsThorough knowledge of Microsoft Office suite of productsDesired Skills Experience with any ETL tool (Informatica, DataStage, etc.)Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)Experience with any commercially available industry data model (i.e. IBMs Financial Services Data Model)Good understanding of the concepts in the financial industry, especially in trade, clearing and settlementExperience with any data profiling/data discovery toolEducation/Certification Bachelors 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