Security Clearance: Active TS/SCI with FS Polygraph required

Covid-19 Vaccination: Being fully vaccinated is required

Position

• Apogee’s ideal candidate is a motivated, self starting Professional who is comfortable working in a dynamic team. If you thrive in providing Data Ingest support, then you’ll love Apogee and this position.
• The Data Ingest/ETL Engineer will serve as a data acquisition engineer performing Extract Transform Load (ETL) requiring an individual who is hard charging, self-starting, and a problem solver; able to work through complex problems with great attention to detail.
• The individual will be part of a team created to develop workflows to acquire data, analyze, manage, maintain, and evaluate state-of-the-art extraction, transforming, and loading (ETL) 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 information technology and ETL.

What You’ll Do

• 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.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

• Bachelor’s Degree with approximately 2 years of experience
• 2 years of experience with Java
• 1 year of experience with a streaming data framework, including Apache Kafka
• 1 year of experience with web-based architecture, including HTML and JavaScript
• 1 year of experience with ETL development and processes from diverse data sources
• 1 year of experience with the development, maintenance, and enhancement of data mappings, work-flows, and processes
• 1 year 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

Strongly Desired Skills

• Experience with XML 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 with database administration
• 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
• Database Administration, ETL, or Business Intelligence-related Certifications
• DoDD 8570 Compliance Certification, including Security+

What You’ll Love About Apogee

• Challenging work in support of US Intel Community – a Mission that Matters!
• Access to our cool ApogeePlex facility.
• Support for new ideas & encouragement to take risks

• Professional Development Assistance (PDA)
• Wicked smart and collaborative coworkers
• Regular interfacing with company leadership

• 401(k) with huge company match
• Paid Time Off / Floating Holidays
• Medical, Dental, Vision
• Life Insurance
• Disability (Short and Long Term)
• Accidental Death and Dismemberment (AD&D)
• Health Savings Accounts / Dependent Care Flexible Spending Accounts

Apogee’s Mission

• Be the PROVIDER of choice for government & commercial organizations with an unwavering commitment to responsiveness, accuracy, integrity, collaboration, and innovation.
• Be the EMPLOYER of choice committed to an open & transparent corporate atmosphere and progressive culture that attracts and empowers world class professionals to explore cutting-edge technical solutions while fostering professional growth.
• Be the preferred SOURCE for cutting-edge Analytic Products, Systems & Software Engineering, Big Data Integration, IT and Business Services that directly contribute to customer success

Apogee is an M/F Disabled and Vet EEO/AA Employer