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

Solerity; United States; Remote; USD 115,000 - 125,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

HSAs and FSAs for healthcare and Dep.‑

Flexible work schedule (onsite, hybrid

401(k) and company-funded life

PTO and training assistance

Employee referral rewards

Pet insurance

Employee discount program

Job summary

Solerity, Inc. is seeking a Senior Data Engineer / ETL Developer to support the USTRANSCOM IGC program. You will design and maintain ETL pipelines, data workflows, and database solutions for enterprise-scale logistics data.

You will collaborate with developers and architects to deliver reliable, scalable data services across the IGC platform, using Teradata, Oracle, Informatica PowerCenter, SQL, Python, and Linux scripting. A DoD Secret-level background is expected with US-based operations.

Qualifications

• Designs, develops, and maintains enterprise ETL processes and data integration pipelines.
• Develops and optimizes complex SQL queries, stored procedures, and database objects.
• Works with Teradata and Oracle databases to support large-scale data operations.
• Creates and maintains ETL workflows using PowerCenter or similar tools.
• Develops automation scripts in Python and Bash for ingestion and transformation.
• Supports database integration, query optimization, and troubleshooting.
• Participates in data modeling, schema design, and performance tuning.
• Supports code migration, validation, and testing across environments.
• Collaborates with engineers to ensure reliable enterprise data architecture.

Responsibilities

• Designs, develops, and maintains enterprise ETL pipelines and data integration workflows.
• Collaborates with developers and architects to deliver scalable data services.
• Optimizes SQL queries, procedures, and database objects for analytics.
• Develops and maintains automation scripts for data ingestion and processing.
• Supports data modeling, schema design, and performance tuning.

Skills

ETL development

Data integration

Data modeling

SQL optimization

Education

Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Science, Cybersecurity, or related field

Bachelor's degree plus one of certifications (Security+, FITSP-D, GCSA, GISF, SSCP)

Tools

Teradata

Informatica PowerCenter

Oracle Database

SQL

Python

Bash / Linux scripting

ETL / Data Integration

Job description

Job Type

Full-time

Description

Join Solerity, a trusted provider of Information Technology, Engineering Services, Program Management, and Consulting Services supporting the U.S. Federal Government and Intelligence Community.

We are seeking a Senior Data Engineer / ETL Developer to support the USTRANSCOM Integrated Data Environment & Global Transportation Network Convergence (IGC) Program. IGC provides enterprise data services and asset visibility supporting global logistics, transportation, and supply chain operations across the Department of Defense.

The selected candidate will design and maintain ETL pipelines, data integration workflows, and database solutions supporting mission-critical logistics systems. This role collaborates with developers and architects to deliver reliable and scalable data services across the IGC platform.

Core Technologies

• Teradata


• Informatica PowerCenter


• Oracle Database


• SQL


• Python


• Bash / Linux scripting


• ETL / Data Integration

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.

Minimum Education:

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)

Minimum Experience:

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.

Minimum Clearance:

DoD Secret

Desired Qualifications:

• 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

Place of Performance:

Remote

Benefits You’ll Enjoy:

• 1. Medical, dental and vision coverage


• 2. Health Savings Accounts and Flexible Spending Accounts for healthcare and dependent care


• 3. Flexible work schedule to include onsite, hybrid or remote, as dictated by position


• 4. 401(k) and company-funded life insurance


• 5. Generous Paid Time Off (PTO)


• 6. Tuition and training assistance


• 7. Financial rewards for employee referrals.


• 8. Pet insurance


• 9. Employee discount program

Employment Opportunities:

Solerity is committed to the range of perspectives we bring to the marketplace by being an employer dedicated to hiring a highly qualified team of professionals, providing world class services and products aimed at exceeding our customer's expectations. Solerity is an equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities. Solerity is a VEVRAA Federal Contractor.

Salary Description

$115,000-$125,000