Data acquisition engineer performing Extract Transform Load (ETL)

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

• 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

• Experience with XML, JSON, 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
• DoDD 8570 Compliance Certification, including Security+

Job Type: Full-time

Pay: $130,000.00 – $140,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Education:

• High school or equivalent (Preferred)

Experience:

• SQL: 1 year (Required)
• Data Warehouse: 1 year (Required)

Security Clearance:

Work Remotely:

• Yes, temporarily due to COVID-19