"Alerted.org

Senior AWS Data Engineer

100% remote

Per Client Guidelines Must be a US citizen or GC Holder in order to meet ITAR requirements

No Visa Holders

The Data Management Division is seeking Senior Data Engineers for our Data Systems Branch to focus on infrastructure, ingestion, and API based access.

This position can support hybrid work. Candidates must reside in or be willing to relocate to our local market. (MD, DE, VA, PA, DC & WV).

Senior Date Engineers Role:

The team leads the development of data management platforms to support the science initiatives of the astronomy community.

You will work in a cloud and on-premise computing environments to design, build, and manage data infrastructure for ingesting, storing, and analyzing large volumes of data. This includes data pipelines, ETL/ELT processes, and ensuring data quality and integrity. You will work with a team of software developers and astronomers to deliver science products using our Data Access API’s.

Key responsibilities:

• Analyze, design and implement effective data management solutions for high volume, high variability and high veracity astronomic data, either in cloud or on-prem environments

• Assess and profile the current data management systems, identify existing functional or performance issues, implement solutions to optimize existing systems or resolve critical issues with new approaches, technologies and data management infrastructures

• Lead or participate in designing and implementing proof of concept or pilot projects in cloud or on- prem environments for new products, new technologies, and improving systems scalability and maintainability

• Analyze data access scenarios and patterns, assess existing SQL queries and recommend areas in need of improvement

• Design and develop database schemas, indexing, data migration utilities, functions or stored procedures

• Support data API development activities

• Involve in day-to-day operations, lead in troubleshooting and debugging, fix database production issues in a timely manner

• Monitor the database performance and troubleshoot operational issues.

Experience, Skills and Qualifications:

• Bachelor’s degree in Computer Science, Engineering or an equivalent relevant field with 8+ years hands-on working experiences in data engineering and data management.

• Demonstrate quantitative and qualitative data engineering experiences, including but not limit to extensive data modeling, data management for large database systems

• Proficient in the composition of advanced SQL (analytical functions) and queries

• Proficient in performance tuning for databases or data management pipelines

• Proficient with Python programming

• Hands-on experience with cloud databases, especially Amazon Web Services (e.q. Amazon RDS)

• Proficiency in cloud data storage and access strategies.

• Experience with Postgres and SQLServer and migration between database systems

• Experience with tools and frameworks such as Kafka and GraphQL

#M2

Ref: #850-Rockville (ALTA IT)

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.