Senior AWS Data Engineer - Healthcare Data Platform

Socket.dev; Orlando (FL); On-site; USD 85,000 - 117,000; Full time

Job summary

Syms Strategic Group (SSG) seeks a Senior Systems Engineer (AWS Data Engineer) to lead healthcare data platform modernization in a 100% remote U.S. role.

You will drive migration from MSSQL XML stores to AWS data services, enabling SQL-based reporting for business stakeholders. The role requires 8+ years in AWS-focused data engineering, experience designing cloud data architectures, and strong SQL skills for relational layers over XML/JSON.

Qualifications

• 8+ years in software or data engineering with a strong AWS focus.
• Proven experience architecting and executing cloud data platform migrations in production enterprise or healthcare environments.
• Track record of evaluating and selecting AWS data services to meet business reporting and query requirements.
• Experience delivering reporting or analytics solutions that serve non-technical business users.
• Deep hands-on AWS experience across data-oriented services – S3, Athena, Glue, Aurora, DynamoDB, Redshift, OpenSearch, Lambda, IAM, and Cloudwatch.
• Strong SQL skills with the ability to design relational query layers over semi-structured or non-relational data (XML, JSON).
• Experience working with XML-heavy data stores – parsing, querying, and transforming XML at scale.
• An ability to evaluate trade-offs across AWS data services and make architecture recommendations based on cost, performance, and business requirements.
• Familiarity with AWS analytics and reporting services, including Athena, QuickSight, RedShift, or equivalent BI tooling.
• Proficiency with Git and GitHub - branching strategies, pull requests, and collaborative workflows.
• Familiarity with CI/CD practices and AWS-native tooling (CodePipeline, CodeBuild, and CodeDeploy).
• IaC experience (AWS CDK, CloudFormation, or Terraform).
• Strong ability to communicate technical architecture decisions and trade-offs to non-technical stakeholders.
• Experience gathering and translating business reporting requirements into technical data models.
• Comfort driving ambiguous architecture decisions to resolutions with limited direction.
• Experience with Agile methodologies (Scrum, Kanban) and JIRA.
• Strong documentation habits – architecture diagrams, data dictionaries, migration runbooks.

Responsibilities

• Lead the next phase of the healthcare data platform modernization.
• Implement the evolution from an MSSQL XML object store toward a scalable, cloud-native AWS data architecture for SQL-based reports.
• Evaluate and decide the right AWS data strategy for the platform.
• Recommend the optimal AWS-native data storage and query architecture for XML object store data.
• Design and build the reporting and query layer for relational SQL queries against healthcare data.
• Architect the migration path for XML object store data from MSSQL into AWS, including storage formats and partitioning.
• Build and maintain AWS data catalog, schemas, and metadata management.
• Optimize query performance and cost across AWS services via partitioning, compression, and file formats.
• Collaborate with stakeholders to translate reporting requirements into durable data models.
• Work with back-end C#/.Net engineers to ensure data flows through EDI pipelines into the new data layer.
• Implement and maintain CI/CD pipelines for data infrastructure using AWS tools.
• Apply IaC practices using AWS CDK, CloudFormation, or Terraform.
• Document architecture decisions, data flows, and data dictionaries clearly.

Skills

AWS data engineering

SQL querying

XML data

Data architecture

CI/CD

IaC

Healthcare data

OpenSearch

Security clearance

CloudWatch

Education

Bachelor’s degree

Tools

S3

Athena

Glue

Aurora

DynamoDB

Redshift

OpenSearch

Lambda

IAM

CloudWatch

Job description

Syms Strategic Group (SSG) seeks a Senior Systems Engineer (AWS Data Engineer) to lead healthcare data platform modernization in a 100% remote U.S. role.

You will drive migration from MSSQL XML stores to AWS data services, enabling SQL-based reporting for business stakeholders. The role requires 8+ years in AWS-focused data engineering, experience designing cloud data architectures, and strong SQL skills for relational layers over XML/JSON.