Data Acquisition ETL Engineer (TS/SCI)

Beyond SOF; Reston (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Beyond SOF in Reston, VA seeks a Data Acquisition ETL Engineer (TS/SCI) for a full-time position. You will join a team to develop workflows to acquire, analyze, manage, maintain, and evaluate ETL capabilities to sustain a timely data corpus.

You will determine data ingest quality issues and propose eliminations, assist with data ingest processes, and provide SME support for IT/ETL provisioning. The role requires Java, streaming data, HTML/JS, ETL development, and relational databases experience,

Qualifications

• 2+ years of Java experience.
• 1+ years with a streaming data framework (Kafka).
• 1+ years web-based architecture (HTML/JavaScript).
• 1+ years ETL development from diverse data sources.
• 1+ years data mappings, workflows, processes.
• 1+ years Relational Databases experience.
• Experience with data feeds: RSS, SOAP, REST.
• Experience with data modeling concepts.
• TS/SCI clearance required.
• HS diploma or GED required.

Responsibilities

• Develop workflows to acquire, analyze, and maintain ETL data.
• Identify data ingest quality issues and propose fixes.
• Provide SME support to provision IT and ETL.

Skills

Java

Kafka

HTML/JavaScript

ETL development

Data mappings

Relational databases

Data feeds (RSS/SOAP/REST)

Data modeling

Education

Bachelor's/B.A./B.S. degree preferred

HS diploma or GED

CompTIA Security+ certification preferred

Tools

NiFi

Airflow

PostgreSQL

Kubernetes

Job description

Data Acquisition ETL Engineer (TS/SCI)

Reston, VA, USA
Full-time
Clearance: Top Secret/SCI

Job Description

Serve as a data acquisition engineer performing Extract Transform Load (ETL) requiring an individual who is hard-charging, self-starting, and a problem solver; able to work through complex problems with great attention to detail. The individual will be part of a team created to develop workflows to acquire data, analyze, manage, maintain, and evaluate state-of-the-art extraction, transforming, and loading (ETL) capabilities to maintain a timely data corpus. Determine data ingest quality issues and propose recommendations for their elimination. Assist with the formulation of data ingest processes. Provide subject matter support to provision information technology and ETL.

Serve as a data acquisition engineer performing Extract Transform Load (ETL) and work through complex problems with great attention to detail. Perform as a part of a team created to develop workflows to acquire data, analyze, manage, maintain, and evaluate state-of-the-art extraction, transforming, and loading capabilities to maintain a timely data corpus. Determine data ingest quality issues and propose recommendations for their elimination. Assist with the formulation of data ingest processes. Provide subject matter support to provision IT and ETL.

Qualifications

• 2+ years of experience with Java


• 1+ years of experience with a streaming data framework, including Apache Kafka


• 1+ years of experience with web-based architecture, including HTML and JavaScript


• 1+ years of experience with ETL development and processes from diverse data sources


• 1+ years of experience with the development, maintenance, and enhancement of data mappings, work-flows, and processes


• 1+ years of experience in working with Relational Databases


• Experience with a variety of data feed types, including RSS, SOAP, and REST


• Experience with data modeling concepts


• TS/SCI clearance required


• HS diploma or GED

Additional Qualifications:

• Experience with XML, and TXT transformations, including writing and applying XSLT to transform data


• Experience with any of the following technologies: Apache Kafka, NiFi, Airflow, PostgreSQL, Pentaho Data Integration, Accumulo, Solr, Elastic Stack, Firefox, Chromium, or Kubernetes


• Experience with DoD or IC clients


• Experience as a database administrator


• Experience with web scraping, including Document Object Model (DOM) exploration


• Knowledge of the Agile software development process, including Scrum and Kanban


• Ability to map and document needed data elements in multiple databases to aggregate them under one schema


• BA or BS degree preferred


• Database Administration, ETL, or Business Intelligence-related Certifications preferred


• ComptTIA Security+