Systems Engineer (AWS Data Engineer)

• 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

• 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)

Process & Soft Skills

• 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

Nice to Have

• 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
• AWS certification is a bonus. Equal Opportunity Employer: We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.