Federal - Air Force Financial Database SME

Lodestar Consulting • Dayton, OH

4d • Onsite

About The Position

Lodestar Consulting is seeking a full-time Financial Database Subject Matter Expert (SME) to support the Air Force. Lodestar Consulting is a fast-growing small business recognized for its rapid growth and as a Best Place to Work. We are looking for dynamic individuals who thrive in an entrepreneurial environment and want to grow with the company. Our focus is on hiring and developing top talent to provide superior client support and achieve long-term success. Team members are experienced, professional, enthusiastic, and adaptable to ensure client needs are met. This role is responsible for designing and implementing database solutions for accurate data extraction, transformation, and comparison between Sub-Ledger and General Ledger (GL) systems. It supports detailed audit research and analysis by developing reliable, repeatable comparison tools and data structures for reconciliation, root-cause analysis, and audit remediation.

Requirements

• 5+ years of relevant 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.
• Bachelor's Degree in Computer Science, Information Technology, Computer Engineering or related IT discipline; or equivalent experience.
• Must have an Active DoD Secret Security Clearance (requires U.S. Citizenship).

Nice To Haves

• Experience working in regulated or audited financial environments.
• 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.
• Familiarity with the following systems/software and terminology preferred: Access Online (AXOL), Advana, Central Disbursing System (CDS), Commander's Resource Integration System (CRIS), Defense Cash Management System (DCMS), Defense Enterprise Accounting Management System (DEAMS), 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), Mechanization of Contract Administration System (MOCAS), Procurement Integrated Enterprise Environment (PIEE), Reserve Travel System (RTS), Standard Base Supply System (SBSS), Wide Area Work Flow (WAWF).

Responsibilities

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

Benefits

• Company contributions towards paid benefits
• Bonuses (when applicable)
• Travel and relocation expenses may be considered
• Family and Medical Leave Act (FMLA) - up to 12 weeks of unpaid, job-protected leave per year. Military family leave is available for up to 26 weeks under FMLA.
• Employee Polygraph Protection Act (EPPA) adherence.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior