ETL Developer (SME)

$175,000 - $225,000/Yr

Hoplite Solutions - Reston, VA

Full-time - Senior

Reston, VA

Professional, Scientific, and Technical Services

About the position

The ETL Developer (SME) position is focused on providing Agile DevOps support for mission-critical systems. The role involves designing, developing, and implementing tools and applications for Extracting, Transforming, and Loading (ETL) data into an enterprise Data Lake. The developer will work within a DevOps framework, participating in all aspects of the software development lifecycle, and will be responsible for optimizing data processes and ensuring the effective management of large-scale data.

Responsibilities

• Designing and implementing a large scale ingest system in a big data environment.
• Reading, analyzing, and digesting enterprise data needs to design optimal ELT processes.
• Recommending methodologies to optimize visualization, organization, storage, and availability of large scale data.
• Participating in software programming initiatives using HTML, CSS, JavaScript, Java, Python, SpringBoot, and Hibernate.
• Developing and directing software system validation and testing methods using Junit and Katalon.
• Developing and integrating custom software solutions leveraging automated deployment technologies.
• Prototyping and deploying solutions within Commercial Cloud Solutions leveraging Infrastructure platform services.
• Analyzing infrastructure needs driven by developed software to meet customer mission needs.
• Supporting the Agile software development lifecycle following Program SAFe practices.
• Using industry-leading DevOps tools like GitHub, Jenkins, and Unix bash scripting.
• Documenting and performing systems software development, including deployment of build artifacts across different environments.
• Coordinating closely with team members, Product Owners, and Scrum Masters to ensure User Story alignment and implementation to customer use cases.
• Communicating key project data to team members and building team cohesion and effectiveness.

Requirements

• Active TS/SCI with a polygraph
• Masters with 15+ years of prior relevant experience
• Experience performing ETL activities including parser development and deployment, data flow management, and troubleshooting data access issues
• Experience with data modeling
• Extensive experience with relational databases, such as MySQL, utilizing SQL queries
• Extensive experience using Java for data processing, manipulation, or querying (SQL or NoSQL)
• ETL/Data Integration experience using Spring, NiFi, Kafka, and Elasticsearch
• Experience with development in Commercial Cloud Platforms (AWS, Google Cloud, Azure)
• Experience with development leveraging cloud data services (S3, RDS, EFS)
• Experience leading development scrum teams

Nice-to-haves

• Demonstrated experience using Neo4J

Benefits

• 401(k) with 7% match
• Disability insurance
• Life insurance
• Fully paid healthcare for employees
• Outstanding training benefits
• Company funded life insurance and short-term disability insurance