Data Modeler/Architect
Boston, MA 
Share
Posted 2 days ago
Job Description
KeyLogic is actively seeking a Data Modeler/Architect who designs, implements, and documents data architecture and complex data modeling solutions. This will include the use of relational, dimensional, and NoSQL databases. You will be part of the data architects team to design bespoke databases using a combination of conceptual, physical, and logical data models. We have a history of providing next-gen automation and data warehousing solutions to our customers. This Air Force project is greenfield technology and you will build an enterprise data warehouse transitioning on-prem data to an AWS Cloud architecture.
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
  • 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
  • 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
  • Can define and govern data modeling and design standards, tools, best practices, and related development methodologies for the organization for which they work
  • Provide recommendations for standardization and proper data usage in business, and communicate the benefits and return on investment for application and product owners
Required Qualifications:

  • 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
  • 8+ years of total experience with at least 5 years focusing on Data Modeling
  • Work ONSITE at Hanscom AFB
Desired 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)
  • Implement and enforce data security measures, including access controls and encryption, to protect sensitive information in accordance with DoD cybersecurity standards
  • Implement and enforce DoD data standards, ensuring consistency and compliance with relevant regulations and security requirements
  • Strong knowledge of SQL for querying and manipulating data within databases
  • Collaborate with stakeholders, including analysts and subject matter experts, to gather and analyze data requirements, ensuring that data models meet the project's needs
  • 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 a dynamic team environment
  • Ability to communicate clearly with all levels within an organization
  • Experience working with 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
  • Excellent analytical skills, organizational abilities, and problem-solving skills
  • Strong understanding of the 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 relevant

About KeyLogic:

Supporting critical missions at the intersection of data and science, KeyLogic provides mission management, systems analysis, data analytics, digital transformation, and cybersecurity to customers in the energy, federal civilian, and defense sectors, with a 20+ year portfolio of successes supporting DOE, DOC, EPA, DOD, DHS, FBI, and other federal agencies challenged with complex missions. We help our customers solve the world's most challenging problems with unsurpassed anticipatory service.

KeyLogic employs over 600 team members, including systems designers, developers, data scientists, IT and cybersecurity specialists, engineers, mission experts, program managers, and more than 70 Ph.D. scientists. This multidisciplinary team works together solving challenging problems with anticipatory service-always staying one step ahead-benefiting our customers, and ultimately helping build a better world.

We are committed to the success of each customer's mission. We care enough to make their mission our mission and their success our success. We take technical service delivery to a level above our peers. Our anticipatory service is best-in-class.

All qualified applicants will receive consideration for employment at KeyLogic without regard to race; creed; color; religion; national origin; sex; age; disability; sexual orientation; gender identity or expression; genetic predisposition or carrier status; veteran, marital; or any other status protected by law. KeyLogic is proud to be an affirmative action and equal opportunity employer.

NOTE: KeyLogic is an Equal Employment/Affirmative Action employer. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state, or local law.

If you need a reasonable accommodation for any part of the employment process, please contact us by email at Recruiting@KeyLogic.com and let us know the nature of your request and your contact information. Request for accommodation will be considered on a case-by-case basis.

Job Code:
2197

KeyLogic Systems is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Disabled.

 

Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
8+ years
Email this Job to Yourself or a Friend
Indicates required fields