Principal Data Architect

Depository Trust Clearing Corporation - Jersey City, NJ

Full-time - Principal

Jersey City, NJ

Credit Intermediation and Related Activities

About the position

The Principal Data Architect (DA) at DTCC will play a crucial role in advising various teams, including information technology, data analytics, and business/product development, to design and implement a comprehensive database blueprint that supports the enterprise's operations. This position requires a deep understanding of the underlying data and business events within the organization, positioning the DA as a subject matter expert (SME) on data content, its current and potential future uses, and the quality and interrelationships of core data elements. The DA will be responsible for understanding how information is captured, retained, and utilized effectively within the organization. In this role, the Principal Data Architect will engage in a variety of tasks, including reviewing business requirements, conducting interviews, profiling source system data, and documenting analysis and design for proposed systems. The responsibilities encompass all aspects of data management, including the creation of conceptual, logical, and physical data models. The DA will be involved in end-to-end data lifecycle management, evaluating and recommending new and emerging data management technologies and standards. This position also requires translating business requirements into viable data models and design artifacts, ensuring that they adhere to existing standards and conventions. The DA will develop mapping documents to demonstrate data lineage, revise data dictionaries, and maintain governance practices and architecture patterns. Additionally, the role involves converting logical data models into physical data models and documenting the lineage between these artifacts. Regular collaboration with various stakeholders through weekly walkthroughs of data models is also a key aspect of this position. Overall, the Principal Data Architect will be instrumental in shaping the data architecture strategy and ensuring that it aligns with the organization's goals and objectives.

Responsibilities

• Review business requirements and conduct in-person interviews.
• Profile source system data and document analysis and design of proposed systems.
• Create conceptual, logical, and physical data models.
• Engage in end-to-end data lifecycle management activities.
• Evaluate and recommend new and emerging data management and storage technologies and standards.
• Translate business requirements into viable conceptual and logical data models.
• Develop mapping documents that demonstrate data lineage.
• Revise data dictionaries and governance practices, standards, and architecture patterns.
• Convert logical data models into working physical data models and document lineage between the two artifacts.
• Develop and maintain reference architecture artifacts.
• Conduct weekly walkthroughs of data models with collaborators.

Requirements

• Bachelor's degree preferred; Master's or equivalent experience is a plus.
• 10 years of experience with information technology programs and services, with expertise in enterprise data management.
• 7 years of data architecture experience.
• Certifications related to the candidate's coverage responsibilities are beneficial but not required (e.g., CPA, CFA, FRM, CIA, CISA).
• Thorough knowledge of Erwin Data Modeler (V9 or higher) or a comparable CASE tool.
• Working knowledge of data warehousing concepts and ability to convert physical design into dimensional design.
• Knowledge of Agile development methodology and concepts.
• Experience working as a member of distributed data architecture teams.
• Understanding of information systems and data lifecycle management best practices and methodologies.
• Hands-on SQL experience.
• Good understanding of cloud technology and tools used in that space.
• Experience with two or more of the following DBMS technologies: Oracle, PostgreSQL, Snowflake, Microsoft SQL Server.
• Thorough knowledge of Microsoft Office suite of products.
• Experience with ETL tools (e.g., Informatica, DataStage, Talend).
• Experience with Business Intelligence (BI) tools (e.g., OBIEE, MicroStrategy, Tableau, Power BI, QuickSight).
• Experience with commercially available industry data models (e.g., IBM's Financial Services Data Model).
• Good understanding of concepts in the financial industry, especially in trade, clearing, and settlement.

Nice-to-haves

• Previous internal or external audit experience is helpful but not required.
• Knowledge or experience related to financial risk management, quantitative analysis, or coding (e.g., Python, SQL, R, VBA) is a plus.

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.
• Flexible/hybrid model of 3 days onsite and 2 days remote.