Data Analytics Consultant

Alpha Omega Integration; Washington (District of Columbia); Hybrid; USD 80,000 - 115,000; Full time

Benefits offered by this job

PTO 15 days

Federal holidays 11

Health insurance

Life insurance

401(k) match

Tuition reimbursement

Job summary

Alpha Omega Integration is seeking a Data Analytics Consultant to own the end-to-end data lifecycle for the 287(g) program, managing data pipelines, clearance tracking, and cross-functional reporting. The role focuses on data integrity, secure handling of PII/CUI, and tight coordination with federal security units.

The ideal candidate has 10+ years in IT/data architecture, experience with Python, Power Automate, Tableau, and a background in federal programs, with a Bachelor's degree required.

Qualifications

• 10+ years of relevant experience in IT and data architecture.
• Experience with end-to-end data lifecycle and data quality.
• Federal program experience preferred.
• Bachelor’s degree required.

Responsibilities

• Automated Data Engineering & Intake: develop pipelines and intake processes.
• Pipeline Management: oversee Power Automate workflows and data ingestion.
• Data Transformation: convert PDF forms to JSON with normalized fields.
• Quality Assurance: daily data quality audits and issue resolution.
• Clearance & Credentialing Operations: manage background investigation packets.
• Security processes: ensure secure handling and transmission of sensitive data.
• Lifecycle Tracking: track cases in Tableau and other tools.
• Reporting: generate Excel-based reports and trackers.
• Documentation: maintain SOPs and SharePoint records.

Skills

Data architecture

End-to-end data lifecycle

ETL pipelines

Power Automate

Python

Tableau

Stakeholder communication

Security/compliance

Federal program

Background clearance

Education

Bachelor’s Degree in IT Systems Engineering, Computer Science, or related

Tools

Power Automate

Python

Tableau

Excel

JSON/ETL tooling

Job description

Job Title: Data Analytics Consultant
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.

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

Required Qualifications:

Required Experience/Skills:

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

(Required or Preferred) Education:

• Bachelor’s Degree in IT Systems Engineering, Computer Science, or a related academic focus area.

Salary and Benefit Information:

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.

Application Deadline:

October 31, 2026

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.

Our Company:

Alpha Omega is an award-winning solutions provider dedicated to delivering mission-enabling technology and strategic solutions for our customers. Since our founding in 2016, we have grown to over 700 employees nationwide consisting of former operators, technologists, and strategists who bring decades of government and industry experience. They are united by one purpose: ensuring our nation’s continued global leadership.

We have a unified operating model providing technical capabilities and solutions for customers across two main business units:

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

Through strategic partnerships, intellectual property, and relentless drive for innovation, Alpha Omega is shaping the future of government technology. We are proud to be a Virginia Best Places to Work 8 times, an Inc. 5000 honoree 7 times, and a Washington Post Top Workplaces 4 times. Join us in driving transformation that secures the nation's future.

Culture and Values:

Guided by our core values—Harmony, Engagement, Accountability, Resourcefulness, and Tenacity (HEART)— we foster a culture of innovation, collaboration, and continuous learning and are committed to delivering high-impact solutions. We recognize and reward hard work.

Alpha Omega's culture is driven by our values and mission. We invest in top talent through mentorship, growth, and meaningful work. We value individuality, reward integrity, and foster a diverse, high-performing team united by purpose-at work, in service, and in the community.

Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.