Data Architect

Job Title : Data Architect

Location : Jersey City, NJ

Duration : 18 months

Client : DTCC

US Citizen/GC

 

 

Data Modeling/Data Architect

Four main skills:

1) Senior level designer with expertise in logical data modeling

2) Expertise in the CASE tool (ERWin)

3) Superb communications skills (oral & written)

4) Very proficient in SQL

 

Important to note: We are not looking for people who have added a bullet point or two to their resumes, claiming that they've done design. We are looking for individuals whose main role on projects was to design systems. Therefore; the resume should have plenty of details of how they modeled a system.

 

The 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.

Job Duties:

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

 

Required Skills:

• 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

• Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool

• Working knowledge 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 best practices 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

• Effective communication skills and customer relationship management skills

• Thorough knowledge of Microsoft Office suite of products

 

Desired Skills:

• Experience with any commercially available industry data model (i.e. IBM’s Financial Services Data Model)

• Good understanding of the concepts in the financial industry, especially in trade, clearing and settlement

• Experience with any data profiling/data discovery 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

 

 

 

 

If you need any additional information, feel free to contact me on my direct number anytime.

 

Look forward working with you…

Thanks & Regards

Pooja Samya

Technical Recruiter

Fusion plus Solutions Inc

(MWBE Certified )

3 Ethel Rd, Suite # 303, Edison, NJ 08817

PH: 848-209-8323, ext 318 Fax : 732-626-6289

samya@fusionplusinc.com

www.fusionplusinc.com (eVerify)

P Please consider the environment before printing.

We respect your online privacy. If you would like to be removed from our mailing list please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited.We are an equal opportunity employer with a diverse workforce.