Overview
On Site
Full Time
Skills
Systems analysis/design
Physical data model
Microsoft SQL Server
Professional development
Life insurance
Information Technology
Data Analysis
Business requirements
Data management
Lifecycle management
User stories
Agile
Data architecture
Data warehouse
Information systems
Systems engineering
Cloud computing
Financial services
IT architecture
Enterprise services
Data
IMPACT
DTCC
Collaboration
Innovation
Finance
Design
Blueprint
Database
Documentation
Storage
Writing
SQL
Mapping
Governance
ERwin
Management
Software development methodology
Oracle
EMC GreenPlum
Sybase
UDB
SAP BASIS
Trading
Teamwork
Security clearance
Transformation
Job Details
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:
The impact you will have in this role:
The Principal Data Modeler is a 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.
Your Primary Responsibilities:
Reviewing business requirements and/or conducting in-person 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 end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies and standards.
Some of the daily activities include:
**NOTE: The Primary Responsibilities of this role are not limited to the details above. **
Qualifications:
Talents Needed for Success:
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 crucial job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
About Us
DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.
DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you'll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It's the chance to make a difference at a company that's truly one of a kind.
Learn more about Clearance and Settlement by clicking here .
About the Team
IT Architecture and Enterprise Services are responsible for enabling digital transformation of DTCC. The group manages complexity of the technology landscape within DTCC and enhances agility, robustness and security of the technology footprint. It does so by serving as the focal point for all technology architectural activities in the organization as well as engineering a portfolio of foundational technology assets to enable our digital transformation.
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 Principal Data Modeler is a 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.
Your Primary Responsibilities:
Reviewing business requirements and/or conducting in-person 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 end-to 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 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, and standards
- Converting logical data models into working physical data models and, document and maintain lineage between the two artifacts
- Conduct weekly walkthroughs of the data models with different stakeholders
**NOTE: The Primary Responsibilities of this role are not limited to the details above. **
Qualifications:
- Bachelor's degree and/or equivalent experience.
- Minimum of 8+ years of related 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-15 years of data architecture experience
- Detailed knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
- Solid understanding 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 standard processes 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 three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB
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 crucial job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
About Us
DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.
DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you'll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It's the chance to make a difference at a company that's truly one of a kind.
Learn more about Clearance and Settlement by clicking here .
About the Team
IT Architecture and Enterprise Services are responsible for enabling digital transformation of DTCC. The group manages complexity of the technology landscape within DTCC and enhances agility, robustness and security of the technology footprint. It does so by serving as the focal point for all technology architectural activities in the organization as well as engineering a portfolio of foundational technology assets to enable our digital transformation.