Data Engineer/ETL Developer

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.