Soni
Base pay range
$28.00/hr - $31.00/hr
Renowned University is seeking a
Finance & Grant Analyst
for a 3-month assignment!
Job Responsibilities
Labor transactions
Submitting Salary distributions and Cost Transfers
Research Enhancement calculations (1/9s versus 1/12s)
Suspense and Pass-Thru Clearance
Funding Plans and Hiring Trackers
Update all funding plans and transfer all financial information to hiring tracker
Input the correct combocode and chartstring for every individual
Serve as a second check on projects listed to make sure projects have funds
Confirm correct split of coverage for GRAs
Manage the Affiliates and make sure they sign their funding plans
CRF fees
Create the annual Tracker and collect the chartstring from funding plans and portfolio managers
Initiate all recovery transactions (ITFs)
Reports (Quarterly, Monthly, Forecasting element)
Assist the Grants team with updating the quarterly and monthly financial reports
Assist the Grants team with any adhoc analysis (i.e. forecasting lab solvency)
Create and streamline new processes and reports to make grant management easier
DSS tracker
Maintain on a semester basis to make sure no PIs overuse their DSS allowance
TEL and Internet Stipend
Update the tracker to collect the information for the upcoming fiscal year
Assist the Grants/Finance team with collecting the attestations from PIs who will be collecting the stipend
Subaward Invoice Tracker
Download the list of all grants and filter based on which projects end within the next 90 days (idea for the future).
Assists with the review and clearance of payroll suspense
Identifies incorrect salary disbursements against salary budgets, researches errors, and implements the necessary corrections using the University's Labor Accounting and ARC systems.
Initiate electronic salary transactions in ARC, including cost transfers, salary distributions and additional compensation.
Prepare monthly and quarterly statistical and financial reports related to payroll.
Perform a variety of financial activities, including salary distributions, cost transfers and Internal Transfer Journals (ITFs)
Maintains accurate, complete and updated financial data on a timely, ad hoc basis, using multiple applications.
Prepares and cleans up data for monthly and quarterly reports.
Generate and maintain funding plans for XX faculty and, through close collaboration with the Payroll Team, ensure that the funding plans are implemented accurately and in a timely fashion.
Requirements
1-2 years of previously related experience.
Demonstrated fiscal responsibility and comprehensive knowledge of accounting, financial reporting, and analysis.
Knowledge of post-award grant processes, specifically with accounting, financial reporting, and budgeting.
Proficiency in Microsoft Office (with a special emphasis on Excel) and the ability to use Google Docs/Sheets, as well as quickly learn new software programs as required.
Excellent communication, organization and interpersonal skills, including meticulous attention to detail and the ability to work efficiently and effectively with a diverse team.
Previous experience with Columbia University systems, including PAC, ARC, FinSys is preferred.
Compensation $28-$31/ Hour Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications.
Seniority level Not Applicable
Employment type Contract
Job function Finance and Accounting/Auditing
Industries Higher Education and Non-profit Organizations
#J-18808-Ljbffr
Renowned University is seeking a
Finance & Grant Analyst
for a 3-month assignment!
Job Responsibilities
Labor transactions
Submitting Salary distributions and Cost Transfers
Research Enhancement calculations (1/9s versus 1/12s)
Suspense and Pass-Thru Clearance
Funding Plans and Hiring Trackers
Update all funding plans and transfer all financial information to hiring tracker
Input the correct combocode and chartstring for every individual
Serve as a second check on projects listed to make sure projects have funds
Confirm correct split of coverage for GRAs
Manage the Affiliates and make sure they sign their funding plans
CRF fees
Create the annual Tracker and collect the chartstring from funding plans and portfolio managers
Initiate all recovery transactions (ITFs)
Reports (Quarterly, Monthly, Forecasting element)
Assist the Grants team with updating the quarterly and monthly financial reports
Assist the Grants team with any adhoc analysis (i.e. forecasting lab solvency)
Create and streamline new processes and reports to make grant management easier
DSS tracker
Maintain on a semester basis to make sure no PIs overuse their DSS allowance
TEL and Internet Stipend
Update the tracker to collect the information for the upcoming fiscal year
Assist the Grants/Finance team with collecting the attestations from PIs who will be collecting the stipend
Subaward Invoice Tracker
Download the list of all grants and filter based on which projects end within the next 90 days (idea for the future).
Assists with the review and clearance of payroll suspense
Identifies incorrect salary disbursements against salary budgets, researches errors, and implements the necessary corrections using the University's Labor Accounting and ARC systems.
Initiate electronic salary transactions in ARC, including cost transfers, salary distributions and additional compensation.
Prepare monthly and quarterly statistical and financial reports related to payroll.
Perform a variety of financial activities, including salary distributions, cost transfers and Internal Transfer Journals (ITFs)
Maintains accurate, complete and updated financial data on a timely, ad hoc basis, using multiple applications.
Prepares and cleans up data for monthly and quarterly reports.
Generate and maintain funding plans for XX faculty and, through close collaboration with the Payroll Team, ensure that the funding plans are implemented accurately and in a timely fashion.
Requirements
1-2 years of previously related experience.
Demonstrated fiscal responsibility and comprehensive knowledge of accounting, financial reporting, and analysis.
Knowledge of post-award grant processes, specifically with accounting, financial reporting, and budgeting.
Proficiency in Microsoft Office (with a special emphasis on Excel) and the ability to use Google Docs/Sheets, as well as quickly learn new software programs as required.
Excellent communication, organization and interpersonal skills, including meticulous attention to detail and the ability to work efficiently and effectively with a diverse team.
Previous experience with Columbia University systems, including PAC, ARC, FinSys is preferred.
Compensation $28-$31/ Hour Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications.
Seniority level Not Applicable
Employment type Contract
Job function Finance and Accounting/Auditing
Industries Higher Education and Non-profit Organizations
#J-18808-Ljbffr