Skip to content
Senior Greenplum Database Engineer
| Company | Leidos |
|---|
| Location | Woodlawn, MD, USA |
|---|
| Salary | $104650 – $189175 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s |
|---|
| Experience Level | Senior, Expert or higher |
|---|
Requirements
- Bachelor’s degree and 8+ years of experience in a training-related field. Additional years of experience may be substituted in lieu of degree.
- Must be able to obtain a Public Trust
- Ability to effectively communicate information, both verbally and written to end users, team members and management
- Expert level knowledge of Greenplum architecture
- Expert in Greenplum database administration
- Experience working with complex data warehouse projects
- Experience designing custom ETL processes to populate the data warehouse
- Expert in shell scripting and automating tasks
- Ability to analyze source data for potential data quality issues and address these issues
- Experience in scripting (Shell scripting, python, Java) and automation
- Familiarity with Atlassian product suites (Git, BitBucket, Confluence, Jira)
Responsibilities
- Excellent written and verbal communication skills.
- Expert in the various data loading techniques to Greenplum MPP database and develop process to automate it, and troubleshoot any data load errors.
- Database development experience with strong skills in SQL and PL/pgSQL.
- Perform source system data analysis to understand data relationships.
- Investigate and resolve data quality, data loading failures and develop data cleansing routines.
- Design and document logical and physical data models in data modeling tool.
- Generate Data Definition Language (DDL) scripts from modeling tool.
- Design and document source to target data mappings.
- Design, develop and test custom ETL or data stage routines.
- Automate the custom data loading process and continue to improve based on requirements.
- Provide ad hoc query support.
- Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
- May be scheduled for after-hours on-call support and will be required to support production releases during non-peak hours.
- Design, development, testing, and maintenance of UNIX shell scripting and Python.
- All other duties as assigned or directed.
Preferred Qualifications
- Ansible scripting
- Experience with cloud environment, AWS
- High-level knowledge of various industry leading data warehouse components (databases, ETL tools, BI/reporting tools)
- Ability to prepare effective technical documents and presentations
- Experience with DevOps
