Data Modeler/Architect - KeyLogic Systems
Lexington, MA 02420
About the Job
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
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
Source : KeyLogic Systems