Halfaker and Associates, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Digital Services, Data Analytics, Cyber Security and Cloud Services to improve the health, security and well-being of all Americans. Our commitment to excellence and our vision to “Continue to Serve” has resulted in steady growth and an expanding client base across government agencies in the health, defense, security and intelligence sectors. Our strong focus on internal culture has helped Halfaker achieve several workplace awards including Great Place to Work Certification™ and Tampa Bay Top Workplaces. Headquartered in Arlington, VA, we have employees nationwide. Please take a moment to browse through our website and learn more about what it means to serve with Halfaker.

Halfaker has an opening for a Software Engineer (ETL Developer) to join our talented, dynamic team. The key responsibilities for this position include:

• 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

Required Skills

• 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
• Experience with XML, JSON, 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
• DoDD 8570 Compliance Certification, including Security+

Required Experience

• TS/SCI clearance required
• High School diploma or GED required, Bachelor’s degree preferred

Halfaker and Associates, LLC, is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/ Affirmative Action Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. U.S. Citizenship is required for most positions.