Federal Data Analytics Consultant — Hybrid (DC)

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

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.