Data Integrator (TS/SCI)

Zachary Piper Solutions is seeking a Data Integrator to support a critical intelligence and analytics program for DIA/NGA across various locations throughout the D.C. Metropolitan area. 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/ SCI - ability to obtain CI Polygraph

Location: Annapolis Junction, MD

This job opens for applications on 3/12/2025. Applications for this job will be accepted for at least 30 days from the posting date

Responsibilities of the Data Integrator:

• Collaborate with a team of developers to address data integration requirements.
• Write and maintain code using an Extract-Transform-Load (ETL) platform to format data according to IC ITE initiatives.
• Interface with external teams and systems to gather data via various protocols, including HTML and SFTP.
• Enhance the ETL platform with new features to streamline future data integration efforts.
• Develop and maintain code, integrating software into a complete and functional system.
• Work with external teams to verify data ingestion.
• Utilize object-oriented programming languages (Java and Python) to read and manipulate data.
• Document and maintain system architecture, development processes, and enhancements.

Qualifications of the Data Integrator:

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

· Bachelor's and 8 or more years' experience

• Linux/Unix experience
• Object Oriented programming language experience:
  • Programming languages: PHP, Python, C#, Java
• 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 - $150,000 - $200,000+

· Full Benefits: PTO, Sick leave as required by law, 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