Data Analyst
Alpha Omega Integration LLC
Job Title: Data Analyst
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 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. Key Responsibilities:
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 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. Key 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 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.
- 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.
- 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.
- Active or previous DHS experience highly desired.
- Working knowledge of SAFe methodology.
- Proven history of delivering data driven solutions with a customer-first mindset.
- Bachelor's degree in business or an IT related field.
- 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.
- National Security - supporting agencies such as the Department of Homeland Security (DHS), Navy, Air Force, Army, and the Department of State (DOS).
- National Resilience - supporting agencies such as Federal Deposit Insurance Corporation (FDIC), Treasury, Health & Human Services (HHS), National Institutes of Health (NIH), National Oceanic and Atmospheric Administration (NOAA) and the United States Department of Agriculture (USDA)
Vacancy posted more than 2 months ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Analyst. Be the first to apply!
Related searches
- entry level information security analyst Arlington, VA
- data protection analyst Arlington, VA
- senior data management analyst Arlington, VA
- data analyst - r python sql Arlington, VA
- data visualization analyst Arlington, VA
- data analyst Arlington, VA
- client data analyst Arlington, VA
- senior data governance analyst Arlington, VA
- manufacturing data analyst Arlington, VA
- temporary data analyst Arlington, VA
