Data Engineer

Job Title
Data Engineer
Job ID
Pittsburgh,  PA 15201
Other Location

Data Engineer 

Pittsburgh, PA (Hybrid)  
Must be a US Citizen
Possess an active Secret clearance or have the ability to obtain one 

@Orchard LLC has been retained to identify a Data Engineer to work for an emerging software as a service provider of Decision Support Solutions, targeting the Federal Government. Our client is a decision science firm dedicated to transforming the business of national security through data science and machine learning. Through its National Security Knowledge Graph and Decision Science Platform, our client delivers objective, decision-grade information at scale to the national security enterprise, so that leaders can better direct investments to innovation and modernization.

As a Data Engineer you will:
You will be a core member of the product and engineering team dedicated to helping our clients replace time-consuming, manual processes to reach informed real-time decisions about government markets, competitors, and agency relationships.

Specific Responsibilities:
  • Define and lead the data lifecycle strategy across data acquisition, data ingestion, data cleansing, normalization and linkage. 
  • Ensure key entities within datasets are identified, resolved and linked to existing entities within the current master data repository.
  • Apply various techniques to produce solutions to large-scale optimization problems, including data pre-processing, indexing, blocking, field and record comparison and classification.
  • Improve data sharing, increase data repurposing and improve cost efficiency associated with data management efforts. 
  • Build best practices that help with chain of custody of data so it can be easily traced back to the source for accuracy and consistency.
  • Work across functional teams to understand advanced statistical, machine learning, and text processing models and incorporate them into existing data engineering infrastructure.
  • Perform exploratory data analyses, generate and test working hypotheses, prepare and analyze historical data and identify patterns.
  • Work directly with users as well as SMEs to establish, create and populate optimal data architectures and structures, as well as articulate techniques and results using non-technical language.
Your background will include:
  • Must be able to work in the United States without visa sponsorship now or in the future
  • Bachelor's degree in Computer Science, Mathematics or related technical field 
  • 3-5 years experience with programmatically transforming data 
  • Experience with RDBMS
  • Advanced SQL programming skills
  • Proficient usage of common data formats such as CSV, XML, and JSON
  • Requires strong analytical ability and attention to detail
  • Ability to work independently with little supervision
  • A burning desire to tackle hard problems and create sustainable solutions
  • Experience using Amazon Web Services is highly desired 
  • Experience in or exposure to the nuances of a startup or other entrepreneurial environment is desired 
  • Working knowledge with large (multiple terabytes) amounts of data is desired 
Established in 2010, @Orchard LLC, also known as, Talent Orchard has an exceptional reputation, providing staffing solutions to time-sensitive, talent scarcity issues to deliver better talent management ROI.  Our specialty lies in the critical area of program talent acquisition and resource management, not in one narrow skillset, but across many areas of technical and functional delivery. To learn more about our other exciting opportunities, visit our Jobs Page at

Option 1: Create a New Profile