Job Details

Description

Must be a U.S citizen

Clearance: Active TS/SCI with the ability to obtain a CI Poly

Job Summary

We are currently seeking a Joint ISR Data Analyst to support the exploration, identification, extraction, transformation, and loading, and visualization of ISR-related data sources. The analyst in this position will provide management assistance for maintaining a warehouse of ISR-related data. The position also supports automation of data gathering, as well as data cleaning for customer use. This individual will assist in analytic analysis of collected data using specified Commercial Off the Shelf (COTS) Computer Software (CS), Government Off the Shelf (GOTS) CS, or other data analytics CS. The analyst will also provide digital content and knowledge management assistance services for essential J32 ISR mission data using specified COTS, GOTS, or other content management CS and computer software services.

Specific Responsibilities

• 
  

  Implements and optimizes the computerized database systems that support the customers' ability to function on a daily basis.

  
  


• 
  

  Implements and maintains smooth operation and physical design of databases.

  
  


• 
  

  Conducts performance tuning of indexes and databases, reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements.

  
  


• 
  

  Maintains security and integrity controls, formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.

  
  


• 
  

  May develop stored procedures and/or triggers.

  
  


• 
  

  Administers a variety of database systems, such as Microsoft SQL Server, and other Database Management Systems (DBMS).

  
  


• 
  

  Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands.

  
  


• 
  

  Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites.

  
  


• 
  

  Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems.

  
  


• 
  

  Reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Crystal Reports; researches and implements new database and online technology.

  
  

Qualifications

• 
  

  At least six (6) years of relevant experience.

  
  


• 
  

  Microsoft SharePoint front-end development and design.

  
  


• 
  

  Data Analytics Software such as Tableau for data visualizations.

  
  


• 
  

  ArcGIS Portal & Insights for map creation and analysis.

  
  


• 
  

  Microsoft Excel VBA (Visual Basic for Applications) for data normalization.

  
  


• 
  

  Data statistical analysis software.

  
  


• 
  

  Performing data cleansing and normalization.

  
  


• 
  

  ISR and collection management experience.

  
  


• 
  

  Ability to identify and discern gaps in ISR data required to establish a credible ISR database.

  
  


• 
  

  Experience in evaluating and prioritizing ISR data sources.

  
  


• 
  

  Capable of establishing and improving customer access to ISR data.

  
  


• 
  

  Building of data dashboards with access by customers.

  
  


• 
  

  Understanding of the military operational environment.

  
  


• 
  

  Understanding of defense collection management processes and supporting databases.

  
  


• 
  

  Data warehouse management.

  
  


• 
  

  Using COTS or GOTS data analytic software.

  
  


• 
  

  Content management using COTS, GOTS, or other content management programs and services.

  
  


• 
  

  Proficient in Microsoft Office Products.

  
  

Physical Requirements and Work Environment

• 
  

  Normal office environment.

  
  

Travel

• 
  

  Local travel within the National Capital Region up to 10%.

  
  

Company Description

Obsidian Solutions Group, LLC (OSG) is a fast-growing professional services firm with corporate office located in Fredericksburg, VA. OSG creates value for our customers by delivering technology-enabled & mission-oriented technical solutions that solve complex problems, protecting people, information, and assets. Our core capabilities are in providing Enterprise IT, Intelligence Analysis, Production & Development and Knowledge-Based Professional Services Solutions that enable the customer's mission. OSG is a certified 8(a), service-disabled, veteran-owned small business.

A career at OSG means you are able to put your expertise, credentials, and talents to great use working with customers in the DOD and Intelligence Community, while enjoying the excitement of working in a fast-growing organization committed to making a difference for our customers and in our community. Contribute independently and work collaboratively alongside an amazing team of doers and thinkers. OSG is small enough to offer a family atmosphere yet large enough to deliver a highly competitive compensation package. We hire and retain the best in the industry, offering exceptional benefits that protect the well-being of our employees, their spouses and domestic partners, and their families.

Our corporate philosophy is centered on hiring and retaining employees with the requisite skills, professional experience, personal commitment, and ethical standards necessary to foster a culture of operational excellence necessary to surpass our customer's expectations.