Design, implement, and maintain scalable ETL pipelines across AWS Glue, DMS, Redshift, and supporting services.
Automate ingestion of external data sources, including Assistance Listings and aggregate award datasets.
Improve system operational efficiency and support data quality processes related to reporting and USASpending submissions.
Provide daily operational support for AWS infrastructure: Glue jobs, Redshift tuning, DMS tasks, Lambda, S3, IAM, and troubleshooting.
Offer assistance with Oracle database performance tuning, indexing strategies, and PL/SQL‑based business rules.
Assist maintain and troubleshoot validation and processing logic embedded in Oracle stored procedures and .NET applications.
Deliver O&M support and provide capacity for system reliability and enhancements.
Contribute to CI/CD automation and infrastructure-as-code development using Bitbucket, Jenkins, and Terraform.

Requirements

Must be a U.S. Citizen.
Bachelor’s degree in Computer science, Information Systems, Engineering, or a related field.
7+ years of experience in data engineering or cloud data platform roles.
5+ years of hands-on AWS experience, including Glue, Redshift, S3, DMS, IAM, and Terraform.
Strong proficiency in Python and/or Java for ETL development and automation.
Proven experience designing and maintaining scalable ETL/data integration pipelines.
Hands-on experience with CI/CD processes and tools such as Bitbucket and Jenkins.
Working knowledge of Redshift, PostgreSQL and Oracle environments.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLAWS GlueRedshiftDMSPythonJavaPL/SQLCI/CDTerraformOracle