Principal Data Modeler
DTCC
- Dallas, TX
- Permanent
- Full-time
- 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).
- 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
- Bachelor's degree and/or equivalent experience.
- Minimum of 8+ years of related experience.
- 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