Audit-Driven Database Architect for Financial Reconciliation

Kearney & Company; Dayton (OH); On-site; USD 80,000 - 140,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

AD&D Insurance

Disability Insurance

401(k) Plan

529 Education Savings Plan

Flexible Spending Account

Health Savings Account

Paid holidays

Vacation

Sick time

Job summary

Kearney & Company seeks a Database Architect Subject Matter Expert to design and implement database solutions enabling precise data extraction, transformation, and cross-system comparison between Sub-Ledger and General Ledger environments. You will develop scalable data models, support audit readiness, and provide technical explanations to auditors and analysts.

This role requires strong SQL skills, a Bachelor's degree, and the ability to obtain a U.S. secret security clearance.

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)

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.

Skills

SQL

Database architecture

Data extraction

Data transformation

Cross-system reconciliation

Audit support

Security clearance

Education

Bachelor's degree

Job description

Kearney & Company seeks a Database Architect Subject Matter Expert to design and implement database solutions enabling precise data extraction, transformation, and cross-system comparison between Sub-Ledger and General Ledger environments. You will develop scalable data models, support audit readiness, and provide technical explanations to auditors and analysts.

This role requires strong SQL skills, a Bachelor's degree, and the ability to obtain a U.S. secret security clearance.