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

Solerity; Fully; Remote; CHF 95,000 - 103,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

Health Savings Accounts and Flexible

Flexible work schedule: onsite, hybrid

401(k) and company-funded life保险

Generous PTO

Tuition and training assistance

Employee discounts

Pet insurance

Referral rewards

Job summary

Solerity, Inc. is seeking a Senior Data Engineer / ETL Developer to design and maintain enterprise ETL pipelines and data integration workflows for the USTRANSCOM Integrated Data Environment & Global Transportation Network Convergence (IGC) program.

This role supports logistics across the DoD with scalable data services and collaboration with developers and architects. You will work with Teradata, Oracle, Informatica PowerCenter, SQL and Python to deliver reliable data solutions, contribute to

Qualifications

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

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.

Skills

Teradata

Informatica PowerCenter

Oracle Database

SQL

Python

Bash / Linux scripting

ETL / Data Integration

Education

Bachelor's degree in IT / CS / IS / Data Science / Cybersecurity or related field

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

• 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

• Medical, dental and vision coverage
• Health Savings Accounts and Flexible Spending Accounts for healthcare and dependent care
• Flexible work schedule to include onsite, hybrid or remote, as dictated by position
• 401(k) and company-funded life insurance
• Generous Paid Time Off (PTO)
• Tuition and training assistance
• Financial rewards for employee referrals.
• Pet insurance
• 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