AWS Data Engineer - II

We need to output HTML fragment with sections using

for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We must not repeat job title. Must not include Job ID etc. Remove boilerplate, navigation, legal, EEO, etc. Must preserve all substantive info. We need to parse the posting. Key info: - Company: Syms Strategic Group (SSG) - Position: Senior Systems Engineer (Amazon Web Services (AWS) Data Engineer) - II - Location: Remote - Department: Veterans Affairs (VA) - Type: Full Time - Min. Experience: Experienced - Security Clearance Level: Public Trust (MBI) - Salary Range: $85,389 - $116,975 - If previously applied, no need to reapply. - Applications still under review. - Military Veterans highly encouraged. - Essential Duties And Responsibilities: list of bullet points (multiple sentences). We need to capture them as

• . - Required Skills and Experience: list of bullet points. - Professional Certifications: None but AWS certifications are a bonus. - Years of Professional Experience: n/a (maybe not needed) - Desired experience: list (EDI X.12, etc.) - Formal Education: Bachelor’s degree or higher in Computer Science, Engineering, or related technical discipline; equivalent practical experience considered. - Citizenship Requirement: U.S. Citizenship required. - Security Clearance Requirements: Must possess or qualify for a Public Trust (MBI) - CRITICAL NOTES: many notes about screening, etc. Some may be considered boilerplate? The instruction: remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The CRITICAL NOTES includes things like "SSG will not make assumptions regarding your qualifications..." etc. Those are application instructions / screening notes. Likely should be removed as they are instructions. Also "Recruiters or Third parties will not be considered", "This is a 100% U.S. based remote position...", "candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be considered", "This is a W-2 position", "All interviews will be conducted on Microsoft Teams...", "As part of our screening process, you will be requested to provide a link to your LinkedIn profile", "U.S Citizenship is required for this specific opportunity...". Some of these are substantive: citizenship requirement, security clearance, location restrictions, W-2, interview process. The instruction says remove application instructions. But some of these are requirements (citizenship, security clearance, location restrictions). However they might be considered part of "Requirements" or "Qualifications". We need to decide. We have sections: About the role (maybe a brief summary), Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We have salary range => Pay section. We have location remote, type full time, department VA => maybe About the role. We have benefits? Not mentioned explicitly. No benefits listed. So we should not create Benefits section unless posting actually states them. So skip Benefits. Schedule? Not mentioned besides full time. Could be considered Schedule but not explicit. Probably skip Schedule unless explicit. We have Required Skills and Experience (list). That could go under Skills or Requirements. The instruction: Use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we need to map content. We have "Essential Duties And Responsibilities" => Responsibilities. We have "Required Skills and Experience" => Skills (or Requirements). There's also "Professional Certifications" maybe under Qualifications. We have "Desired experience" maybe under Qualifications or Requirements. We have "Formal Education" => Qualifications. We have "Citizenship Requirement" and "Security Clearance Requirements" => maybe under Requirements. We have "Min. Experience: Experienced" maybe under Requirements. We have "Security Clearance Level: Public Trust (MBI)" => Requirements. We have "Salary Range" => Pay. We have "Location: Remote", "Department: Veterans Affairs (VA)", "Type: Full Time" => About the role. We have "Military Veterans are highly encouraged to apply!" maybe About the role or a note; but it's not boilerplate? It's encouraging veterans. Could be part of About the role. We have "If you have previously applied to Syms Strategic Group (SSG), there is no need to reapply. Applications are still under review." That's application instruction; remove. We have "Military Veterans are highly encouraged to apply!" keep. We have "Professional CertificationsNone but AWS certifications are a bonus" => maybe under Qualifications or Skills. We have "Years of Professional Experiencen/a" ignore. We have "Desired experienceElectronic Data Interchange X.12 (EDI) Medical Claims X.12, Medical Claims (837, 835, 277CA, etc), Health Level (HL7), Fast Healthcare Interoperability Resources (FHIR) Familiarity with C#/.Net back-end services for integration touchpoints Experience with Entity Framework migration or deprecation projects Experience with healthcare payer/Pharmacy Benefit Management (PBM) systems, clearinghouses, or pharmacy operations Knowledge of HIPAA compliance requirements in cloud data architecture" => could be under Qualifications or Requirements. We have "Formal EducationBachelor’s degree or higher in Computer Science, Engineering, or a related technical discipline; equivalent practical experience considered" => Qualifications. We have "Citizenship RequirementU.S. Citizenship required for this specific opportunity" => Requirements. We have "Security Clearance RequirementsMust possess or qualify for a Public Trust (MBI)" => Requirements. We have "CRITICAL NOTES:" many notes; we should remove as they are mostly application instructions. However some like "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" is a location restriction; could be part of About the role or Requirements. But it's under CRITICAL NOTES; still it's a requirement. The instruction says remove application instructions. This is somewhat ambiguous. I'd keep location restriction as part of About the role or Requirements because it's substantive. But to be safe, maybe include it under About the role (location details). However the instruction says remove duplicated lines and application instructions. The CRITICAL NOTES includes many instructions like "SSG will not make assumptions regarding your qualifications..." etc. Those are definitely application instructions. The location restriction might be considered a requirement, but it's also an instruction (candidates from those states will not be considered). I'd treat it as a requirement (location eligibility). So we can include under Requirements: "Must be located in the U.S. and not reside in CA, CO, IL, MN, NJ, NY, OR, or WA." Also "This is a W-2 position" could be under About the role (employment type). Already have Type: Full Time; W-2 is extra detail. "All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptions" is application instruction; remove. "As part of our screening process, you will be requested to provide a link to your LinkedIn profile" remove. "U.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." This is basically repeating citizenship and security clearance; we already have those. Could be kept under Requirements but it's somewhat boilerplate. Might be considered legal/EEO? It's about security clearance; it's substantive. But it's somewhat repetitive. I'd keep the core: U.S. Citizenship required, must qualify for Public Trust (MBI) security clearance, subject to background investigation. However the instruction says remove EEO/equal-opportunity/scam-warning boilerplate. This is not EEO but security. Might be okay to keep but we already have citizenship and clearance. To avoid duplication, we can keep just the citizenship and clearance. "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." That's EEO boilerplate; remove. "Powered by JazzHR aor6G51C8E" remove. Now we need to output HTML fragment with sections. Let's decide sections: - About the role: include location remote, department VA, type full time, W-2, military veterans encouraged, maybe location restriction (not CA etc). Could also include that it's 100% US based remote. - Responsibilities: list of duties from Essential Duties And Responsibilities. - Requirements: include min experience experienced, security clearance Public Trust (MBI), U.S. citizenship, location restriction (not those states), maybe also W-2? But W-2 is employment type. - Qualifications: formal education (Bachelor's degree or higher in CS/Engineering or related; equivalent experience considered), professional certifications (AWS certifications a bonus), desired experience (EDI X.12, HL7, FHIR, C#/.Net, Entity Framework, healthcare payer/PBM, HIPAA compliance). - Skills: list from Required Skills and Experience (the long list). Could also include some of the desired experience but we already put desired experience under Qualifications. Might be overlapping. Perhaps better: Required Skills and Experience under Skills; Desired experience under Qualifications; Professional Certifications under Qualifications; Formal Education under Qualifications. - Pay: salary range. - Benefits: none => omit. - Schedule: not explicit; we have Full Time but that's type; schedule not given. Could omit. We must not create sections with filler. So we will include About the role, Responsibilities, Requirements, Qualifications, Skills, Pay. Now we need to ensure we preserve all substantive information. Let's extract details. About the role: - Syms Strategic Group (SSG) seeking Senior Systems Engineer (AWS Data Engineer) - II. - Location: Remote (100% U.S. based remote). - Department: Veterans Affairs (VA). - Type: Full Time, W-2 position. - Military Veterans highly encouraged to apply. - Candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be considered. (Location restriction) - Possibly also note that it's a remote position but limited to certain states. We should not repeat the job title as a heading, but we can mention it in the paragraph. Responsibilities: list each bullet from Essential Duties And Responsibilities. Let's extract them: 1. Lead the next phase of the healthcare data platform modernization 2. Implement 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 seamlessly 3. Evaluate and decide the right AWS data strategy for the platform 4. Evaluate 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 scalability 5. 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 6. 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 7. Build and