Data Analytics & Audit Support Analyst II
Zachary Piper Solutions, Baltimore, MD, United States
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr