You are here

Data Engineer/Developer

Washington, D.C.


Position Description

JPI is seeking a Data Engineer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing solutions that empower our Federal customers with the tools and capabilities needed to turn data into actionable insights. The ideal candidate is a critical thinker and motivated, perpetual learner and is excited to gain exposure and build skillsets across a range of technologies while solving some of our clients’ toughest challenges. As a Data Engineer, you will be integral to data operations for the development and integration of multiple data types across a range of data sets and sources.

You will be responsible for the day-to-day operations of systems that depend on data, ensuring data is properly processed and securely transferred to its appropriate location, in a timely manner.  Processing data will include managing, manipulating, storing and parsing data in a data pipeline for variety of target sources. You will also support maintenance of applications and tools that reside on these systems such as upgrades, patches, and configuration changes. The work is performed in a multidisciplinary team environment using agile methodologies. The candidate we seek must be highly motivated and enthusiastic about implementing new technologies and learning about new data in a small team environment where deadlines are important.



  • ​Work closely with software engineers and architects to extract, transform, and standardize data to prepare for ingest into target sources
  • Design and develop data services and/or pipelines as part of an Agile/Scrum team
  • Support continuous process automation for data ingest
  • Work with program management and engineers to implement and document complex and evolving requirements
  • Perform multiple tasks simultaneously and successful perform under changing requirements and deadlines
  • Help cultivate an environment that promotes customer service excellence, innovation, collaboration, and teamwork
  • The person shall apply established engineering and management principles to specifications and documentation of systems developed


​​Basic Requirements:

  • Must be a US Citizen
  • Must be able to obtain a DHS Public Trust
  • 7+ years of IT experience including experience in design, management, and solutioning of large, complex data sets and models.
  • Experience handling multiple tasks, changing priorities, and timely action
  • Experience with developing data pipelines from many sources for structure and unstructured data sets in a variety of formats
  • Proficiency developing data extraction, transformation, and loading (ETL) processes, and performing test and validation steps
  • Proficiency with Python, R, and SQL languages, as well as various command line interfaces (Linux, AWS, Git Bash, etc.)
  • Demonstrated experience translating business and technical requirements into comprehensive data strategies and analytic solutions
  • Mid-level expertise in developing and managing data technologies, technical operations, reusable data services, and related tools and technologies
  • Demonstrated ability to adequately plan and meet delivery objectives and maintain adequate service levels in a highly dynamic, complex environments
  • Experienced in optimizing database querying, data manipulation and population using SQL and PL/SQL in Oracle, MySQL, PostgreSQL databases
  • Hands on experience with software upgrade and deployment documentation
  • Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR, SNOWFLAKE schema, Fact and Dimension tables
  • Good understanding of development lifecycle of projects with PostgreSQL database, Azure Cloud platform and Power BI and Tableau Visualization Tools
  • Experience writing and modifying ETL design documentation, Test case documentation and standard operating procedures (SOP) documentation
  • Experience in developing Shell scripts on UNIX
  • Familiarity with Hive, Hadoop, Kylin, and other big data analytic tools

Additional/Desired Requirements:

  • Experience with DHS and knowledge of DHS standards a plus
  • Demonstrated experience translating business and technical requirements into comprehensive data strategies and analytic solutions
  • Demonstrated ability to communicate across all levels of the organization and communicate technical terms to non-technical audiences with an impeccable attention to detail



JPI is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Files must be less than 10 MB.
Allowed file types: txt rtf pdf doc docx.
Copy and paste resume here if you do not wish to upload.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
2 + 11 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.