Data Platform Engineer

Syms Strategic Group (SSG) is seeking a talented Data Platform EngineerLocation: RemoteDepartment: Veterans Affairs (VA)Type: Full TimeMin. Experience: ExperiencedSecurity Clearance Level: Public Trust (MBI)Salary Range: $85,389 - $116,975If you have previously applied to Syms Strategic Group (SSG), there is no need to reapply. Applications are still under review.Military Veterans are highly encouraged to apply!Essential Duties and ResponsibilitiesLead the next phase of the healthcare data platform modernizationImplement the evolution from a Microsoft SQL eXtensible Markup Language (MSSQL XML) object store toward a scalable, cloud-native AWS data architecture that enables business stakeholders and analysts to run performant, SQL-based reports and queries against healthcare data seamlesslyEvaluate and decide the right AWS data strategy for the platformEvaluate and recommend the optimal AWS-native data storage and query architecture for the XML object store data, assessing options such as S3 + Athena, Aurora, DynamoDB, Redshift, and OpenSearch based on query patterns, reporting needs, cost, and scalabilityDesign 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 toolingArchitect 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 performanceBuild and maintain AWS data catalog, schemas, and metadata management so that object store data is discoverable and queryable by business usersOptimize query performance and cost across chose AWS services – partitioning, compression, file formats, and query pattern tuningWork directly with business stakeholders and analysts to understand reporting requirements and translate them into durable, performant data models and query patternsCollaborate with back-end C#/.Net engineer to ensure data flows cleanly from Electronic Data Interchange (EDI) processing pipelines into the new data layerImplement and maintain CI/CD pipelines for data infrastructure using AWS-native tooling (CodePipeline, CodeBuild, and CodeDeploy)Apply Infrastructure as Code (IaC) practices using AWS Cloud Development Kit (CDK), CloudFormation, or TerraformDocument architecture decisions, data flows, and data dictionaries clearly for both technical and non-technical audiencesRequired Skills and Experience8+ years' experience in software or data engineering with a strong AWS focusProven experience architecting and executing cloud data platform migrations in production enterprise or healthcare environmentsTrack record of evaluating and selecting AWS data services to meet business reporting and query requirementsExperience delivering reporting or analytics solutions that serve non-technical business usersDeep hands-on AWS experience across data-oriented services – S3, Athena, Glue, Aurora, DynamoDB, Redshift, OpenSearch, Lambda, IAM, and CloudwatchStrong 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 scaleAn ability to evaluate trade-offs across AWS data services and make architecture recommendations based on cost, performance, and business requirementsFamiliarity with AWS analytics and reporting services, including Athena, QuickSight, RedShift, or equivalent Business Intelligence (BI) toolingProficiency with Git and GitHub - branching strategies, pull requests, and collaborative workflowsFamiliarity 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 stakeholdersExperience gathering and translating business reporting requirements into technical data modelsComfort driving ambiguous architecture decisions to resolutions with limited directionExperience with Agile methodologies (Scrum, Kanban) and JIRAStrong documentation habits – architecture diagrams, data dictionaries, migration runbooksProfessional CertificationsNone but AWS certifications are a bonusYears of Professional Experiencen/aDesired experienceElectronic Data Interchange X.12 (EDI) Medical ClaimsX.12, Medical Claims (837, 835, 277CA, etc), Health Level (HL7), Fast Healthcare Interoperability Resources (FHIR)Familiarity with C#/.Net back-end services for integration touchpointsExperience with Entity Framework migration or deprecation projectsExperience with healthcare payer/Pharmacy Benefit Management (PBM) systems, clearinghouses, or pharmacy operationsKnowledge of HIPAA compliance requirements in cloud data architectureFormal EducationBachelor's degree or higher in Computer Science, Engineering, or a related technical discipline; equivalent practical experience consideredCitizenship RequirementU.S. Citizenship required for this specific opportunitySecurity Clearance RequirementsMust possess or qualify for a Public Trust (MBI)CRITICAL NOTESSSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered.Recruiters or Third parties will not be considered.This is a 100% U.S. based remote position. However, candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be considered.This is a W-2 positionAll interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptionsAs part of our screening process, you will be requested to provide a link to your LinkedIn profileU.S Citizenship is required for this specific opportunity. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness.Syms Strategic Group, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.J-18808-Ljbffr