Pay and Benefits :
- Competitive compensation, including base pay and annual incentive
- Comprehensive health and life insurance and well-being benefits, based on location
- Pension / Retirement benefits
- Paid Time Off and Personal / Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being
- DTCC offers a flexible / hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee)
The impact you will have in this role :
The Data Architect (DA) at DTCC will consult with information technology, data analytics, business / product creation and development staff to craft and implement the blueprint of a database to store information for a specific system that will support the work of the enterpriseThe 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 productsThe DA should be able to understand how the information will be gathered, retained and exploitedReviewing business requirements and / or conducting in-person interviews, profiling source system data, documentation, analysis, and design of proposed systemsThis role encompasses all aspects of data management; conceptual, logical, and physical data model creationThe individual will be involved in end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standardsYour Primary Responsibilities :
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, standards, guidance, architecture patternsConverting logical data models into working physical data models and, document and maintain lineage between the two artifactsDeveloping and maintaining reference architecture artifactsConduct weekly walkthroughs of the data models with different collaboratorsTalents needed for Success :
7-15 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies5-15 years of data architecture experienceThorough knowledge of Erwin Data Modeler (V9 or higher) or a comparable CASE toolSolid understanding 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 life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC)Hands-on SQL experienceGood understanding of the cloud technology and some of the tools used in that spaceExperience with two or more of the following DBMS technologies : Oracle, PostgreSQL, Snowflake, Microsoft SQL ServerEffective communication skills and customer relationship management skillsThorough knowledge of Microsoft Office suite of productsExperience with ETL tool(s) : (Informatica, DataStage, Talend, etc )Experience with Business Intelligence (BI) tools : (i e OBIEE, MicroStrategy, Tableau, Power BI, QuickSight, etc )Competency in analytical and problem-solving skillsGood communication skillsSkills Required
Principal Data Modeler