Federal Accountant: SQL-Driven Financial Reconciliations

Socket.dev; Alexandria (VA); On-site; USD 70,000 - 110,000; Full time

Job summary

Castro & Company, an Alexandria, Virginia-based Audit, Advisory and IT firm, seeks a Federal Accountant with 3+ years of federal financial management experience to support a key agency. You will analyze transactions, reconcile ledgers, run USSGL/GAAP checks, and assist with audits, ensuring accuracy and timely delivery.

Candidates must have a Bachelor's in Accounting; be able to pass a US government suitability check; experience with USSGL, SAP/FBMS, SQL, Excel; and possess strong

Qualifications

• Bachelor's Degree in Accounting or related field from an accredited university.
• Minimum 3 years of experience in Federal financial management, accounting, reporting, internal controls, financial systems, and program operations.
• Working knowledge of USSGL, GAAP, and FASAB/SFFAS standards, Treasury requirements, OMB Circular A-123, FMFIA, and the CFO Act.

Responsibilities

• Analyze a large volume of accounting transactions with a high degree of accuracy, researching variances for root cause and preparing corrective entries.
• Use SQL queries to research abnormal balances at the trial balance level and recommend corrective actions.
• Reconcile general ledger to subsidiary ledger and across multiple data sources (e.g., travel, payroll, overseas data, feeder systems), including USSGL fund analytics.
• Recommend accrual methodologies and validate accrued amounts across areas such as domestic invoices, overseas payments, and travel, in accordance with USSGL and GAAP.
• Support annual financial statement audits, including reviewing financial documentation in large accounting data systems and responding to Prepared by Client (PBC) requests.
• Provide Federal accounting services, including Accounts Receivable, Accounts Payable, and General Ledger support.
• Establish, modify, and maintain accounting element tables, fields, and system records related to vendors, suppliers, and accounting codes.
• Identify issues and recommend corrective actions to senior team members and client management, as appropriate.
• Meet critical deadlines while producing quality, detailed work product.

Skills

SQL queries

GL reconciliation

Excel

Problem solving

Teamwork

Education

Bachelor's Degree in Accounting

Tools

SAP/FBMS

Treasury systems

Job description

Castro & Company, an Alexandria, Virginia-based Audit, Advisory and IT firm, seeks a Federal Accountant with 3+ years of federal financial management experience to support a key agency. You will analyze transactions, reconcile ledgers, run USSGL/GAAP checks, and assist with audits, ensuring accuracy and timely delivery.

Candidates must have a Bachelor's in Accounting; be able to pass a US government suitability check; experience with USSGL, SAP/FBMS, SQL, Excel; and possess strong