Senior Systems Engineer (AWS Data Engineer)

About this role

Syms Strategic Group (SSG) is seeking a talented Senior Systems Engineer (Amazon Web Services (AWS) Data Engineer)
Location: Remote
Department: Veterans Affairs (VA)
Type: Full Time
Min. Experience: Experienced
Security Clearance Level: Public Trust (MBI)

Military Veterans are highly encouraged to apply!

Essential Duties and Responsibilities

• Lead the next phase of the healthcare data platform modernization
• Continue the evolution from a Microsoft Structured Query Language Server (MSSQL) eXtensible Markup Language (XML) object store toward a scalable, cloud-native AWS data architecture
• Enable business stakeholders and analysts to run performant, SQL-based reports and queries against the healthcare data seamlessly
• Evaluate and decide the right AWS data strategy for the team’s platform
• Evaluate and commend the optimal AWS-native data storage and query architecture for the XML object store data, assessing options such as Simple Storage Service (S3) + Athena, Aurora, DynamoDB, Redshift, and OpenSearch based on query patterns, reporting needs, cost, and scalability
• Design and build the reporting and query layer that allows business stakeholders and non-technical users to run relational SQL queries against healthcare data using familiar tooling
• Architect the migration path for XML object store data from MSSQL into the target AWS platform, defining storage formats, partitioning strategies, and data organization for optimal query performance
• Build and maintain AWS data catalog(s), schemas, and metadata management so that object store data is discoverable and queryable by business users
• Optimize query performance and cost across chosen AWS services – partitioning, compression, file formats, and query pattern tuning
• Work directly with business stakeholders and analysts to understand reporting requirements and translate them into durable, performant data models and query patterns
• Collaborate with ba...