Senior Data Engineer (Teradata/ETL) (Secret Clearance Required)

Solerity is a trusted provider of Information Technology, Engineering Services, Program Management, and Consulting Services supporting the U.S. Federal Government and Intelligence Community. They are seeking a Senior Data Engineer / ETL Developer to support the USTRANSCOM Integrated Data Environment & Global Transportation Network Convergence Program, focusing on designing and maintaining ETL pipelines and data integration workflows for mission-critical logistics systems.

Responsibilities:

• Designs, develops, and maintains enterprise ETL processes and data integration pipelines supporting large-scale data environments
• Develops and optimizes complex SQL queries, stored procedures, and database objects used for data processing and analytics
• Works with Teradata and Oracle database platforms to support large-scale data storage, transformation, and reporting
• Develops and maintains ETL workflows using Informatica PowerCenter or similar data integration tools
• Creates and maintains automation scripts using Python and Bash to support data ingestion, transformation, and operational support activities
• Supports development teams with database integration, object creation, query optimization, and troubleshooting
• Participates in data modeling, schema design, and database performance tuning to ensure scalable and efficient data solutions
• Supports code migration, data validation, and performance testing across development, test, and production environments
• Collaborates with developers, architects, and system engineers to ensure reliable and efficient enterprise data architecture

Requirements:

• Designs, develops, and maintains enterprise ETL processes and data integration pipelines supporting large-scale data environments
• Develops and optimizes complex SQL queries, stored procedures, and database objects used for data processing and analytics
• Works with Teradata and Oracle database platforms to support large-scale data storage, transformation, and reporting
• Develops and maintains ETL workflows using Informatica PowerCenter or similar data integration tools
• Creates and maintains automation scripts using Python and Bash to support data ingestion, transformation, and operational support activities
• Supports development teams with database integration, object creation, query optimization, and troubleshooting
• Participates in data modeling, schema design, and database performance tuning to ensure scalable and efficient data solutions
• Supports code migration, data validation, and performance testing across development, test, and production environments
• Collaborates with developers, architects, and system engineers to ensure reliable and efficient enterprise data architecture
• Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Science, Cybersecurity, or a related technical field from an ABET-accredited or CAE-designated institution OR Bachelor's degree in any field plus one of the following certifications: Security+ (CompTIA), FITSP-D (Federal IT Security Professional – Developer), GCSA (GIAC Certified System Administrator), GISF (GIAC Information Security Fundamentals), SSCP (Systems Security Certified Practitioner)
• 10 years of professional experience supporting enterprise IT systems, data engineering, software development, database engineering, or data integration environments
• Experience designing, developing, and supporting ETL pipelines, database solutions, or large-scale data platforms
• A Master's Degree with at least 7 years of relevant experience may be substituted
• DoD Secret
• Experience supporting USTRANSCOM IT systems or logistics platforms
• Experience working with Teradata enterprise data warehouse environments
• Experience with Informatica PowerCenter or other ETL/data integration tools
• Experience with RDBMS platforms such as Oracle, SQL Server, or MySQL
• Experience supporting large-scale enterprise data environments or data pipelines
• Experience supporting federal or large enterprise data environments