Senior ERWin Data Architect - Consultant

Senior ERWin Data Architect - Consultant

Jersey City, NJ
Intermedia Group has an opening for the following Consultant:

TITLE: Senior ErWIN Data Architect
LOCATION: Jersey City, NJ
DURATION: 8 months +

PAY RATE: either $77 per hour w2 or $140,000 salaried + benefits

  • The ErWIN Data Architect (DA) 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.

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.
  • 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
  • Thorough knowledge of ERwin Data Modeler (V8 or higher) 
  • Very strong Design Concepts, from conceptual design on down
  • Must have a strong executive presence, communication skills, and experienced engaging with high-level stakeholders technically and business focused
  • Hands-on SQL experience
  • Data Management and Data Architecture related certifications (i.e. TOGAF) is a plus
  • 7+ years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies
  • 5+ years of data architecture experience
  • 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)
  • 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
  • Effective communication skills and customer relationship management skills
  • Thorough knowledge of Microsoft Office suite of products
  • Experience with any ETL tool is a plus
  • Experience with any Business Intelligence tool is a plus
  • 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
If you are interested in pursuing this opportunity, please respond back and include the following:
  • Full MS WORD Resume
  • Current and required compensation
  • Current contact information
  • Availability
Upon receipt, one of our managers will contact you to discuss the position in full detail.
Mervin Hernandez
Voice: 212-248-0100

Recruiter Contact

Mervin Hernandez | Recruiter
Intermedia Group Inc. | New York, NY
Main: (212) 248-0100
this job portal is powered by CATS