Job Requirements
MD
Secret Polygraph Unspecified
Career Level not specified
$100,000 - $120,000
Job Description
Data Analytics & Audit Support Analyst II
Location: Andrews AFB, Maryland (on-site / hybrid as required)
Salary Range: $100,000 - $120,000 annually
Employment Type: Full-time
Clearance: Ability to obtain/maintain U.S. Government clearance required
Position Overview
This role supports Air Force Financial Improvement and Audit Readiness (FIAR) and Security Assistance Account initiatives by delivering advanced data analytics, reconciliation, and audit traceability solutions. The position focuses on transforming complex financial and system data into defensible, auditor-ready evidence, enabling end-to-end transaction traceability and supporting audit assertions across financial and feeder systems.
Critical Skills & Experience
Key Responsibilities
Required Qualifications
Preferred Qualifications
Equal Employment Opportunity
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected under applicable federal or Maryland law.
Location: Andrews AFB, Maryland (on-site / hybrid as required)
Salary Range: $100,000 - $120,000 annually
Employment Type: Full-time
Clearance: Ability to obtain/maintain U.S. Government clearance required
Position Overview
This role supports Air Force Financial Improvement and Audit Readiness (FIAR) and Security Assistance Account initiatives by delivering advanced data analytics, reconciliation, and audit traceability solutions. The position focuses on transforming complex financial and system data into defensible, auditor-ready evidence, enabling end-to-end transaction traceability and supporting audit assertions across financial and feeder systems.
Critical Skills & Experience
- Python and/or SQL for data analysis, automation, and reconciliation
- Audit support and traceability (UoT tracing, reconciliations, evidence)
- DAF financial and feeder systems or comparable federal systems
- Databricks, Power BI, Qlik, or similar analytics platforms
- Relational databases, data structures, and system-to-system data flows
- Auditor-ready data outputs and documentation
Key Responsibilities
- Perform end-to-end transaction tracing (e.g., Universe of Transactions (UoT)) across financial and feeder systems
- Analyze and reconcile large, disparate datasets to support audit assertions and financial reporting
- Develop and automate data pipelines, scripts, and analytical processes using Python, SQL, or similar tools
- Build dashboards, reports, and visualizations to support audit readiness and leadership decision-making
- Apply data mining and statistical techniques to identify anomalies, trends, and discrepancies
- Support asset valuation and reconciliation through data analysis and system tracing
- Translate accounting and audit requirements into technical data solutions
- Maintain data lineage and auditor-ready documentation to support audit requests
- Respond rapidly to urgent data calls, RFIs, and audit requests in high-tempo environments
- Lead or support small teams or defined workstreams, as directed
- Other duties as assigned
Required Qualifications
- Bachelor's degree in a technical, financial, or related field, or 4+ years of relevant experience
- 5+ years of experience in data analytics, database development, or technical data analysis
- Hands-on experience with DAF financial systems or similar federal financial/feeder systems
- Proficiency in Python and/or SQL for automation, reconciliation, and analytics
- Experience with data platforms and visualization tools (e.g., Databricks, Power BI, Qlik)
- Solid understanding of relational databases, data structures, and system logic
- Experience supporting audit activities (UoT tracing, reconciliations, audit evidence preparation)
- Proven ability to deliver defensible, auditor-ready data outputs and documentation
- Strong analytical, problem-solving, and communication skills
Preferred Qualifications
- Experience with Foreign Military Sales (FMS) / Security Cooperation data or processes
- Familiarity with the Operational Air Force Financial Data Structure and Data Dictionary
- Strong background in audit readiness, remediation, and internal controls
- Experience integrating data analytics into financial statement audit support
- Experience with additional languages or tools (R, Scala, VBA)
Equal Employment Opportunity
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected under applicable federal or Maryland law.
group id: 10430981
