An official State of Ohio site. Here’s how you know
Live Chat
Contact
ODJFS Logo in OMJ Seeker Header

in
Database Architect SME Job in Dayton, Ohio US

Database Architect SME

Kearney & Company - Dayton, OH

Posted: 3/14/2026 - Expires: 6/12/2026

Job ID: 293278906

Report this job
Apply Now
Print 

Job Description

Job Description
Kearney & Company is seeking a Database Architect SME to join our team. The Database Architect SME 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. Responsibilities 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 5 years of relevant designing and managing databases, preferably in support of financial or audit-related analytics
Strong proficiency in SQL and database architecture principles
Strong proficiency in Databricks and/or Palantir Foundry
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

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
Knowledge of Air Force financial and logistics systems, such as:
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)
General Accounting and Finance System Base Level (GAFS-BL)
General Accounting and Finance System Re-Engineered (GAFS-R)
Integrated Accounts Payable System (IAPS)
Job Order Cost Accounting System II (JOCAS II)
Procurement Integrated Enterprise Environment (PIEE)
Reserve Travel System (RTS)
Standard Base Supply System (SBSS)
Standard Materiel Accounting System (SMAS)
Wide Area Work Flow (WAWF)

Detailed familiarity with AF Lines of Accounting and financial data elements
Knowledge of accounting principles related to Sub-Ledger and General Ledger integration

Overview

Exclusively focused on the Government, Kearney & Company provides financial services, including auditing, consulting, and technology services. Our commitment to our employees and clients as well as to dedication and trust, critical values to our Firm, have led to Kearney's recognition as one of the leading accounting firms in the country. Based on our employees' feedback, we are also consistently rated a Best Place to Work. Employment at Kearney means a flexible, collaborative, and open-minded work environment. We hope it is your "first easy decision." Learn more at www.kearneyco.com/careers

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

EEO Notice

Applicants have rights under Federal Employment Laws
EEO Notice
Work location is subject to change based on client requirements.

Kearney & Company 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. Click here for more information on Kearney's EEO Policy.

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 703-236-2391 or email accommodations@kearneyco.com 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. Kearney & Company 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. Click here to learn more.



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 employment. Kearney & Company adheres all provisions of the EPPA. Click here to learn more.

Job Summary

Employment Type:
Full Time Employee
Job type:
Federal Contractor
Skill Based Partner:
No
Education Level:
Bachelor's degree
Work Days:
Mon, Tue, Wed, Thu, Fri
Job Reference Code
86560120
Salary
N/A
Licenses / Certifications:
N/A
Display Recommended WorkKeys®Recommended WorkKeys®:
Applied Math: 4
Graphic Literacy: 4

Workplace Documentation: 5