Job Description

Federal Hill Consulting is building a team of TS/SCI Developers to support a large program in Reston, VA using cutting edge technologies. Come and join a winning team and support counter-terrorism efforts.

The ETL Developer will maintain responsibility for the design, development, and maintenance of Extract, Transform, and Load (ETL) workflows and scripts for a large analytic data Cloud project. Leverage Pentaho Kettle combined with thorough knowledge of data modeling, ETL, SQL scripting, and analytical expertise to extract a wide variety of structured, un-structured, and semi-structured reporting into a schema-less Accumulo database. Design, develop, test, implement, and support innovative and optimal data solutions.


In this role you will:

·       Interact with websites, web services, e-mail feeds, etc., learning about the network interaction on the http/https level including security, cookies, headers, and processing attachments to extract information

·       Learn the details of JavaScript/AJAX/JQUERY DOM implementations, certificate exchanges, and web bots as they are used to extract information for REGEX ETL transformations


Basic Qualifications:

·       BS degree in IT, CS, Computer Engineering, or Systems Engineering preferred

·       1+ years of experience with Java and JavaScript

·       1+ years of experience with relational databases

·       1+ years of experience in the development, maintenance, and enhancement of data mappings, work-flows, and processes

·       Experience with ETL development and processes from diverse data sources

·       Experience with data modeling concepts

·       TS/SCI is required


Additional Qualifications:

·       Experience with PostgreSQL, Pentaho Kettle, Accumulo, SOLR, NetOwl, Tableau, and PhantomJS

·       Experience with a variety of data feed types, including RSS, SOAP, and REST

·       Experience with DoD or IC clients

·       Experience as a database administrator

·       Knowledge of the Agile software development process, including Kanban

·       Possession of excellent oral and written communication skills

·       DoDD 8570 Compliance Certification, including Security+

·       Database Administration, ETL, or Business Intelligence-related certifications preferred

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online