Job description

Senior AWS Data Engineer 100% remote 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 in support of STScI’s NASA missions. 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. This includes development of data and engineering databases to support the Roman Space Telescope. 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) Remote Skills: Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Astronomy, Cloud Computing, Cloud Storage, Computer Science, Computer Systems, Data Analysis, Data Management, Data Migration, Data Modeling, Data Processing, Data Quality, Data Storage, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Debugging Skills, GraphQL, Identify Issues, Microsoft SQL Server, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Proof of Concept, Python Programming/Scripting Language, Query Analysis, SQL (Structured Query Language), Sales Pipeline, Software Development, Stored Procedures, Systems Administration/Management, Systems Engineering, Systems Maintainability, Systems Scalability, Team Player, Technical Leadership, Time Management, United States Citizen About the Company: ALTA IT Services ALTA IT Services, LLC combines experience and expertise to deliver IT talent that meets and exceeds the expectations of our clients. Since 2004, we have specialized in delivering IT services and staffing nationwide from our Rockville, MD headquarters and two regional offices located in Columbia, MD and Cincinnati, OH. ALTA provides IT staffing and services to support critical IT initiatives, including Artificial Intelligence, Program & Project Management, Enterprise Platforms, Cybersecurity, Systems Engineering & Administration, Software & Web Services, Data Science & Analytics, DevOps, Quality Assurance, Help Desk, Network Management & Support, and Training. Our team of recruiting professionals can recruit any skill necessary to support both commercial and government client needs throughout the United States. The foundation of our business operations is that we build relationships to last. We do this by placing the highest priority on our core values of integrity, reliability, and quality. We take the responsibilities entrusted to us by our clients and IT professionals very seriously. As a result, we are proud to say that the majority of our clients have been with us for more than a decade. We work hard every day to earn and keep their trust. That is the promise that we make to all of our clients. Company Size: 100 to 499 employees Industry: Staffing/Employment Agencies Founded: 2004 Website: https://www.altaits.com/

Requirements