AWS Data Engineer

Syms Strategic Group, LLC (SSG)
Overland Park, United States of America
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Overland Park, United States of America

Tech stack

Query Performance
.NET
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Systems Engineering
C Sharp (Programming Language)
Cloud Engineering
Continuous Delivery
Continuous Integration
Data Infrastructure
Amazon DynamoDB
Electronic Data Interchange (EDI)
Meta-Data Management
Microsoft SQL Server
Standard Sql
SQL Databases
Data Streaming
XML
Data Storage Technologies
Delivery Pipeline
Backend
Data Layers
Build Management
Amazon Web Services (AWS)
Data Management
Object Store

Job description

Syms Strategic Group (SSG) is seeking a talented Senior Systems Engineer (Amazon Web Services (AWS) Data Engineer), + 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 backend C#/.Net engineers to ensure data flows cleanly from Electronic Data Interchange (EDI) processing pipelines into the new data layer

  • Implement and maintain Continuous Integration/Continuous Delivery (CI/CD) pipelines for data infrastructure using AWS-native tooling (CodePipeline, CodeBuild, and CodeDeploy)

Requirements

Location: Remote Department: Veterans Affairs (VA) Type: Full Time Min. Experience: Experienced Security Clearance Level: Public Trust (MBI) If you have previously applied to Syms Strategic Group (SSG), there is no need to reapply. Applications are still under review. Military Veterans are highly encouraged to apply! Essential Duties and Responsibilities

Apply for this position