Data Modeler

Location: Quantico, VA
Job Type: Direct Hire
Salary: $1.00 - $1.00
Degree: Bachelor of Science;
Date: 11/1/2017
Job ID: 02537334
Job Description
Location: Quantico, VA. Work is performed on-site M-F.
Clearance: Secret
Travel: < 20%
Job Type:  Full Time, on-site


We are seeking an experienced Data Modeler to work at Marine Corp Base (MCB) Quantico, Quantico, Virginia to provide data modeling and data architecture support.  The candidate will perform in a lead Data Base Modeling (DBM) role providing support to system modernization efforts.  This will include performing database requirements identification and development, developing data dictionaries, developing conceptual, logical and physical database models, and developing plans for legacy data clean-up, data transformation, and data conversion.
 
Duties and responsibilities
  • Iteratively refine the existing enterprise conceptual data model,
  • Support and facilitate workshops and interviews to elicit information needed to develop logical and physical data models,
  • Develop the enterprise logical data model, including entities, attributes, and relationships,
  • Develop the enterprise physical data model, including tables, columns, and relationships,
  • Develop data dictionaries with agreed-upon definitions for all entities and attributes,
  • Map logical/physical attributes/columns to existing IT systems, identify gaps where data in existing systems do not exist to support the Target Data Architecture (TDA), and identify transformations where data must be altered from the source systems to be accommodated in the TDA., and
  • Architect and develop an overall master data hub for data elements that are used by multiple IT systems.
 
Specialized Knowledge
  • Conceptual data modeling,
  • Logical data modeling,
  • Physical data modeling,
  • Prior work and familiarity with databases (preferably Oracle, SQL Server, and Progress),
  • Data analysis,
  • Workshop and interview experience,
  • ERwin modeling tool experience and/or knowledge of and experience with program design and development with data interfaces including JDBC/ODBC, APIs, and data timestamping strategies, and
  • Experience with data interrogation tools.

Qualifications
  • Bachelor’s Degree in a technical field
  • Security+
  • 3 years of experience in data modeling
  • Excellent oral, written, and communication in English.
  • Must be able to work in a team environment with members that include personnel from other companies, Government program management and administrative personnel, and technical staff members.  
  • US Citizenship is required