Data Architect
Previous Job
Data Architect
Ref No.: 17-23063
Location: Jersey City, New Jersey
*SQL absolute requirement. Stong, experience Data architect / Designer...Must be able to look at a business requirements document and understand / communicate design principles

The Data Architect (DA) will consult with information technology, data analytics, product creation and development staff to design and implement the blueprint of a database to support 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.

Review business requirements, profile 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; being 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
• Profiling the data in the source system(s) by writing SQL statements
• Designing logical data models that conform to existing standards and conventions
• Developing 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

• Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
• 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
• Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB