Data Analytics & Audit Support Analyst II

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

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