The Digital Modernization Sector has an opening for a Senior Greenplum Database Engineer to work in Woodlawn, MD.
This position will require onsite work in Woodlawn, MD five days a week.
Day to Day 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
Education & Qualifications
- 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
Required Skills:
These skills will help you succeed in this position:
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)
Desired Skills:
Showcase your knowledge of modern development through the following experience or skills:
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
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 $104,650.00 - $189,175.00The 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.
Similar Jobs
What We Do
We Are Leidos
For 50 years we have been tackling some of the biggest problems that face our nation and our world.
OUR MISSION
Through our culture of innovation and history of performance, we develop deep customer trust built on integrity and create enduring solutions that improve our world. Leidos is a science and technology solutions leader working to address some of the world’s toughest challenges in the defense, intelligence, homeland security, civil, and healthcare markets. The company’s 43,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Va., Leidos reported annual revenues of approximately $11.09 billion for the fiscal year ended January 3, 2020.
Leidos was cited for the meaningful work employees perform that is challenging, impactful, and aligned with our customers’ missions as reasons professionals want to work and stay at our company. Leidos has also been named to lists including Forbes’ Best Employers for Diversity, Forbes’ America’s Best Employers for Women, Military Times Best for Vets Employers, and Ethisphere Institute’s World's Most Ethical Companies®.
Employees enjoy career enrichment opportunities available through mobility and development and experience rewarding relationships with supportive supervisors and talented colleagues and customers. Employees appreciate our flexible work environment, allowing for and encouraging a true work-life balance. Our professionals are also excited about our Employee Resource Groups, like the newly launched Collaborative Outreach with Remote and Embedded Employees (CORE), which strives to create an environment where every employee, regardless of location, feels fully engaged as a valued employee of Leidos.
Your most important work is ahead.
