Data Analyst

We need to output HTML fragment with sections: headings

for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must only include sections that have real specific content. We must not repeat job title as heading. Must not include Job ID etc. Must preserve all substantive info. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. Also remove "Application Deadline: December 14, 2026" maybe considered application instruction? It's a deadline; maybe considered application instruction, but it's a date. The instruction says remove application instructions. Likely we should remove that line. Also remove "See below, to name a few:" maybe part of benefits list; we keep benefits list. We need sections: About the role (maybe from description after job title). Responsibilities (Key Responsibilities). Requirements (maybe Required Experience/Skills). Qualifications (Preferred Qualifications). Skills (Required Technical Skills). Benefits (Benefits). Pay (Salary And Benefit Information). Schedule (Work Location/hybrid schedule). Also maybe Clearance info could go under Requirements or About the role. We'll embed in appropriate sections. We must not create sections with placeholder/filler like "commensurate with experience". We have actual salary range, so Pay section is valid. Schedule: we have hybrid schedule details, so we can include Schedule section. We must not repeat job title. Use

for each section heading. We need to use

• for any list of duties/requirements/benefits. For prose use

  . We need to preserve all substantive info. Let's extract content. Job Details Description: includes job title line, clearance required, work location, then paragraph about role. Let's parse: - Clearance Required: DHS Public Trust, US Citizen (Secret Clearance or above preferred) - Work Location: Hybrid; onsite 2 days a week minimum/once a month on-site customer facing meeting; in the National Capital Region (Arlington, VA or Washington, DC) (applicants must be based within a commutable distance (no more than 2 hours) within the National Capital Region Then paragraph: "Alpha Omega is currently seeking a detail-oriented Data Analyst to join one of our long-term Federal projects. The 287(g) Data Analyst is responsible for the end-to-end data lifecycle of the 287(g) program. The Data Analyst complex data pipelines involving automated email intake, data extraction, normalization, and direct ingestion into tracking tools. This role demands high proficiency in maintaining data integrity, executing security-sensitive document handling (PII/CUI), and ensuring seamless coordination between operational stakeholders and federal security units." Probably missing a verb: "The Data Analyst [manages] complex data pipelines..." but we keep as is. Then "Key Responsibilities" heading followed by list items. We need to convert each bullet into

• . The bullet list includes multiple items each with sub-bullets? Actually each responsibility is a heading like "Automated Data Engineering & Intake:" then sub-items like "Pipeline Management:", "Data Transformation:", etc. We need to decide how to structure. Probably treat each top-level bullet as
• and include its sub-items as nested
  or as part of same
  • text. Simpler: keep as plain text within
  • preserving the sub-bullets as lines. We'll produce
    with
    • for each responsibility heading and its content. Similarly for Required Technical Skills: list items. Required Experience/Skills: list. Preferred Qualifications: list. Education: maybe part of Requirements? It says "(Required Or Preferred) Education Bachelor’s degree in business or an IT related field." We'll include under Requirements or Qualifications? Probably under Requirements as it's required or preferred. We'll put under Requirements. Benefits: list items after "Benefits Joining the Alpha Omega team entitles you to participate in all retirement benefits..." then list: "15 days PTO including paid parental, military, and bereavement leave", "Eleven (11) paid Federal holidays, five of which are floating holidays...", "Health and Dental Insurance (including 100% employer paid premiums for employee coverage under the HDHP health plan)", "Life Insurance, STD/LTD term disability coverage, with employer paid premiums", "401 (k) plan with a match that is 100% vested after you complete two years of service", "FSA/DFSA/HSA flexible benefit plans", "Annual Tuition & Professional Development Reimbursement benefit." We'll keep as
      • . Pay: Salary And Benefit Information paragraph includes salary range and disclaimer. We'll keep as

        . Schedule: Work Location/hybrid schedule details. We'll put under Schedule section. About the role: maybe combine the initial paragraph and clearance/work location? We'll create About the role section with that descriptive paragraph plus clearance and work location details. We must not repeat job title. So About the role heading

        About the role

        then

        containing the description. We need to ensure we don't include boilerplate like "Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity Employer..." etc. Remove that. Also remove "#dice" etc. Now produce HTML fragment. Let's craft:

        About the role

        Alpha Omega is currently seeking a detail-oriented Data Analyst to join one of our long-term Federal projects. The 287(g) Data Analyst is responsible for the end-to-end data lifecycle of the 287(g) program. The Data Analyst [manages] complex data pipelines involving automated email intake, data extraction, normalization, and direct ingestion into tracking tools. This role demands high proficiency in maintaining data integrity, executing security-sensitive document handling (PII/CUI), and ensuring seamless coordination between operational stakeholders and federal security units.

        Clearance Required: DHS Public Trust, US Citizen (Secret Clearance or above preferred)

        Work Location: Hybrid; onsite 2 days a week minimum/once a month on-site customer facing meeting; in the National Capital Region (Arlington, VA or Washington, DC) (applicants must be based within a commutable distance (no more than 2 hours) within the National Capital Region)

        But we used which is not prohibited but maybe better to keep as plain text. Could embed in

        . It's okay. Alternatively we could incorporate clearance and work location into the same

        . We'll keep as separate

        for clarity. Now Responsibilities:

        Responsibilities

        • Automated Data Engineering & Intake:
          • Pipeline Management: Oversee and maintain Power Automate workflows for inbox monitoring, PDF staging, and automated record creation.
          • Data Transformation: Utilize Python-based extraction processes to convert raw PDF forms into standardized JSON records. Ensure normalized field mapping for ingestion.
          • Quality Assurance: Perform daily data quality audits to reconcile discrepancies between system records, troubleshoot JSON ingestion failures, and ensure source of truth consistency.
        • Clearance & Credentialing Operations:
          • Security Processing: Manage the initiation and submission of background investigation packets for 287(g) programs. Verify all documents for completeness and signature validity.
          • Compliance Protocol: Manage strict PII/CUI security standards, including password-protected file handling and secure transmission of initiation packets.
          • Lifecycle Tracking: Maintain process visibility via Tableau and tracking tools; proactively flag stale cases or clearance blockers to federal leads.
        • Training & Certification Support:
          • Training Readiness: Monitor training mailboxes, validate course eligibility, and execute "Pass/Fail" updates in SharePoint.
          • Credentialing Fulfillment: Execute manual and automated shipping batches. Oversee the generation, attachment, and distribution of G-570/G-504 documents; track receipt/verification status to close out credentialing loops.
        • Stakeholder Communication: Serve as the primary point of contact for external agencies regarding training access, login errors, and enrollment status, following standardized escalation/response SOPs.
        • PMO Operational Governance:
          • Reporting: Generate recurring and ad-hoc reports using Excel-based data sets and cross-functional trackers.
          • Documentation: Maintain SOPs, tracking tables, and SharePoint repository structures. Ensure all programmatic communications and work products are logged for transition continuity and institutional knowledge retention.
        Now Required Technical Skills:

        Required Technical Skills

        • Automation: Advanced working knowledge of Power Automate (cloud flows, triggers, conditional logic) and Python (data extraction/parsing/JSON).
        • Data Systems: Proficiency in SharePoint (list management, complex folder structures) and Tableau (data visualization and status reporting).
        • Records Management: Proven experience handling PII and CUI in accordance with federal security protocols; ability to manage password-encrypted document workflows.
        • Analytical Discipline: Ability to reconcile data across disparate systems and maintain 100% accuracy in highly regulated environments.
        Now Required Experience/Skills:

        Required Experience/Skills

        • 2+ years as a Data Analyst.
        • Experience collaborating with stakeholders at varied levels.
        • Must be able to successfully complete the DHS security and suitability background check.
        • Proven ability to use all Microsoft Office tools.
        • Excellent customer service, attention to detail.
        • Excellent oral and written communication skills.
        • Must be able to work in a team environment.
        • Excellent organizational skills.
        • Ability to learn new systems and processes quickly.
        • Proven ability to execute in an agile environment.
        • Willingness to be hands-on and backfill for team members as needed.
        • Education: Bachelor’s degree in business or an IT related field.
        Now Preferred Qualifications:

        Preferred Qualifications

        • Active or previous DHS experience highly desired.
        • Working knowledge of SAFe methodology.
        • Proven history of delivering data driven solutions with a customer-first mindset.
        Now Benefits:

        Benefits

        • 15 days PTO including paid parental, military, and bereavement leave
        • Eleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company’s holiday schedule each year)
        • Health and Dental Insurance (including 100% employer paid premiums for employee coverage under the HDHP health plan)
        • Life Insurance, STD/LTD term disability coverage, with employer paid premiums
        • 401 (k) plan with a match that is 100% vested after you complete two years of service
        • FSA/DFSA/HSA flexible benefit plans
        • Annual Tuition & Professional Development Reimbursement benefit
        Now Pay:

        Pay

        The likely salary range for this position is $65,000 - $110,000. This is not, however, a guarantee of compensation or salary. There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, education and certifications as well as contract provisions regarding labor categories that are specific to the position and could fall outside of this range.

        Now Schedule:

        Schedule