Database Extract, Transform and Load (ETL) Developer

Description

The Digital Modernization Sector has an opening for a Database Extract, Transform and Load (ETL) Developer to work in Woodlawn, MD.

This position is required to be onsite in Woodlawn, MD five days a week.

The Database Extract, Transform and Load (ETL) Developer will be responsible for database developer and Extract, Transform and Load (ETL) development with custom home-grown" scripting skills. Design, development, testing, and maintenance of UNIX shell scripting and Python are needed for success.

Day to Day Job Responsibilities:

• Support various data loading techniques to Greenplum MPP database.
• Design, develop, and test custom in-house written" automated ETL processes, and troubleshoot any data load errors.
• Perform source system data analysis to understand data relationships.
• Investigate and resolve data quality, data loading failures and develop data cleansing routines.
• Generate Data Definition Language (DDL) scripts from Erwin modeling tool.
• Automate the custom data loading process and continue to improve based on requirements.
• Be available for scheduled for after-hours on-call support and will be required to support production release during non-peak hours.
• Provide documented designs and recommendations for improvement of processes and automation of manual tasks, ETL methods and procedures, and ETL best practices.
• Accept other duties as directed by management.

Required Qualifications:

• BS degree and 2+ years of prior relevant experience OR Masters with less than 2 years of prior relevant experience. Additional years of experience may be substituted/accepted in lieu of degree.
• Must be able to obtain a public trust clearance.
• Ability to effectively communicate information, both verbally and written to end users, team members and management.
• Experience working with data warehouse projects.
• Experience designing custom in-house written" ETL processes to populate the data warehouse.
• Ability to analyze source data for potential data quality issues and address these issues.
• Knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools).
• Experience in scripting (Shell scripting, python, Java) and automation.
• Prepare technical documents and presentations.

Desired Qualifications:

• Ansible scripting.
• Familiarity with Atlassian product suite (Git, BitBucket, Confluence, Jira).
• Experience with DevOps.
• Experience with cloud environment, AWS, EC2 and S3.
• Database Administration (DBA) skills.
• Provide query support and troubleshooting for ad hoc query requests.

Original Posting:
May 21, 2025
For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.

Pay Range:
Pay Range $67,600.00 - $122,200.00

The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.