Principal Database Architect / Data Analyst 2
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 to 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. TS/SCI with CI Poly required
Database Tools: PostgreSQL, MongoDB, S3, ElastiCache, SCT, DMS, Apache NiFi, AWS Data Pipeline, DIA’s Collaborative Operations & Development Environment (CODE).
The most successful candidates have a strong technical background in science, engineering, or mathematics and a desire to continue expanding their knowledge. Expertise (and interest!) in performing data gathering suing Erwin, PostgreSQL, MongoDB or S3 is highly desirable. If this describes you, please apply!
Principal Database Architect / Data Analyst 2 Required Experience & Skills:
- Active TS/SCI with CI Poly Security Clearance.
- BA/BS in science, engineering, or mathematics along with 10-12 years Intelligence Experience or a MA/MS in a relevant technical field along with 7-9 Years 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.
Principal Database Architect / Data Analyst 2 Desired Experience: AWS Certified Cloud Practitioner, Security+ Certification.
About Us:
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/