Principal Database Architect/Data Analyst

Applied Research Associates, Inc. is looking for candidates to join our Data Transformation of Foundational Military Intelligence (DTMI) team in Herndon, VA, where you will support our efforts by leading the analysis, design, implementation, testing, and deployment of the work to ensure the activities undertaken support a well designed and implemented data environment. The ideal candidate utilizes the Government-provided conceptual data models, along with the results of the other DTMI Tasks, in order to derive the appropriate logical and physical data models required for the database design and implementation.

Gathers data requirements, data rules, and understands relationships between data feeds. Should understand how algorithms run, and can interpret if received feedback matches expected results, and helps data scientists refine the algorithm. Experience in data management, creating, maintaining, and updating data records contained in the data catalog.

Database Tools: PostgeSQL, MongoDB, S3, ElastiCache, SCT, DMS, Apache NiFi, AWS Data Pipeline, DIA’s Collaborative Operations & Development Environment (CODE)

Must currently hold a TS/SCI with CI Poly clearance.

• MA/MS in in Science, Engineering, or Mathematics along with 7-9 years of intelligence experience

• 8+ years’ experience with complex SQL queries, stored procedures, functions, and views; 3+ years’ experience with Sybase; 8+ years’ experience with SQL Server

• A desire to work in a dynamic team environment

• Experience in data management, creating, maintaining, and updating data records contained in the data catalog.

• AWS Certified Cloud Practitioner, Security+ Certification

Applied Research Associates, Inc. (aka ARA) is an employee-owned international research and engineering company known for providing technically superior solutions to complex and challenging problems in the physical sciences. We were founded in Albuquerque, NM in 1979 as the disco era was, thankfully, closing out and the personal computer era was beginning. We employ over 1,500 professionals and continue to grow. ARA offices throughout the U.S. and Canada provide a broad range of technical expertise in defense, civil, and health technologies, computer software and simulation, systems analysis, environmental technologies, and testing and measurement.

ARA also prides ourselves on having a challenging culture where innovation & experimentation are the norm. At ARA, employees are our greatest assets, so we give our employees the tools, training, and opportunities to take active roles as owners. The motto, “Engineering and Science for Fun and Profit” sums up the ARA experience. The company realizes employee ownership spawns greater creativity and initiative along with higher performance and customer satisfaction levels. We are also very proud of our Women’s Initiative Network (WIN) whose purpose is to motivate, support, and encourage professional career development for women to maximize career and professional accomplishments.

To find out more about the Intelligence, Surveillance & Reconnaissance Division visit our website at: https://www.ara.com/raleigh/

• 7 - 9 years: Relevant Work Experience

• Masters or better in Engineering or related field

• Top Secret w/Poly

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)