Air Force Financial Data Architect

Lodestarcs; Dayton (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

Lodestar Consulting is seeking a Financial Database Subject Matter Expert (SME) to design and implement database solutions that extract, transform, and compare data between Sub-Ledger and General Ledger systems for Air Force support.

The role emphasizes developing reliable reconciliation tools, data structures, and audit remediation capabilities, with a focus on scalability, data integrity, and thorough documentation. A DoD clearance and related experience are highly valued.

Qualifications

• Bachelor's degree or equivalent experience in IT/CS or related field.
• Strong experience designing and managing financial databases and audits.
• Proficient in SQL, data modeling, and cross-system data reconciliation.

Responsibilities

• Design and implement database solutions for extraction, transformation and cross-system comparison of financial data.
• Develop data models to support reconciliation, traceability, and auditability of transactions.
• Create automated tools to compare sub-ledger and general ledger data and identify discrepancies.
• Provide technical documentation and support testing and auditors with data extracts.

Skills

SQL

Database architecture

Financial data

Data reconciliation

Auditing

Education

Bachelor's Degree in CS/IT/Engineering

Tools

AXOL

Advana

CDS

CRIS

DEAMS

GAFS-R

GAFS-BL

IAPS

PIEE

WAWF

Job description

Lodestar Consulting is seeking a Financial Database Subject Matter Expert (SME) to design and implement database solutions that extract, transform, and compare data between Sub-Ledger and General Ledger systems for Air Force support.

The role emphasizes developing reliable reconciliation tools, data structures, and audit remediation capabilities, with a focus on scalability, data integrity, and thorough documentation. A DoD clearance and related experience are highly valued.