Data Analyst

Alpha Omega Integration • Arlington, VA

11d • Hybrid

About The Position

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.

Requirements

• Advanced working knowledge of Power Automate (cloud flows, triggers, conditional logic) and Python (data extraction/parsing/JSON).
• Proficiency in SharePoint (list management, complex folder structures) and Tableau (data visualization and status reporting).
• Proven experience handling PII and CUI in accordance with federal security protocols; ability to manage password-encrypted document workflows.
• Ability to reconcile data across disparate systems and maintain 100% accuracy in highly regulated environments.
• 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.

Nice To Haves

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

Responsibilities

• Oversee and maintain Power Automate workflows for inbox monitoring, PDF staging, and automated record creation.
• Utilize Python-based extraction processes to convert raw PDF forms into standardized JSON records. Ensure normalized field mapping for ingestion.
• Perform daily data quality audits to reconcile discrepancies between system records, troubleshoot JSON ingestion failures, and ensure source of truth consistency.
• Manage the initiation and submission of background investigation packets 287(g) programs. Verify all documents for completeness and signature validity.
• Manage strict PII/CUI security standards, including password-protected file handling and secure transmission of initiation packets.
• Maintain process visibility via Tableau and tracking tools; proactively flag stale cases or clearance blockers to federal leads.
• Monitor training mailboxes, validate course eligibility, and execute "Pass/Fail" updates in SharePoint.
• 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.
• Serve as the primary point of contact for external agencies regarding training access, login errors, and enrollment status, following standardized escalation/response SOPs.
• Generate recurring and ad-hoc reports using Excel-based data sets and cross-functional trackers.
• Maintain SOPs, tracking tables, and SharePoint repository structures. Ensure all programmatic communications and work products are logged for transition continuity and institutional knowledge retention.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level