Remote AWS Data Engineer II — Data Platform Modernization

Socket.dev

Ashburn (VA)

On-site

USD 85,000 - 117,000

Full time

4 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Benefits offered by this job

null

Job summary

Syms Strategic Group (SSG) is seeking a Senior Systems Engineer (AWS Data Engineer) to lead the next phase of healthcare data platform modernization in a remote US-based role. You will design AWS data architectures, migrate XML data from MSSQL, optimize queries, and collaborate with stakeholders to deliver SQL-based reporting for business users.

Requires 8+ years of AWS data experience, US citizenship, and Public Trust (MBI) clearance; a Bachelor's in CS/Engineering is required.

Qualifications

8+ years of software or data engineering with a strong AWS focus.
Experience architecting cloud data 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 Business Intelligence (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.
Migrate MSSQL XML object store toward a scalable, cloud-native AWS data architecture for SQL-based reports.
Evaluate the right AWS data strategy for the platform.
Design and build reporting and query layers for business users to run SQL queries.
Architect the migration path from XML object store to AWS platform with optimized storage and partitioning.
Build and maintain AWS data catalog, schemas, and metadata management.
Optimize query performance and cost across AWS services.
Collaborate with stakeholders to translate reporting requirements into durable data models and query patterns.
Coordinate with backend C#/.Net engineers to ensure data flows from EDI to the new data layer.
Implement CI/CD pipelines for data infrastructure using AWS-native tooling.
Apply IaC practices using CDK, CloudFormation, or Terraform.
Document architecture decisions, data flows, and data dictionaries clearly.