ETL Engineer (TS/SCI)

Company Description

At RED GATE we do everything we can to serve our clients:
Using the right technical skills, unique methodologies, best practices, and integrated technology, we help clients implement bold solutions. New approaches to emerging and evolving threats. Non-traditional ways to overcome entrenched obstacles. Advantage through opportunity. If you have a serious challenge or problem, we can help you solve it.  The below job description provides details on how this role will help to serve our clients.

Job Description

This is an opportunity to support data engineering activities on some of the most mission-driven projects in the industry. Driving counter threat efforts, you’ll have the chance to build out ETL pipelines, write custom code, interface with data stores, perform data ingestion, and build data models. From performing analytical exploration and examination of data to leading the assessment, design, building, and maintenance of scalable platforms, you’ll guide your clients to solve their most pressing challenges.

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, workflows, and processes
• 1+ years of experience in working with Relational Databases
• Experience with data feed types, including RSS, SOAP, and REST
• Experience with data modeling concepts
• DoD 8570 Compliance Certification, including Security+ Certification

Additional Qualifications: 

• Experience with XML and TXT transformations, including writing and applying XSLT to transform data
• Experience with Apache Kafka, NiFi, Airflow, PostgreSQL, Pentaho Data Integration, Accumulo, Solr, Elastic Stack, Firefox, Chromium, or Kubernetes
• Experience with DoD or IC clients
• Experience with database administration
• 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
• Database Administration, ETL, or Business Intelligence-related Certification

Additional Information

The Red Gate Group, Ltd. is an Equal Opportunity/Affirmative Action Employer. The Red Gate Group, Ltd. considers applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state, or local law. Know Your Rights