Data Engineer (Senior / Mid-Level) – ETL / Cloud / AWS – Top Secret Clearance

The Data Engineer role focuses on ETL, cloud-based data integration, and data migration, with onsite responsibilities in Huntsville, AL, and an active Top Secret clearance required.

Responsibilities

• Design, develop, and maintain ETL workflows to extract, transform, and load large-scale structured and unstructured datasets.
• Develop data migration solutions between legacy and modern systems using SQL, Java, and cloud-native tools.
• Implement data integration frameworks leveraging AWS services such as Glue, Lambda, S3, RDS, Redshift, and Kinesis.
• Develop automation scripts using Python, Shell, or Bash for deployment, data validation, and maintenance tasks.
• Maintain and enhance data pipelines for real-time and batch data processing.
• Support data quality, metadata management, and governance activities.
• Participate in Agile/Scrum sprints, contributing to design, code reviews, testing, and documentation.
• Troubleshoot and resolve data-related issues across on-premises and AWS environments.

Requirements

• 5+ years of experience in data engineering or database development for mid-level roles, or 8+ years for senior roles.
• Strong hands-on experience with ETL tools such as Informatica, Talend, Pentaho, AWS Glue, or custom Java ETL frameworks.
• Proficiency in SQL and at least one major RDBMS such as Oracle or PostgreSQL.
• Experience with data migration projects and data quality validation.
• Proficient in Java or Python for data processing and automation.
• Experience with cloud technologies, preferably AWS (RDS, S3, Lambda, Redshift, Glue).
• Working knowledge of Linux/Unix environments and shell scripting.
• Experience in an Agile/Scrum development environment.
• Excellent problem-solving, analytical, and communication skills.

Technologies

• AWS Glue, AWS Lambda, AWS S3, AWS RDS, AWS Redshift, AWS Kinesis
• Java, Python, SQL
• Oracle, PostgreSQL, MongoDB
• Informatica, Talend, Pentaho
• Linux, Unix, Shell scripting

Benefits

• 3 weeks of Paid time off (PTO) including sick leave
• 2 floating holidays
• 8 public holidays
• 50% employer-paid health and dental insurance for all full-time employees; dependents at extra cost
• Health and dental coverage becomes effective after 30 days or first of the month after initial 30 working days; 50% coverage for the employee
• Short-Term Disability (STD), Long-Term Disability (LTD) and a one-time salary equivalent of life insurance at no cost to all full-time employees
• 401k with company match of 4% after 90 days; immediate vesting
• Profit sharing for all W-2 employees; no employee contributions required

Location

Huntsville, Alabama (100% Onsite)

Clearance Required

Active Top Secret Clearance (U.S. Citizenship Required)

Employment Type

Full-Time / Permanent/1099 Consultant

Education

Bachelor’s Degree (B.S.) in Computer Science, Information Systems, Engineering, or related field