Back to Careers

Data Modeler

Type: Full-time
Category: Data Engineer
Location: Reston, VA
Clearance: TS/SCI

Description

OVERVIEW

As a member of our solutions delivery team you will have the unique opportunity to work on programs advancing the digital transformation of critical government systems. NT Concepts is seeking an experienced Data Modeler for an exciting data transformation opportunity within our Intel Community.

The Data Modeler will work with Mission and MIDB production SMEs to analyze, discover, define and document current MIDB databases’ data structures organized around objects that relate to the Infrastructure mission. The Data Modeler will also redesign the data model using requirements and guidance provided by the Government and migrating the data into the new data models. The Data Modeler will apply Artificial Intelligence (AI) and Machine Learning (ML models) to identify data values from disparate source systems that are null or incorrect. The data modeler will develop conceptual, logical and physical data models.

RESPONSIBILITIES

  • Understand and translate business needs into data models supporting long-term solutions for relational and object oriented databases.
  • Work with database team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Optimize/update logical and physical data models to support the new requirements.
  • Maintain conceptual, logical and physical data models along with corresponding metadata.
  • Create data cataloging capabilities
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Recommend opportunities for reuse of data models in new environments.
  • Perform reverse engineering of physical data models from databases and SQL scripts.
  • Evaluate data models and physical databases for variances and discrepancies.
  • Validate business data objects for accuracy and completeness.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Develop data models according to best practices.
  • Prior experience with PostgreSQL is preferred


REQUIREMENTS

Basic Qualifications: 

  • Bachelor’s Degree, ideally in a technical discipline
  • 2-5 years experience in data modeling principles/methods including conceptual, logical, and physical data models

Preferred Qualifications:  

  • Knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others).

Clearance:  

  • TS/SCI clearance required, with the ability to obtain CI Poly

Physical Requirements:

  • Prolonged periods of sitting at a desk and working on a computer
  • Must be able to lift 10-15 pounds at times.

#CJ

#JT


Working at NT Concepts means that you are part of an innovative, agile company dedicated to solving the most critical challenges in National Security. We're expert leaders and problem solvers who roll up our sleeves to get the job done. We're passionate, curious, and committed to doing important work. At the same time, we're life-long learners, avid mentors, and we like to have fun.

We're looking for the best and the brightest to join us in supporting the mission of National Security. If meaningful work, initiative, creativity, and continuous self-improvement are important to your career, join our growing talent network and discover What's Next for you.

NT Concepts is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. U.S. Citizenship is required for all positions. Contact us if you need a reasonable accommodation for any part of the employment process. All resumes are held in confidence. NT Concepts participates in E-Verify.