Data Analytics Consultant at Alpha Omega in Washington, DC

Job description

• Clearance Required: Public Trust – Federal Client requires US Citizenship
• Work Location: Hybrid, Washington, DC
• Alpha Omega is seeking a qualified Data Analyst in support of our 287(g) Program customer. In this role, this individual will own the end-to-end data lifecycle for the 287(g) program, managing automated data pipelines, clearance and credentialing tracking, and cross-functional reporting to ensure data integrity and seamless coordination between operational stakeholders and federal security units.

Responsibilities

• 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.
• 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 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.
• 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.

Requirements

• 10+ years of relevant experience (education may not be combined); a minimum of 10 years of experience in technical, business, and solution architecting is required.
• Experience in identifying and classifying application components according to the specific business and performance objectives they support and the technologies they employ.
• Experience in analysis of the current application inventory and providing detailed application architecture guidelines to improve business processes.
• Experience working with Federal Architecture, Engineering, and other organizations to support application architecture planning, implementation, and maintenance.
• Expert in assessing performance of applications in producing business value and return on investment.
• Experience in conducting walkthroughs of the solution architectural design as needed/requested.
• Proven experience in IT Strategy and Solutions Engineering across emerging technologies and diverse platforms in a mixed-lifecycle environment.
• Bachelor’s Degree in IT Systems Engineering, Computer Science, or a related academic focus area.

Skills

Required

• Power Automate
• Python
• JSON
• Tableau
• SharePoint
• Excel
• Data quality audits
• PII/CUI security standards
• SOPs
• Solution architecting
• IT Strategy and Solutions Engineering

Benefits

• Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company’s policy and benefits manuals. See below, to name a few:
• 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
• We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.
• The likely salary range for this position is $80,000 - $115,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.