Data Modeler

Company: International Executive Service Corps
Location: Boston
Posted on: May 20, 2025

Job Description:

KeyLogic is actively seeking a Data Modeler who designs, implements and documents data architecture and data modeling solutions, which include the use of relational, dimensional and NoSQL databases. Work closely with data architects to design bespoke databases using a mixture of conceptual, physical, and logical data models.Location: On-site at Hanscom Airforce BaseThis position requires US Citizenship and the ability to obtain a Secret Clearance.Responsibilities:

• Develop and maintain conceptual, logical, and physical data models that align with DoD project requirements. Ensure data models accurately represent data structures, relationships, and attributes
• Collaborate with stakeholders, including analysts and subject matter experts, to gather and analyze data requirements, ensuring that data models meet the project's needs
• Implement and enforce DoD data standards, ensuring consistency and compliance with relevant regulations and security requirements
• Create comprehensive documentation for data models, including data dictionaries, entity-relationship diagrams, and metadata descriptions to facilitate understanding and usage by project teams
• Work with data integration teams to ensure seamless data flow between various systems and databases within the DoD project, maintaining data integrity and consistency
• Implement data quality checks and validation rules within data models to identify and resolve data quality issues proactively
• Implement and enforce data security measures, including access controls and encryption, to protect sensitive information in accordance with DoD cybersecurity standards
• Collaborate with data governance teams to define and enforce data governance policies, ensuring data models align with governance requirements
• Optimize data models for performance and scalability, considering the large datasets and complex queries often encountered in DoD projects
• Work closely with other data professionals, such as database administrators, data engineers, and data analysts, to ensure that data models align with the broader data architecture and strategy
• Work closely with the database engineers to create optimal physical data models of datasets, then create and maintain data maps and systems interrelationship diagrams for data domains and systems
• Identify areas where data can be used to improve business activities, defining business users' requirements
• Understanding of data flows and implement innovative data solutions
• Can define and govern data modeling and design standards, tools, best practices, and related development methodologies for the organization for which they work
• Setting standards for document naming, security, and lifecycle & retention architecture
• Provide recommendations for standardization and proper data usage in business, and communicate the benefits and return on investment for application and product ownersQualifications:
  • US Citizenship Required
  • Able to obtain a Secret Clearance
  • Bachelor's Degree in Computer Science, Engineering, or other technical discipline required
  • Prior experience in data modeling, database design, and data architecture, with a combination of 8+ years of experience
  • Relevant certifications, such as Certified Data Management Professional (CDMP) or Certified Information Systems Security Professional (CISSP), are a plusDesired Skills:
    • Proficiency in data modeling tools such as Erwin Data Modeler, IBM Data Architect, or Oracle SQL Developer Data Modeler for creating and maintaining data models
    • Experience with relational database management systems (RDBMS) commonly used in DoD projects, such as Oracle, SQL Server, or PostgreSQL
    • Familiarity with DoD data standards, including the DoD Information Enterprise Architecture (DoD IEA) and the DoD Architecture Framework (DoDAF)
    • Strong knowledge of SQL for querying and manipulating data within databases
    • Understanding of data governance and metadata management tools that may be used in DoD projects, such as Collibra or Informatica Axon
    • Knowledge of data security best practices and compliance with DoD cybersecurity standards, including the Risk Management Framework (RMF)
    • Understanding of data integration technologies and tools, including ETL processes and data integration platforms
    • Proficiency in implementing data quality checks and ensuring data quality within data models
    • Strong documentation skills for creating clear and comprehensive data model documentation
    • Excellent written and oral communication skills, including strong technical documentation skills
    • Strong interpersonal skills and ability to work collaboratively in dynamic team environment
    • Proven track record in demanding, customer service-oriented environment
    • Ability to communicate clearly with all levels within an organization
    • Excellent analytical skills, organizational abilities and problem-solving skills
    • Strong understanding of business domain, the data requirements, and the data sources
    • Identify the key entities, attributes, and relationships that represent the data in a logical and coherent way
    • Have conceptual thinking in creating data models that are clear, accurate, and relevantSalary: 155-165K
      #J-18808-Ljbffr

Keywords: International Executive Service Corps, Newton , Data Modeler, Other , Boston, Massachusetts