Senior Enterprise Data Modeler
Apply NowCompany: Clifyx
Location: Dallas, TX 75217
Description:
1. Senior Enterprise Data Modeler
Jersey City / Tampa / Dallas
Position Summary:
The Enterprise Data Modeler (EDM) at DTCC consults with product management, information technology, data stewards and other groups
to ensure that s/he understands all the details of a line of business in order to design and implement the blueprint of systems that will
support the work for that line of business. In addition, based on the detailed knowledge that the EDM has gained, s/he has to contribute to
the Enterprise Logical Data Model (ELDM) by defining repeatable patterns across the enterprise. Overtime, the EDM is expected to
become the subject matter expert (SME) on the topic, current and potential future uses of data, and the quality and interrelationship
between core elements of the data repositories and data products.
The EDM must be able to define how the information will be captured, retained and exploited. This individual will possess a combination of
business knowledge, technical skills, and people skills to define and guide the enterprise data strategy. Being able to identify data quality
issues and knowing how to integrate data is a must skillset.
The successful candidate must be able to understand and practice high-level patterns that are common in this field and to provide
leadership in data related matters as well as technical solutions that we propose to the application development groups and other IT
groups within the enterprise by being conversant with these teams, and cognizant of the future direction of systems. Furthermore, the
EDM must understand how that direction will impact the enterprise, and how current and future systems can be exploited for the benefit of
the enterprise.
Since this is an enterprise level position; a lot of emphasis is put on developing standards and patterns that can be used by other projects.
In addition, the candidate must be very fluent in pure logical data modeling
Job Duties:
The EDM serves a critical role in the understanding, documentation, analysis, and design of proposed systems. This role encompasses all aspects
of data management; conceptual, logical, and physical data modeling; being 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 constructs that will be captured in data models
Creating data models that conform to existing standards and conventions
Developing mapping documents that demonstrate data lineage
Revising data dictionaries, governance practices, and standards
Profiling existing data by writing SQL scripts in the source systems
Converting Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts
Interact with different stakeholders and gather information that would help solve the challenges at hand and help achieve the long-term goals of
the project
Minimum Qualifications:
10+ years of experience in data architecture
10 or more years of data modeling experience with demonstrated expertise in the analysis and design of large-sized systems
Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
Knowledge of Agile development methodology and concepts
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).
Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications
development, and cloud-based architectures
Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQL
Additional Skills:
Experience working as a member of a distributed data architecture team
Hands-on SQL experience
Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB
Good communication skills and customer relationship skills
Experience in translating business requirements documents into design artifacts, employing the core design principles
Performs a key leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization,
text mining, data discovery, and statistical methods
Thorough knowledge of Microsoft Office suite of products
Desired Skills:
Experience with ERwin Data Intelligence (DI)
Experience with any ETL tool (Informatica, DataStage, etc.)
Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)
Experience with Snowflake
Good understanding of the concepts in the financial industry, especially in the area of trade, clearing and settlement
Experience with any data profiling/data discovery tool
Working knowledge of data analytics and data mining techniques
Education/Certification::
Bachelor's degree in an appropriate area of specialization (computer science or information systems). A Master's degree would be preferable.
Understanding of two or more industry standard frameworks, including DAMA, DMBOK, or Zachman Framework
Data management and data architecture related certifications (i.e. TOGAF)
Jersey City / Tampa / Dallas
Position Summary:
The Enterprise Data Modeler (EDM) at DTCC consults with product management, information technology, data stewards and other groups
to ensure that s/he understands all the details of a line of business in order to design and implement the blueprint of systems that will
support the work for that line of business. In addition, based on the detailed knowledge that the EDM has gained, s/he has to contribute to
the Enterprise Logical Data Model (ELDM) by defining repeatable patterns across the enterprise. Overtime, the EDM is expected to
become the subject matter expert (SME) on the topic, current and potential future uses of data, and the quality and interrelationship
between core elements of the data repositories and data products.
The EDM must be able to define how the information will be captured, retained and exploited. This individual will possess a combination of
business knowledge, technical skills, and people skills to define and guide the enterprise data strategy. Being able to identify data quality
issues and knowing how to integrate data is a must skillset.
The successful candidate must be able to understand and practice high-level patterns that are common in this field and to provide
leadership in data related matters as well as technical solutions that we propose to the application development groups and other IT
groups within the enterprise by being conversant with these teams, and cognizant of the future direction of systems. Furthermore, the
EDM must understand how that direction will impact the enterprise, and how current and future systems can be exploited for the benefit of
the enterprise.
Since this is an enterprise level position; a lot of emphasis is put on developing standards and patterns that can be used by other projects.
In addition, the candidate must be very fluent in pure logical data modeling
Job Duties:
The EDM serves a critical role in the understanding, documentation, analysis, and design of proposed systems. This role encompasses all aspects
of data management; conceptual, logical, and physical data modeling; being 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 constructs that will be captured in data models
Creating data models that conform to existing standards and conventions
Developing mapping documents that demonstrate data lineage
Revising data dictionaries, governance practices, and standards
Profiling existing data by writing SQL scripts in the source systems
Converting Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts
Interact with different stakeholders and gather information that would help solve the challenges at hand and help achieve the long-term goals of
the project
Minimum Qualifications:
10+ years of experience in data architecture
10 or more years of data modeling experience with demonstrated expertise in the analysis and design of large-sized systems
Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
Knowledge of Agile development methodology and concepts
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).
Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications
development, and cloud-based architectures
Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQL
Additional Skills:
Experience working as a member of a distributed data architecture team
Hands-on SQL experience
Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB
Good communication skills and customer relationship skills
Experience in translating business requirements documents into design artifacts, employing the core design principles
Performs a key leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization,
text mining, data discovery, and statistical methods
Thorough knowledge of Microsoft Office suite of products
Desired Skills:
Experience with ERwin Data Intelligence (DI)
Experience with any ETL tool (Informatica, DataStage, etc.)
Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)
Experience with Snowflake
Good understanding of the concepts in the financial industry, especially in the area of trade, clearing and settlement
Experience with any data profiling/data discovery tool
Working knowledge of data analytics and data mining techniques
Education/Certification::
Bachelor's degree in an appropriate area of specialization (computer science or information systems). A Master's degree would be preferable.
Understanding of two or more industry standard frameworks, including DAMA, DMBOK, or Zachman Framework
Data management and data architecture related certifications (i.e. TOGAF)