Data Engineer/ETL Developer

Saalex Corp.; Lexington Park (MD); Hybrid; USD 90,000 - 125,000; Full time

Benefits offered by this job

Health Care Plan

401k/IRA

Life Insurance

Paid Time Off

Disability

Training & Development

Wellness Resources

Stock Options

Job summary

Spalding, a Saalex Company, in Lexington Park, MD, seeks a Data Engineer/ETL Developer to design, build, and optimize data pipelines within the DON Jupiter environment and AWS Gov Cloud.

Hybrid remote/in-office role with on-site required about 1 day per week for meetings and tasks. The role requires Informatica, Databricks, AWS, SQL, Python, and API work to support enterprise ETL/ELT pipelines.

Qualifications

• Proven experience applying modern data engineering methodologies.
• Strong proficiency in Informatica and Databricks for ETL/ELT pipelines.
• Hands-on experience with AWS data services and cloud migrations.
• Mastery of SQL is required.
• Excellent data analysis skills with Excel.
• Experience building and consuming RESTful APIs.

Responsibilities

• Design, develop, and optimize data pipelines and ETL mappings.
• Build scalable extraction, transformation, and loading workflows in cloud environments.
• Write advanced SQL and Python scripts for data manipulation.
• Deploy APIs to connect data sources securely.
• Identify and resolve performance bottlenecks in data warehouses.

Skills

Data engineering

SQL

Python

RESTful API development

Data analysis

MS Excel

Education

BS/BA degree and 3 years related experience

AA/AS degree and 7 years related experience

HS and 9 years related experience

Tools

Informatica

Databricks

AWS

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.

Benefits

• 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