ETL Engineer

Be Challenged and Make a Difference In a world of technology, people make the difference. We believe that 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: This position will provide the opportunity to make a significant impact on the mission while also allowing the candidate to grow their skills and career. The successful candidate will need to be able to maintain existing software as the transition from server-based to cloud-based occurs. The candidate will work with a GOTS- based Extract, Transform and Load (ETL) system that loads information into a Postgres database with billions of rows and deals with a file repository that is in a Petabyte range. In addition, the candidate will be heavily involved in the engineering planning and transition of the existing system software/data into a Cloud-based (currently AWS) solution. Required Qualifications: 6 or more years of extraction, transformation, and loading (ETL) experience Experience with Java or Python for ETL Experience with SQL (Postgres or Oracle) Experience with scripting for data ingest Experience with Linux (CentOS/RedHat) and Windows environments Experience with web services and microservices Excellent communication skills Active Top Secret Security Clearance Bachelor’s degree in Computer Science, Information Systems or related discipline Preferred Qualifications: Experience with SpringBoot Experience with AWS cloud development Experience working within agile methodology 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!