Budget Analytics Accountant for Health Service Finance

The Indian Health Service; Phoenix (AZ); On-site; USD 106,000 - 138,000; Full time

Job summary

The Indian Health Service in Phoenix, AZ seeks a financial analyst to support the Division of Budget Execution with detailed analysis, reconciliations, and reporting. The role requires advanced Excel usage and ability to consolidate data from multiple sources to inform management decisions.

Responsibilities include preparing year-end closing reports, maintaining fund ledger status, and advising on Continuing Resolution allocations and funding requests. Openings: 2; salary range posted.

Qualifications

• Utilizes advanced Excel functionality (e.g., pivot tables, macros, complex formulas, data modeling) to manage, manipulate, and present large and complex datasets accurately and efficiently.
• Crosscuts, consolidates, and analyzes large volumes of accounting and financial data drawn from multiple systems and sources to identify trends, anomalies, and funding issues, and to produce clear, actionable analytical products for management decision-making.
• Provides expert advice and technical assistance to Indian Health Service Headquarters and the 12 Area Offices regarding Continuing Resolution allocations, apportionments, allotments, allowances, and request for additional funds.

Responsibilities

• Issues allotments and allowances.
• Performs detailed analysis and prepares management reports.
• Performs reconciliations.
• Responds to data calls.
• Crosscuts, consolidates, and analyzes large volumes of accounting and financial data drawn from multiple systems and sources to identify trends, anomalies, and funding issues, and to produce clear, actionable analytical products for management decision-making.
• Utilizes advanced Excel functionality (e.g., pivot tables, macros, complex formulas, data modeling) to manage, manipulate, and present large and complex datasets accurately and efficiently.
• Analyzes and maintains manual and automated accounting system ledger accounts that reflect fund status of the accounts.
• Prepares fiscal year end closing reports and determines the necessary adjustments required to close out the subsidiary and general ledger accounts.
• Records monthly estimates of increases.
• Reconciles supporting document files with monthly reports of open account balances for all current and prior year fund accounts.
• Reviews and evaluates accounting procedures.
• Provides expert advice and technical assistance to Indian Health Service Headquarters and the 12 Area Offices regarding Continuing Resolution allocations, apportionments, allotments, allowances, and request for additional funds.
• Provides staff assistance to the Director in the accomplishment of recurring and special assignments.

Skills

Advanced Excel

Data analysis

Financial reporting

Pivot tables

Macros

Data modeling

Tools

Excel

Job description

The Indian Health Service in Phoenix, AZ seeks a financial analyst to support the Division of Budget Execution with detailed analysis, reconciliations, and reporting. The role requires advanced Excel usage and ability to consolidate data from multiple sources to inform management decisions.

Responsibilities include preparing year-end closing reports, maintaining fund ledger status, and advising on Continuing Resolution allocations and funding requests. Openings: 2; salary range posted.