Job description

Spalding, a Saalex Company is seeking a Data Engineer/ETL Developer in Lexington Park, MD . Spalding, a Saalex Company is a professional services company delivering cutting-edge solutions to the Department of War. Our expert-level solutions include software development, information technology, program management, financial management and business intelligence services. Position Type: Full-time Salary: $90k-$125k annually (depending upon experience) Work Location: Hybrid remote/in-office (see onsite requirements below). **Onsite Requirements: Position may require on-site work at PAX approximately 1 day per week for meetings, collaboration, and technical tasking. Essential Functions: • 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. Required: • 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 is required. Desired: • 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. May be required to obtain within 90 days upon onboarding. Education: • BS/BA degree and 3 years related experience OR AA/AS degree and 7 years related experience OR HS and 9 years related experience. Security Clearance: • Must be eligible to obtain a Secret clearance. Active Secret clearance desired, interim Secret acceptable to start. Requirements to obtain a clearance include US Citizenship, security investigation, etc. • 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

Requirements

Must-haves

Position Type: Full-time
Salary: $90k-$125k annually (depending upon experience)
Work Location: Hybrid remote/in-office (see onsite requirements below).
Onsite Requirements: Position may require on-site work at PAX approximately 1 day per week for meetings, collaboration, and technical tasking.
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.
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 is required.
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. Active Secret clearance desired, interim Secret acceptable to start. Requirements to obtain a clearance include US Citizenship, security investigation, etc.
Short Term & Long Term Disability

Nice-to-haves

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. May be required to obtain within 90 days upon onboarding.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awssqlpythonapijavascript

Platform: workable
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Paid Time Off

Wellness