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

Visual Soft, Inc offers a comprehensive benefits package and an onsite opportunity in Huntsville, Alabama. This Data Engineer role concentrates on ETL design, cloud based data migration, and secure data handling, and requires an active Top Secret clearance. The position emphasizes practical problem solving, collaboration, and delivering reliable data pipelines in both real time and batch contexts.

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 additional cost
• Health and dental coverage becomes effective after 30 days or the first of the month after initial 30 working days; 50% coverage for the employee
• Short-term disability, long-term disability, and life insurance at no cost to all full-time employees; life insurance is provided as a benefit
• 401(k) with a company match of 4% after 90 days; immediate vesting
• Profit sharing for all W-2 employees; no employee contributions required

Responsibilities

• Design, develop, and maintain ETL workflows to process large-scale structured and unstructured data
• Build data migration solutions bridging legacy systems and modern platforms using SQL, Java, and cloud-native tools
• Implement data integration pipelines leveraging AWS services such as Glue, Lambda, S3, RDS, Redshift, and Kinesis
• Develop automation scripts in 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

Location: Huntsville, Alabama (100% onsite)

Education: Bachelor’s Degree in Computer Science, Information Systems, Engineering, or related field

• 5+ years for Mid-Level or 8+ years for Senior-level experience in data engineering or database development
• 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 (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
• Clearance: Active Top Secret Clearance (U.S. Citizenship Required)

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

Employment Type: Full-Time / Permanent / 1099 Consultant