Software Engineer II - Data Science

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

Qualifications:

Strong knowledge of RDBMS database structure

Hands on experience with the composition of advanced SQL query and query performance tuning

Experience transforming data in various formats, including JSON, XML, YAML, CSV and other format

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 Python programming development

Experienced with agile software development and familiar with CI/CD tools and source control system (Git)

Great verbal and written communication skills to interact, communicate, present and influence with both technical and non-technical team members

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

Education/ Experience:

Bachelor’s degree in Computer Science, Engineering, Physics, Mathematics or a related technical or scientific field with a minimum of 3 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 4, 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=e8de2cd1-41bf-4b0d-8d55-1ddcb8ca05bd<top>

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 [email protected]/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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)