Demo

Data Architect Senior Associate

The Depository Trust & Clearing Corporation (DTCC)
Dallas, TX Full Time
POSTED ON 4/29/2025
AVAILABLE BEFORE 5/28/2025

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We're committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

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) Senior Associate at DTCC will collaborate 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.

Your Primary Responsibilities :

Reviewing business requirements and / or conducting in-person interviews, profiling source system 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 end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standards.

  • Reviewing Business Requirements Documents (BRDs) and / or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data models
  • Translate the business requirements into design artifacts, employing the core design principles.
  • Profiling the data in the source system(s) by writing SQL statements
  • Designing logical data models that conform to existing standards and conventions.
  • Develop mapping documents that demonstrate data lineage.
  • Revising data dictionaries, governance practices, standards, guidance, architecture patterns
  • Converting logical data models into working physical data models and, document and maintain lineage between the two artifacts.
  • Developing and maintaining reference architecture artifacts
  • Conduct weekly walkthroughs of the data models with different collaborators
  • NOTE : The Primary Responsibilities of this role are not limited to the details above.
  • Qualifications :

  • Bachelor's degree preferred with Masters or equivalent experience.
  • 7 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies.
  • 5 years of data architecture experience
  • Certifications related to the candidate’s coverage responsibilities are beneficial, but not required, such as CPA, CFA, Financial Risk Manager (FRM), Certified Internal Auditor (CIA), and Certified Information Systems Auditor (CISA)
  • Talents Needed for Success :

  • Detailed knowledge of Erwin Data Modeler (V9 or higher) or a comparable CASE tool
  • Working knowledge of data warehousing concepts and the ability to convert a physical design into a 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 life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC)
  • Hands-on SQL experience
  • Good understanding of the cloud technology and some of the 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 tool(s) : (Informatica, DataStage, Talend, etc.)
  • Experience with Business Intelligence (BI) tools : (i.e. OBIEE, MicroStrategy, Tableau, Power BI, QuickSight, etc.)
  • 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 / data quality tool
  • Previous internal or external audit experience is helpul, but not required.
  • Knowledge or experience related to financial risk management, quantitative analysis, or coding (e.g., Python, SQL, R, VBA) will be a plus
  • The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Architect Senior Associate?

    Sign up to receive alerts about other jobs on the Data Architect Senior Associate career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $159,552 - $206,899
    Income Estimation: 
    $192,745 - $244,036
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at The Depository Trust & Clearing Corporation (DTCC)

    The Depository Trust & Clearing Corporation (DTCC)
    Hired Organization Address Jersey, NJ Full Time
    Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a dynamic and supp...
    The Depository Trust & Clearing Corporation (DTCC)
    Hired Organization Address Tampa, FL Full Time
    Job Description Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a ...
    The Depository Trust & Clearing Corporation (DTCC)
    Hired Organization Address Tampa, FL Full Time
    Job Description Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a ...
    The Depository Trust & Clearing Corporation (DTCC)
    Hired Organization Address Tampa, FL Full Time
    Job Description Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a ...

    Not the job you're looking for? Here are some other Data Architect Senior Associate jobs in the Dallas, TX area that may be a better fit.

    Field Tech Senior Associate

    NTT DATA North America, Irving, TX

    Senior Data Architect

    Alvarez & Marsal Europe, Dallas, TX

    AI Assistant is available now!

    Feel free to start your new journey!