Senior Database Architect Designer - Modeler

Applied Research Associates - Herndon, VA

Full-time - Mid Level

Herndon, VA

1,001-5,000 employees

Professional, Scientific, and Technical Services

About the position

The Senior Database Architect at Applied Research Associates, Inc. is responsible for designing and building new data stores using various database technologies, including relational, graph, and NoSQL databases. This role requires a strong understanding of data design, engineering, and architecture principles, along with the ability to collaborate with both technical and non-technical stakeholders. The ideal candidate will have a passion for creating high-quality, scalable data solutions in a fast-paced environment.

Responsibilities

• Design, develop, and implement conceptual, logical and physical data models including ElasticSearch and Historic Database.
• Write clean, maintainable, and well-documented data designs.
• Collaborate with quality assurance team members to ensure data quality and functionality.
• Work with stakeholders to understand data requirements and translate them into data model solutions.
• Support developers with Extract Transform Load (ETL) code implementation.
• Optimize, troubleshoot, and resolve data issues.
• Collaborate with data scientists and analysts to ensure data accessibility.
• Stay up-to-date on the latest data engineering tools and technologies.

Requirements

• Must be a US citizen with an active Top Secret / SCI security clearance.
• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent experience) along with 8-10 years of experience as a Data Architect, Designer, Engineer, or similar role OR 16 years of experience in lieu of a degree.
• Strong understanding of entity-relationship design principles (OOP).
• Experience with data modeling tools (e.g., ERWin, Tom Sawyer Perspectives, etc.).
• Strong demonstrated experience with SQL and proficiency in writing complex queries.
• Experience with version control systems (e.g., Git).
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.

Nice-to-haves

• CI Poly

Benefits

• Employee ownership
• Challenging culture promoting innovation and experimentation
• Women's Initiative Network (WIN) for professional development support