Data Integrator (Top Secret)

Zachary Piper Solutions is seeking a Data Integrator to support a critical intelligence and analytics program for DIA/NGA across various locations throughout the DMV. The team is seeking a skilled engineer to perform high volume data transfer and integration tasks for an application development and sustainment program.

Clearance: Top Secret - will obtain SCI and CI Polygraph

Location: Reston, VA; Washington, D.C.; College Park, MD  

Responsibilities of the Data Integrator:

• Work with a team of developers on data integration requirements.
• Write and maintain code using an Extract-Transform-Load (ETL) platform to transform data to suitable formats as defined by IC ITE initiatives.
• Interface with external teams and systems to collect data via myriad protocols including HTML and SFTP
• Add features to ETL platform to shorten timelines for future data integration efforts.
• Develop and maintain code and integrate software into a fully functional software system.
• Work with external teams to validate data ingest.
• Utilize object oriented programming languages (Java & Python) to read and manipulate data
• Provide and maintain documentation of system architecture, development, and enhancements.

Qualifications of the Data Integrator:

·      Active Top Secret/SCI (ability to obtain CI Polygraph)

·      Bachelor’s and 5 or more years’ experience

• Linux/Unix experience
• Object Oriented programming language experience:
  • Programming languages: PHP, Python, C#, Java
  • Abstraction
  • Encapsulation
  • Polymorphism
  • Inheritance: Single, multiple, and multilevel
  • Understanding objects and classes
  • Experience working with interfaces
• Expertise in data ingestion, data transformation (ETL), and data modeling.
• Experience with C, Python, Java, PHP, or C++ for ETL creation and data manipulation
• One year working with Restful web services, NoSQL, PostgreSQL

 Compensation of the Data Integrator: 

·      Total compensation based on experience level - $130,000 - $200,000+

·      Full Benefits: PTO, Holidays, 401K, Medical Dental Vision coverage

·      Opportunity to upgrade security clearance (CI Polygraph)

·      Hybrid work, will start fully remote for (1-4 months)

Keywords: data science, data scientist, ETL, extract, transform, load, data integration, data integrator, data migration, data transfer, XML, AWS, EC2, VPC, Python, Java, Ruby, Restful, Palantir, TS/SCI, polygraph, D.C., Reston, Hybrid, python, data sets, Git, data management, data analytics, NumPy, R, data manipulation, data integration, intelligence, TS/SCI, Top secret/sci, polygraph, security clearance, HPC, High performance computing environment, prototypes, EDA, Exploratory data analysis, computational, code design, Masters, Bachelors, on site, hybrid, Maryland, Washington D.C., cloud, TensorFlow, Machine learning, artificial intelligence, natural language processing, visualization, latent semantic indexing, infrastructure, government, DOD, national intelligence, data processing, XML, Nutch, Jupyter, GIS, ArcGIS, software engineer, engineering, counterintelligence, NGA, Excel, Pandas, Scala, NGA, DIA, National geospatial agency, defense intelligence agency