Note: The job is a remote job and is open to candidates in USA. SAIC is a technology integrator providing technical, engineering, intelligence, and enterprise information technology solutions. The Senior AWS Data Engineer will lead the modernization of a healthcare data platform by selecting and implementing a scalable AWS-native data architecture, building reporting and query capabilities, and managing data migration, infrastructure, and documentation.
Responsibilities
- Evaluate and recommend the optimal AWS-native data storage and query architecture for our XML object store data - assessing options such as 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, 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 EDI processing pipelines into the new data layer
- Implement and maintain CI/CD pipelines for data infrastructure using AWS-native tooling (CodePipeline, CodeBuild, CodeDeploy)
- Apply infrastructure as code (IaC) practices using AWS CDK, CloudFormation, or Terraform
- Document architecture decisions, data flows, and data dictionaries clearly for both technical and non-technical audiences
Skills
- * Bachelor's or master's degree in computer science, Engineering, or a related technical discipline required; equivalent practical experience considered
- * Minimum 8 years of experience 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, CloudWatch
- * Strong SQL skills - 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
- * 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 - Athena, QuickSight, Redshift, or equivalent BI tooling
- * Proficient with Git and GitHub - branching strategies, pull requests, collaborative workflows
- * Familiarity with CI/CD practices and AWS-native tooling (CodePipeline, CodeBuild, CodeDeploy)
- * Infrastructure as code 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
- * Comfortable driving ambiguous architecture decisions to resolution with limited direction
- * Experience with agile methodologies (Scrum, Kanban) and JIRA
- * Strong documentation habits - architecture diagrams, data dictionaries, migration runbooks
- * Experience with healthcare data formats - X12 EDI (837, 835, 277CA), HL7, FHIR
- * Familiarity with C#/.NET backend services for integration touchpoints
- * Experience with Entity Framework migration or deprecation projects
- * Knowledge of HIPAA compliance requirements in cloud data architecture
- * Experience with healthcare payer/PBM systems, clearinghouses, or pharmacy operations
- * Clearance Requirement:** ship required with the ability to obtain and maintain a Public Trust clearance
- * AWS certification is a bonus
Company Overview
Company H1B Sponsorship