Data Engineer/ETL Developer

Spalding, a Saalex Company, is hiring a Data Engineer/ETL Developer to build and optimize data pipelines and ETL workflows for the Department of the Navy’s Jupiter enterprise data environment and AWS Gov Cloud. The role also involves data architecture, database migration, API development, performance troubleshooting, and data validation.

Responsibilities

Design, develop, and optimize data pipelines, ETL mappings, and data architectures within the Department of the Navy (DON) Jupiter enterprise data environment and the AWS Gov Cloud ecosystem

Build and maintain scalable extraction, transformation in Informatica; and loading workflows using modern cloud-native data processing in Databricks

Author, refine, and optimize advanced SQL and python scripts to support schema creation, data population, truncation, migration, and complex manipulation of tables, views, and materialized views

Architect and deploy custom Application Programming Interfaces (APIs) to securely connect disparate data sources and streamline data ingestion pipelines

Proactively identify, diagnose, and resolve technical issues, errors, and performance bottlenecks within the cloud data warehouse and associated ETL frameworks

Perform comprehensive data collection, pattern analysis, validation testing, and quality troubleshooting across large, complex datasets

Other duties as assigned

Preferred

Proficiency in Python (for Databricks), JavaScript, and legacy Visual Basic (VB) is highly preferred to support legacy systems and custom automation

Familiarity with TOAD for Oracle is preferred

Direct experience supporting NAVAIR IT applications, programs, or projects within Navy-approved networks is highly desired

Possession of an active CompTIA Security+ certification is preferred to satisfy DoD 8570/8140 compliance requirements for elevated privilege roles

Python

JavaScript

Visual Basic

TOAD for Oracle

NAVAIR IT Application Support

CompTIA Security+ Certification

DoD 8570/8140 Compliance

Benefits

Hybrid remote/in-office; position may require on-site work at PAX approximately 1 day per week for meetings, collaboration, and technical tasking.

Health Care Plan (Medical, Dental & Vision)

Retirement Plan (401k, IRA)

Life Insurance (Basic, Voluntary & AD&D)

Paid Time Off (Vacation, Sick & Public Holidays)

Short Term & Long Term Disability

Training & Development

Wellness Resources

Stock Option Benefit

Company

Advanced technology systems integrator for defense, space, and intelligence

Washington, District of Columbia, US

https://saalex.com/

Founded in 1999

501-1000 employees

Qualifications

Proven experience applying modern data engineering methodologies, pipeline design patterns, and enterprise data architecture practices (with an emphasis on cloud-based frameworks)

Strong technical proficiency in Informatica and Databricks for orchestrating complex, enterprise-level ETL/ELT pipelines

Hands-on experience working with cloud-native storage, compute, and analytics services within AWS, alongside a proven track record of executing database migrations from legacy on-premises environments to AWS

Mastery of SQL is required

Strong proficiency in data analysis techniques and tooling, including MS Excel for rapid data manipulation and validation is required

Strong working knowledge of RESTful API development, JSON data structures, and secure data exchange protocols

BS/BA degree and 3 years related experience OR AA/AS degree and 7 years related experience OR HS and 9 years related experience

Must be eligible to obtain a Secret clearance

US Citizenship

Proficiency in Python (for Databricks), JavaScript, and legacy Visual Basic (VB) is highly preferred to support legacy systems and custom automation

Familiarity with TOAD for Oracle is preferred

Direct experience supporting NAVAIR IT applications, programs, or projects within Navy-approved networks is highly desired

Possession of an active CompTIA Security+ certification is preferred to satisfy DoD 8570/8140 compliance requirements for elevated privilege roles

BS/BA degree and 3 years related experience OR AA/AS degree and 7 years related experience OR HS and 9 years related experience.

Required skills

Data Engineering, Enterprise Data Architecture, Informatica, Databricks, AWS, Database Migration, SQL, Data Analysis, Microsoft Excel, REST API Development, JSON, Python

Preferred skills

Familiarity with TOAD for Oracle is preferred

Experience

3+ years