Job Summary:

Excelity is seeking a Data Architect for a project responsible for building the next generation Mission Information Systems for an exciting Government customer with a very critical mission. The candidate will work with the engineering team and customer to ensure successful development of high profile, complex, technical deliverables that are core to the continued success of our award-winning projects. The Data Architect will have experience managing the requirements, defining the strategy, and delivering solutions that meet the business’ needs including enterprise-wide data strategy, growing the data dictionary, and building a repository of the enterprise’s data.  The Data Architect will translate complex functional and technical requirements into detail design Implementing ETL process for integration of data from disparate sources.

Position Description: Ensures the successful implementation and day-to-day operation of database systems supporting critical Agency systems. Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications. Analyzes needs and requirements of existing and proposed systems, and develops technical, structural, and organizational specifications. May create standards and/or do modeling to monitor and enhance capacity and performance. Communicates with technical, applications, and operational staff, in order to design an optimal database architecture (performance, accessibility, backup, and recovery plan). Analyzes and makes recommendations for improvements to existing software regarding database performance, stability, usability and scalability. Performs logical and physical data modeling, designs relational database models and creates physical data models from logical data models. Designs database servers and interfaces to improve database and application performance. Supports the development effort by authoring stored procedures, functions, views and check constraints.

Basic Qualifications:

  • Requires a Bachelor's degree in an applicable field with 8 years of relevant experience. Additional experience may be considered in lieu of degree.
  • Active TS/SCI with ability to pass a CI polygraph
  • Experience in applying data modeling principles/methods including conceptual, logical & physical data models
  • Relational database experience
  • 2+ years experience with AWS technologies including PostgresSQL and EC2
  • ETL experience
  • Experience with integrating multiple data feeds into a consolidated data source for access by users via UI and by systems, e.g., via API
  • Experience with ER Studio Expertise or other similar modeling tools
  • GraphQL experience

Preferred Qualifications:

  • Experience with S3, DynamoDB, DocumentDB, ElasticSearch, Kafka, GeoServer
  • DIA experience
  • Understanding of the Intelligence Lifecycle and Collection Management mission space
  • Familiarity with intelligence discipline data and Collection Management data and processes
  • Familiarity with existing IC/Service systems in the Intelligence Lifecycle and Collection Management mission space
  • Implementation of data-centricity and data fabric concepts
  • Understanding of DoD/IC data standards
  • Familiarity with securing/hardening data infrastructure
  • Familiarity with IC Audit and Logging
  • Current CI polygraph

Required Clearance:  TS/SCI w/ CI Poly

Apply for this Job

* Required
resume chosen  
(File types: pdf, doc, docx, txt, rtf)
cover_letter chosen  
(File types: pdf, doc, docx, txt, rtf)