Data Acquisition ETL Engineer (TS/SCI)
Reston, VA, United States
Red Gate Group
Red Gate is a certified SDVOSB whose core services include intelligence analysis, strategic planning, policy development, operational design, and technology integration services.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
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+
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
Tags: Agile Airflow Architecture Business Intelligence ETL JavaScript Kafka Kanban Kubernetes Pentaho PostgreSQL RDBMS Scrum Security Streaming XML
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open AI Engineer jobs
- Open Senior Data Architect jobs
- Open Power BI Developer jobs
- Open Data Analytics Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Databricks-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs