Description of Task to be Performed:
We are seeking a talented and motivated Junior or Mid-Level Data Engineer to join our dynamic team. In this role, you will design, build, and support integrations between an enterprise case management platform and supporting systems. This position plays a critical role in ensuring reliable data exchange, system performance, and end-to-end workflow continuity across systems.
In this role, you’ll ensure seamless integration between critical systems, maintain data accuracy and performance, and support modernization efforts that enhance operations.
This position is hybrid with one to three days per week in Chantilly, VA or Woodbridge, VA.
The candidate will be required to pass a high-risk public trust background investigation
Position Responsibilities:
- Build and maintain data integration pipelines, APIs, and middleware services.
- Design scalable data models and schemas.
- Optimize SQL queries, database structures, and backend performance for large-scale systems.
- Support system integrations to ensure accurate tracking and workflow alignment.
- Implement data validation, auditability, and controls, including role-based access and security compliance.
- Contribute technical leadership on system architecture, integration patterns, and solution design.
- Assist with system migrations, ensuring smooth transitions from legacy platforms.
- Develop logic to cleanse, transform, and normalize data into a standard data model.
- Write and optimize SQL queries to extract and manipulate data efficiently.
- Collaborate as part of an Agile Scrum team, contributing to sprint planning, daily stand-ups, and retrospective meetings.
- Perform rigorous testing and debugging to ensure the stability and performance of data adapters.
- Optimize ETL pipelines for scalability and efficiency.
- Prepare and maintain technical documentation for all development work.
Required Qualifications:
- Bachelor’s degree in computer science, Information Systems, Engineering, or related field (or equivalent experience).
- 3+ 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#
- Proficiency in data modeling, integration patterns, and middleware architecture.
- Strong troubleshooting and problem-solving skills.
- Familiarity with version control systems (e.g., Git).
- Excellent written, verbal, and cross-team communication skills.
- Top Secret clearance or High Risk Public Trust Suitability
Preferred Qualifications:
- Experience with Palantir or optimizing data-intensive applications.
- Background in system migrations or modernizations, particularly in secure or regulated environments.
- Knowledge of investigative or laboratory data workflows.
- 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
Top Skills
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.
