What are the responsibilities and job description for the Junior Data Engineer position at AnaVation?
Be Challenged and Make a Difference
In a world of technology, people make the difference. We believe if we invest in great people, then great things will happen. At AnaVation, we provide unmatched value to our customers and employees through innovative solutions and an engaging culture.
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.
- 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
- 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.
Benefits
- 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
About AnaVation
AnaVation is the leader in solving the most complex technical challenges for collection and processing in the U.S. Federal Intelligence Community. We are a US owned company headquartered in Chantilly, Virginia. We deliver groundbreaking research with advanced software and systems engineering that provides an information advantage to contribute to the mission and operational success of our customers. We offer complex challenges, a top-notch work environment, and a world-class, collaborative team.
If you want to grow your career and make a difference while doing it, AnaVation is the perfect fit for you!
AnaVation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.