This role is responsible for designing and implementing database solutions that enable accurate data extraction, transformation, and comparison between Sub-Ledger and General Ledger (GL) systems. This role supports detailed audit research and analysis by developing reliable, repeatable comparison tools and data structures that facilitate reconciliation, root-cause analysis, and audit remediation. Responsibilites include but not limited to:
- Design and maintain database architectures to support extraction, storage, and analysis of financial data from Sub-Ledger and General Ledger systems.
- Develop data models that enable efficient reconciliation, traceability, and auditability of financial transactions.
- Ensure database designs support scalability, performance, and data integrity.
- Develop and optimize data extraction processes from source systems, including sub-ledgers and general ledger environments.
- Perform data transformation and normalization to enable accurate cross-system comparisons.
- Ensure extracted data aligns with accounting structures, chart of accounts, and reporting requirements.
- Build automated or semi-automated tools to compare sub-ledger and general ledger data.
- Design queries, views, and scripts to identify discrepancies, variances, and anomalies.
- Enable drill-down capabilities to trace discrepancies to source transactions.
- Implement data validation and reconciliation controls to ensure accuracy and completeness of extracted data.
- Develop technical documentation describing database structures, extraction logic, data assumptions, mappings, transformation logic, and comparison methodologies.
- Support testing and validation of comparison tools to confirm audit reliability.
- Support auditors and financial analysts by providing data extracts, comparison outputs, and technical explanations.
Qualifications- Bachelor's degree
- Minimum 4 years of relevant experience designing and managing databases in support of financial or audit-related analytics
- Strong proficiency in SQL and database architecture principles
- Experience extracting, transforming, and reconciling data across multiple systems
- Familiarity with financial systems, Sub-Ledgers, and General Ledger structures
- Ability to obtain a U.S. secret level security clearance (requires US Citizenship)
Preferred Qualifications
- MA/MS
- Experience working in regulated or audited financial environment
- Experience supporting financial audits or audit-readiness initiatives
- Experience supporting large enterprise financial systems (e.g., ERP environments, DEAMS)
- Experience working in regulated, secure, Department of Defense or other federal agency environments
- Detailed familiarity with AF Lines of Accounting and financial data elements
- Knowledge of accounting principles related to Sub-Ledger and General Ledger integration
- Knowledge of Air Force financial and logistics systems, such as:
- Access Online (AXOL)
- Advana
- Automated Disbursing System (ADS)
- Air Force Equipment Management System (AFEMS)
- Automated Funds Management (AFM)
- Central Disbursing System (CDS)
- Civilian Pay Accounting Interface System (CPAIS)
- Central Procurement Accounting System (CPAS)
- Commanders' Resource Integration System (CRIS)
- Defense Cash Accountability System (DCAS)
- Defense Cash Management System (DCMS)
- Defense Civilian Payroll System (DCPS)
- Defense Enterprise Accounting System (DEAMS)
- Defense Departmental Reporting System (DDRS)
- Deployable Disbursing System (DDS)
- Defense Transaction Interface Module (DTIM)
- Financial Management Suite (FMSuite); FRC module
- General Accounting and Finance System Base Level (GAFS-BL)
- General Accounting and Finance System Re-Engineered (GAFS-R)
- Integrated Accounts Payable System (IAPS)
- Intra-governmental Payment and Collection (IPAC)
- Job Order Cost Accounting System II (JOCAS II)
- Mechanization of Contract Administration System (MOCAS)
- Procurement Integrated Enterprise Environment (PIEE)
- Reserve Travel System (RTS)
- Standard Base Supply System (SBSS)
- Standard Materiel Accounting System (SMAS)
- Wide Area Work Flow (WAWF)
The expected salary range for this position is between $80,000 and $140,000. This range is representative of base pay only and does not include straight time pay for hours worked over 40 per week, company contributions towards paid benefits, and/or bonuses. Actual compensation (meeting or exceeding the range) will be determined based on specific experience, education, work location, clearance level, and other factors permitted by law. This position is eligible for bonuses (when applicable).
We also offer a competitive benefits package that includes:
- Medical, Dental, Vision, Life, AD&D, and Disability Insurance
- 401(k) Retirement Plan and 529 Education Savings Plan
- Flexible Spending & Health Savings Account
- Accident, Critical Illness, Hospital Indemnity Insurances
- Legal Insurance and Pet Insurance
- Employee Assistance Program, fitness and wellness benefits, and other firm benefits.
- Paid holidays, vacation, and sick time
Work location is subject to change based on client requirements.
