3 months ago
Remote, United States or El Paso, TX, USASenior
Responsibilities
- Evaluate and recommend an AWS-native storage and query architecture using services such as S3, Athena, Aurora, DynamoDB, Redshift, and OpenSearch.
- Design and build SQL-based reporting and query layers for business stakeholders and non-technical users.
- Architect the migration of XML object store data from MSSQL into AWS, including storage formats, partitioning, and data organization.
- Build and maintain AWS data catalogs, schemas, and metadata management capabilities.
- Optimize query performance and cloud costs through partitioning, compression, file formats, and query tuning.
- Gather reporting requirements from stakeholders and analysts and translate them into data models and query patterns.
- Collaborate with backend C#/.NET engineers to integrate EDI processing pipelines with the new data layer.
- Implement and maintain CI/CD pipelines using AWS CodePipeline, CodeBuild, and CodeDeploy.
- Apply infrastructure as code using AWS CDK, CloudFormation, or Terraform.
- Document architecture decisions, data flows, data dictionaries, and migration runbooks.
Requirements
- Bachelor's or master's degree in computer science, engineering, or a related technical discipline, or equivalent practical experience.
- At least 8 years of software or data engineering experience with a strong AWS focus.
- Production experience architecting and executing cloud data platform migrations in enterprise or healthcare environments.
- Experience evaluating AWS data services and delivering reporting or analytics solutions for non-technical business users.
- Deep hands-on experience with AWS data-oriented services including S3, Athena, Glue, Aurora, DynamoDB, Redshift, OpenSearch, Lambda, IAM, and CloudWatch.
- Strong SQL skills and experience designing relational query layers over semi-structured or non-relational XML and JSON data.
- Experience parsing, querying, and transforming XML-heavy data at scale.
- Experience with AWS analytics and reporting services such as Athena, QuickSight, and Redshift or equivalent BI tools.
- Proficiency with Git and GitHub and familiarity with AWS-native CI/CD tooling and infrastructure as code.
- Experience gathering business reporting requirements, making architecture decisions, and communicating technical trade-offs to non-technical stakeholders.
- Experience with Scrum or Kanban and JIRA.
- Preferred experience with healthcare data formats including X12 EDI, HL7, and FHIR.
- Preferred familiarity with C#/.NET backend services, Entity Framework migration or deprecation projects, HIPAA requirements, healthcare payer/PBM systems, clearinghouses, or pharmacy operations.
- AWS certification is a bonus.
- US citizenship and the ability to obtain and maintain a Public Trust clearance are required.
Benefits
- 100% remote work arrangement.
- The role supports healthcare data platform modernization at SAIC.
- AWS certification is a bonus.
Categories
Data Engineering
About SAIC
SAIC (Science Applications International Corporation) is a government technology integrator delivering systems engineering, enterprise IT, secure cloud, cybersecurity, C5ISR, and data analytics for U.S. defense, space, intelligence, and civilian agencies. It builds and sustains mission IT and digital engineering solutions under multi-year federal contracts and task orders. Founded in 1969, SAIC is headquartered in Reston, Virginia, and is a public company traded on the NYSE under the ticker SAIC.