Job Description
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 s