Description of Task to be Performed:
We are seeking a talented and motivated ETL Engineer to design, build, and optimize high-performance data pipelines and ETL processes powering a web-based search and analytics application. This role requires the extraction, transformation, and loading of data from various sources (including relational databases and file formats), developing data adapters in Python, and fine-tuning workflows for speed and scale.
This position is hybrid with one to three days per week in Chantilly VA.
The position requires a Top Secret clearance and SCI eligibility with the ability to pass a CI polygraph.
Required Qualifications:
- Active Top Secret clearance and SCI eligibility with the ability to pass a CI polygraph.
- Bachelor’s degree in computer science, Information Systems, Engineering, or related field (or equivalent experience).
- 5+ years of experience in data engineering, including
- Building ETL/ELT pipelines
- SQL query optimization
- Working with relational databases such as Oracle, PostgreSQL, MySQL, or MSSQL
- Experience with high level languages such as Python, Java or C#.
- 3+ years of experience in Python development, with a focus on ETL processes.
- Experience with Elasticsearch or OpenSearch.
- Experience with version control systems (e.g. GIT) and collaborative coding practices.
- Experience working in an Agile Scrum environment.
- Experience with scripting languages (e.g., Bash).
- Experience with containerization technologies (e.g., Docker).
- Experience working in Linux environments.
Preferred Qualifications:
- Knowledge of data quality, validation and monitoring frameworks, along with data governance, metadata management, and data lineage best practices.
- Strong understanding of data transformation, cleansing, and normalization concepts.
- Experience with data warehousing, big data frameworks, and API-based data integration from enterprise source systems.
- Excellent problem-solving skills and attention to detail.
- Generous cost sharing for medical insurance for the employee and dependents
- 100% company paid dental insurance for employees and dependents
- 100% company paid long-term and short-term disability insurance
- 100% company paid vision insurance for employees and dependents
- 401k plan with generous match and 100% immediate vesting
- Competitive Pay
- Generous paid leave and holiday package
- Tuition and training reimbursement
- Life and AD&D Insurance
Skills Required
- Active Top Secret clearance with SCI eligibility and ability to pass a CI polygraph
- Bachelor's degree in computer science, information systems, engineering, or a related field, or equivalent experience
- 5+ years of experience in data engineering
- Experience building ETL/ELT pipelines
- Experience optimizing SQL queries
- Experience with relational databases such as Oracle, PostgreSQL, MySQL, or MSSQL
- Experience with Python, Java, or C#
- 3+ years of Python development experience focused on ETL processes
- Experience with Elasticsearch or OpenSearch
- Experience with Git or other version control systems and collaborative coding practices
- Experience working in an Agile Scrum environment
- Experience with scripting languages such as Bash
- Experience with containerization technologies such as Docker
- Experience working in Linux environments
- Knowledge of data quality, validation, and monitoring frameworks
- Knowledge of data governance, metadata management, and data lineage best practices
- Strong understanding of data transformation, cleansing, and normalization
- Experience with data warehousing, big data frameworks, and API-based enterprise data integration
- Excellent problem-solving skills and attention to detail
What We Do
AnaVation is a trusted partner that delivers high-value, cost-effective solutions to solve our customers’ most complex technical and analytical problems. AnaVation believes that the future of securing, collecting, processing, and analyzing cyber data will require the development of advanced ANAlytical technologies derived via the innoVATION of current and future technologies. AnaVation believes in the “Idea of the Possible” — that it is possible for our experts, partnering with our customers in the right environment, to create innovative technical solutions that expand our customers’ capabilities. We want to do two things for our customers. We want to resolve existing challenges and we want to prepare them for the future. Our technical expertise and innovative engineering culture enable us to do those things.
.jpeg)
