.jpeg)
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 are 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 Modeler (DM) 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 DM 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 DM should be able to understand how the information will be captured, retained and exploited.
Qualifications:
- Minimum of 6 years of related experience
- Bachelor's degree preferred or equivalent experience
Talents Needed for Success:
- 7-15 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies
- 5-10 years of data architecture experience
- Thorough knowledge of Erwin Data Modeler
- Thorough knowledge of data warehousing concepts and the ability to create a dimensional design
- Strong understanding of data modeling best practices including normalization, Kimball methodology, and semantic modeling
- Experience managing data model evolution, including schema refactoring, column deprecation, and stakeholder alignment
- Knowledge of Agile development methodology and concepts
- Experience working as a member of a distributed data architecture team
- Extensive hands-on SQL experience
- Good understanding of the cloud technology and some of the tools used in that space
- Demonstrated prior experience designing and deploying data models to Snowflake
- Effective communication and customer relationship management skills
- Effective data analysis and profiling skills
- Thorough knowledge of Microsoft Office suite of products
- Prior experience in the financial services industry
Desired Skills:
- Good understanding of the concepts in the financial industry, especially in post-trade clearing and settlement
- Experience with any data profiling/data discovery/data quality 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
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.
Skills Required
- Minimum of 6 years of related experience
- 7-15 years of experience with information technology programs and services
- Demonstrated expertise in enterprise data management and related technologies
- 5-10 years of data architecture experience
- Thorough knowledge of Erwin Data Modeler
- Thorough knowledge of data warehousing concepts and dimensional design
- Strong understanding of normalization, Kimball methodology, and semantic modeling
- Experience managing data model evolution, schema refactoring, column deprecation, and stakeholder alignment
- Knowledge of Agile development methodology and concepts
- Experience working on a distributed data architecture team
- Extensive hands-on SQL experience
- Understanding of cloud technology and related tools
- Experience designing and deploying data models to Snowflake
- Effective communication and customer relationship management skills
- Effective data analysis and profiling skills
- Thorough knowledge of Microsoft Office products
- Prior experience in the financial services industry
- Bachelor's degree in Computer Science, Information Systems, or an appropriate specialization, or equivalent experience
- Understanding of financial industry concepts, especially post-trade clearing and settlement
- Experience with a data profiling, data discovery, or data quality tool
- Data management or data architecture certification such as TOGAF
The Depository Trust & Clearing Corporation (DTCC) Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about The Depository Trust & Clearing Corporation (DTCC) and has not been reviewed or approved by The Depository Trust & Clearing Corporation (DTCC).
-
Healthcare Strength — Medical, dental, and vision coverage are comprehensive and include mental health support, in-network preventive care, and company-supported HSA/FSA options. Company HSA contributions plus life, AD&D, and disability coverage further reinforce depth of protection.
-
Retirement Support — A 401(k) with company matching and references to pension-related benefits provide meaningful long-term savings support. Charitable contribution matching and financial-planning resources complement the core retirement offerings.
-
Parental & Family Support — Generous parental leave, adoption assistance, childcare benefits, and dependent care FSAs indicate strong support for families. Back-up care and specialized family health programs are highlighted as part of the package.
The Depository Trust & Clearing Corporation (DTCC) Insights
What We Do
With over 45 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 21 locations around the world, DTCC, through its subsidiaries, automates, centralizes and standardizes the processing of financial transactions, mitigating risk, increasing transparency and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm simplifies the complexities of clearing, settlement, asset servicing, data management, data reporting and information services across asset classes, bringing increased security and soundness to financial markets. In 2021, DTCC’s subsidiaries processed securities transactions valued at nearly U.S. $2.4 quadrillion. Its depository provides custody and asset servicing for securities issues from 177 countries and territories valued at U.S. $87.1 trillion. DTCC’s Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes 16 billion messages annually. To learn more, please visit us at www.dtcc.com.
