Carlow University is now accepting applications for our Sponsored Projects Accountant position. The Sponsored Projects Accountant, reporting to the University Controller, has responsibilities including oversight of grants management and indirect cost analysis, endowment analysis and spend reporting, development of complex financial dashboards and data warehouse analyses, management and reporting of university restricted funds and associated ad-hoc statistical analysis.
This role is lead accountant for restricted funding and related audit processes. The position will assist with financial planning and budgeting processes, analyzing complex financial statements and reports, preparing projections, and performing research and analysis as required by leadership. Adept at providing financial projections and making recommendations based upon ongoing analysis of university resources. Acts as a strong strategic resource to the Controller and Vice President of Finance and Business Development.
JOB DUTIES :
Government Grants Management - percentage of time = 25%
- Prepare monthly budget vs actual financial reports for Federal grants, communicate financial data to stakeholders to develop effective forecasting and provide decision aides
- Prepare periodic and final financial reporting for submission to federal agencies including DOE, HRSA, NSF and support principal investigator to compile information for agency audit inquiries
- Review expenditures to ensure compliance with federal guidelines, including uniform guidance 2 CFR Part 200 Uniform Administrative requirements, cost principles, and audit requirements for federal awards
- Serve as a resource on grant administration, actively collaborating with grant principal investigators and fund managers regarding inquiries on administrative, financial or programmatic issues for grant activities
- Assist principal investigator in preparation of financial components of proposals and review budgets for compliance and spend timeline
- Create grant accounts set-up in ERP system and monitor cost-sharing requirements for fulfillment
- Serve as overall technical accounting resource to Controller and other university staff
- Calculate amount of indirect costs earned based upon grant spend, report actuals earned, used and forecast future indirect revenues
- Review and approve expenditure requisitions and orders in E-Procurement system for compliance with federal guidelines ensuring costs are reasonable, necessary, allocable, and allowable within funding limits
- Draw federal funds from G6 DOE grants management portal
Endowment analysis and spend reporting - percentage of time = 5%
Maintain quarterly endowment report on market and investment changes and annual spend allocationOversee university database used to project annual restricted spend allocation, calculations, notification to fund managersMaintain proper accounting for due to / due from unrestricted, temporarily restricted and permanently restricted fund accountsPartner with Advancement to reconcile endowment balances between Raiser's Edge and ERP systems and establish quarterly forecasts for new restricted and unrestricted endowmentsCreate internal models and analytical tools, aligned with university's investment partner and OCIO to monitor portfolio performanceProvide audit deliverables related to endowment funds timely and with precisionGrant accounting - percentage of time = 15%
Manage audit process for restricted government and endowed funds, including single audits, to ensure all deliverables and deadlines are metPrepare annual SEFA reportPrepare footnotes calculation and disclosures for endowmentsRecord journal entries to ensure proper accounting for restricted government and endowed funds and indirect costsReconcile restricted government and endowed balance sheet accounts to subsidiary systems, external statements and GLMaintain ERP chart of accounts for restricted government and endowed fundsMaintain self-service system for restricted government and endowed funds including creating roles and assign user accessRestricted Fund reporting - percentage of time = 15%
Prepare monthly actual financial reporting of revenue, expenses and available funding for all restricted funds including government grants, private grants and other awards and giftsPrepare periodic and final financial reporting for submission to donor agencies and support fund manager to compile information for agency inquiriesCommunicate financial data to stakeholders to develop effective forecasting and provide decision aidesRestricted Fund Administration - percentage of time = 20%
Monitor restricted account balances to ensure effective and timely utilization to alleviate financial pressures on operating resultsCollaborate with fund managers to plan and forecast spend ensuring donor mission is accomplished timely and effectivelyAnalyze negative restricted fund balances, correct errors and implement proper measures and controls to prevent spending in excess of available fundingServe as a resource on grant and gift administration, actively collaborating with restricted fund managers regarding inquiries on administrative, financial or programmatic issues for grant or gift activitiesAssist fund manager in preparation of financial components of proposals and review budgets for compliance and reasonableness of spend timelineCreate restricted fund accounts set-up in ERP systemServe as overall technical accounting resource to Controller and other university staffCalculate amount of indirect costs earned based upon grant spend, report actuals earned, used and forecast future indirect revenuesReview and approve expenditure requisitions and orders in E-Procurement system for compliance with donor restrictions and guidelines ensuring costs are reasonable, necessary, allocable, and allowable within funding limitsRestricted Fund accounting - percentage of time = 15%
Manage audit process for restricted funds in conjunction with the Accounting Manager to ensure all deliverables and deadlines are metPrepare footnotes calculation and disclosures for net assetsRecord journal entries to ensure proper accounting for restricted funds and indirect costsReconcile restricted balance sheet accounts to subsidiary systems, external statements and GLMaintain ERP chart of accounts for restricted fundsMaintain self-service system for restricted funds including creating roles, assign user access, and import fund budget annuallyReporting and Analysis - percentage of time = 5%
Perform requested ad-hoc analysis and kpi's using business intelligence software and data warehouse capabilities to improve business productivity, efficiency, and financial health
Ability to recognize the need and then create and design new reports or to drill deeper into a current static report to get enhanced details
Determine which data sources to utilize, appropriate data presentation, to provide customized analytics
MINIMUM EDUCATION LEVEL REQUIRED :
Bachelor's degree in accounting, finance or relevant field with preference given to candidates with Master's degreeMINIMUM RELATED EXPERIENCE REQUIRED :
5+ years progressive experience with nonprofit fund accounting, with preference given to candidates with higher education experience3+ years federal grant management and administrative experience preferredREQUIRED LICENSES / CERTIFICATIONS :
Preference given to CGMS - Certified Grants Management SpecialistSKILLS REQUIRED :
Advanced Excel analysis, modeling, consolidation, pivot, V-lookup, charting and related complex functionsExperience with ERP systems, data management, manipulation, and presentationKnowledge of federal and state funding regulations including Uniform GuidanceAbility to provide leadership within a cross-functional organization, solve complex issues, manage projects, deliver results and meet deadlines with high precisionEffective in a dynamic and collaborative environment in a positive and proactive mannerExhibit clear and concise communication effective in a hybrid work environment utilizing technology to ensure strong collaboration and timely, accurate and efficient transfer of informationCarlow University is Devoted to....
A culture of integrity, dignity and respect for allA strong commitment to social justiceEthical forward-thinking leadershipComprehensive medical, dental, vision, life & disability benefits packageTuition benefits for undergraduate and graduate programsHealth Savings Account and Flexible Spending Account optionsWellness and Employee Assistance ProgramComplimentary use of Carlow's fitness center and amenitiesCarlow University is a comprehensive Catholic University situated in a culturally rich and diverse urban setting of Pittsburgh, Pennsylvania. Founded in 1929 by the Sisters of Mercy, an international community of Roman Catholic women with a mission to serve the poor, the sick, and the uneducated. Carlow is an institution grounded in the liberal arts while also offering strong professional programs, committed to engaging its community in a process of life-long learning, scholarship, research, and service. Degrees are offered at the baccalaureate, master's, and doctoral levels. Carlow University aims to provide transformational educational opportunities rooted in social justice for a community of learners, and to empower them to excel in their chosen work as compassionate, responsible leaders in the creation of a just and merciful world.
Carlow University employees commit themselves to the highest standards of ethical conduct. They commit to act with integrity, treat others with respect and dignity, carefully steward the University's resources, avoid conflicts of interest or commitment, maintain confidentiality, and to comply with legal and professional obligations.
The intent of this job description is to provide a representative summary of the major duties and
responsibilities performed by incumbents of this job. Incumbents may be requested to perform job related tasks other than those specifically presented in this description. Duties, responsibilities, and activities may change at any time with or without notice.