Support NASA missions! The Space Telescope Science Institute (STScI) is a multi-mission science and flight operations center for NASA’s flagship observatories on the Johns Hopkins University Homewood campus in Baltimore, Maryland. Learn more about our missions. This position can support hybrid work both onsite and from home. Candidates must reside in or be willing to relocate to our local market (MD, DE, VA, PA, DC & WV).
STScI has an immediate opening for a Software Engineer in the Catalog Science Branch (CSB) in the Data Management Division (DMD). The CSB branch is responsible for multi-terabyte astronomical database development and the archived science catalog data management for all missions, including the James Webb Space Telescope, the Hubble Space Telescope and the Nancy Grace Roman Space Telescope which is scheduled for launch in the mid-2020s. The team builds science data products to service the scientific community as well.
Role & Responsibilities include:
- Analyze, design and implement effective data management solutions for high volume astronomical data, both in cloud and on-premises environments
- Identifying, designing and implementing internal data process improvements, including re-designing database infrastructure for greater scalability, optimizing data delivery, and automating manual astronomical data ingestion processes
- Ability to build processes that support data transformation, workload management, data structures, dependency and metadata management.
- Collaborate with archive scientists for developing scientific data products.
- Provide technical support for data ingestion, data transformation, data store and data retrieval activities.
- Coordinate the migration of data from legacy systems to new solutions.
- Review SQL queries and recommend areas of improvement.
- Monitor the database performance by performing regular tests, troubleshooting and integrating new features.
- Involve in day-to-day data ingestion operations, technical support for any data related activities and production database troubleshooting.
- Strong knowledge of RDBMS database structure
- Hands on experience with the composition of advanced SQL query and query performance tuning
- Experienced with Python programming development
- Cloud experience preferred
- Experience with both normalized and dimensional data models, big data technologies on both structured and unstructured data, and hands-on knowledge of data integration techniques
- Experienced with agile software development and familiar with CI/CD tools and source control system (Git)
- Strong analytical skills, persistence in problem-solving, and ability to learn quickly and independently.
- US Citizenship or Permanent Residence in order to meet ITAR requirements.
Bachelor’s degree in Computer Science, Engineering, Physics, Mathematics or a related technical or scientific field with a minimum of 5-8 years of experience in data management.
STScI will consider additional relevant education or experience for the stated qualifications. The starting position and salary are commensurate with education and experience. We offer an excellent and generous benefits package (Click here to explore our benefits).STScI offers a flexible and welcoming workspace for all (Click here to learn more about our culture).
TO APPLY: Please upload a resume and completing an online application. Applications received by May 30, will receive full consideration. Applications received after this date will be considered until the position is filled.
Direct link: https://recruiting2.ultipro.com/SPA1004AURA/JobBoard/93330e50-7b3a-4ba8-94f2-6f32360aa4e1/Opportunity/OpportunityDetail?opportunityId=7bec260b-a0e4-4c77-a675-fe08d3dee091
Explore all career opportunities through our website at www.stsci.edu/opportunities
COVID Working Protocols: https://outerspace.stsci.edu/display/CWP
STScI embraces the diversity of our staff as a strategic priority in creating a first-rate community. We reflect this deep dedication in strongly encouraging women, ethnic minorities, veterans, and disabled individuals to apply for these opportunities (Click here to learn more about how we foster Diversity & Inclusion). Veterans, disabled individuals, or wounded warriors needing assistance with the employment process can contact us at firstname.lastname@example.orgEOE/AA/M/F/D/V
AURA, as a leader in the astronomical community, is committed to diversity and inclusion. AURA develops and supports programs that advance our organizational commitment to diversity, broaden participation, and encourage the advancement of diversity throughout the astronomical scientific workforce www.aura-astronomy.org/diversity.asp
As a recipient of U.S. Government funding, AURA is considered a government contractor and is subject to Equal Employment Opportunity and Affirmative Action regulations. As an Equal Opportunity and Affirmative Action Employer, AURA and all of the centers, do not discriminate based on race, sex, age, religion, national origin, sexual orientation, gender identity/gender identity expression, lawful political affiliations, veteran status, disability, and/or any other legally protected status under applicable federal, state, and local equal opportunity laws. The statements below as well as the requests for self-identification are required pursuant to these regulations. We encourage your participation in meeting these federal reporting requirements that are included for protection and to assist us in our record-keeping and reporting. Your responses are kept strictly confidential.