Business Intelligence Analyst (On-Site)

Cornell Scott-Hill health•New Haven, CT

22h•Onsite

About The Position

The Financial Analyst is responsible for the timely and accurate preparation of journal entries, reconciliation of general ledger accounts, monitoring of budgets, management of Capital grants, and to perform routine and/or ad-hoc financial analysis as needed. He/she has the ability to interface well with the Accounts Payable, Purchasing, Billing and Payroll departments and navigate their specialized software.

Requirements

Bachelor’s Degree in Accounting, Business Administration or related field is required.
Two (2) years of relevant experience may be substituted for each year of academic work.
Must encompass strong interpersonal skills as well as motivated and demonstrate initiative.
Extensive knowledge of Word and Excel and willingness to learn other software required.
Excellent analytical skills, organizational skills, ability to pay attention to detail and ability to work well with others are essential.
Knowledge of general accounting principles/procedures and budgetary practices and analysis.
Ability to monitor, audit, reconcile, and balance a variety of budgets, financial data and transactions.
Ability to research, analyze and retrieve financial data to prepare accurate reports.
Excellent communication skills are needed, both written and verbal.

Responsibilities

Responsible for monitoring, reconciling and maintaining CS-HHC’s fixed asset system and the preparation of monthly and annual journal entries (JE) to MIP. Includes accuracy in coding, assigning asset life, allocation of depreciation expense and the ongoing maintenance of an accurate detailed record of all fixed asset purchases.
Tracks all CIP accounts, insuring proper coding of purchases as well as the timely and accurate transfer from CIP to Furniture, Fixture, and Equipment as required.
Responsible for CS-HHC’s Capital grants, insuring accurate recording of revenue and expense, receivable and deferred accounts.
Responsible for the timely and accurate submittal of all assigned Capital grant/contract financial expenditure reports.
Prepares monthly calculation of capital grant draw-down amounts through HRSA.
Prepares renewal applications and expenditure reports for federal and non-federal Capital grants.
Prepares year end Grant reports, schedules, and analysis for CS-HHC annual audit and assists with all audits.
Responsible for managing miscellaneous contracts with Yale.
Classifies expenses, codes and assigns numbers to all grants.
Prepares the monthly Facilities Allocation JE and analysis; maintains the Facilities allocation tables in MIP, working with the Director of Purchasing to incorporate timely square footage changes.
Responsible for the monthly Administration Allocation JE and analysis.
Prepares and/or assists with the month end ADP Payroll Accrual JE.
Collaborates with business office and payroll staff to ensure the cost/salaries are allocated to the appropriate grants; prepares retroactive reclassification journal entries as necessary.
Responsible for accurate reconciliation of general ledger expense accounts with budget/financial reports; prepares re-classification and routine journal entries as needed.
Performs all other duties as assigned