Federal Air Force Financial Database SME

Lodestar Consulting is currently seeking a full-time Financial Database Subject Matter Expert (SME) to join our team in support of the Air Force. We are a fast-growing small business (named to Inc5000s list of fast growing private companies in America multiple years in a row and Best Places to Work for consecutive years seeking dynamic thinkers and outstanding communicators who want to thrive in an entrepreneurial environment and grow with Lodestar Consulting Inc.

We focus on hiring and developing top talent to provide superior support to our clients and to grow and develop our team for long-term repeatable success. Our team members are experienced professional enthusiastic and able to quickly apply their skills to diverse situations to ensure our clients needs are met. If you love to solve problems assist clients in emerging technologies or simply drive meaningful change for clients theres a place for you at Lodestar Consulting!

This role will be 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 This role shall involve but is not limited to:

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

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

Desired Skills:

• 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)
  • Commanders 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)

Education:

• Bachelors Degree in Computer Science Information Technology Computer Engineering or related IT discipline; or equivalent experience

Security Clearance:

• Must have an Active DoD Secret Security Clearance (requires U.S. Citizenship).

The expected total compensation range for this position is between $110000 and $150000. This range is representative of base pay only and does not include 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).

Travel and relocation expenses may be considered based on the appropriate candidate. If you are looking to learn and contribute to a rapidly growing consulting and financial management business wed love to hear from you. PleaseNo Sponsors or Agencies!

EEO Notice
Applicants have rights under Federal Employment Laws

EEO Notice

Work location is subject to change based on client requirements.

Lodestar Consulting Inc. is an Equal Opportunity Employer and will consider all qualified applicants without regard to race color national origin ethnicity ancestry genetic information religion sex gender gender identity sexual orientation marital status pregnancy childbirth any medical condition related to pregnancy or childbirth age disability protected veteran status relationship or association to a protected veteran or any other characteristic protected by local state or federal laws rules or regulation.

If you would like to request a reasonable accommodation regarding accessibility of our website a modification or adjustment of the job application or interview process due to a disability please call or email Please be advised that this contact information is for accommodation requests only and cannot be used to inquire about the status of an application.

Family and Medical Leave Act (FMLA)

FMLA is designed to help employees balance their work and family responsibilities by allowing them to take reasonable unpaid leave for certain family and medical reasons. Lodestar Consulting Inc. provides eligible employees with 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)

The EPPA prohibits most private employers from using lie detector tests either for pre-employment screening or during the course of Consulting Inc. adheres all provisions of the EPPA.