Carlow University is now accepting applications for our Sponsored Projects Accountantposition. The Sponsored Projects Accountant reporting to the University Controller has responsibilitiesincluding 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 adhoc statistical analysis. This role is lead accountant for restricted funding and related audit processes. The position will assist withfinancialplanning and budgeting processes analyzingcomplex financialstatements and reports preparing projections and performing research andanalysisas 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 setup in ERP system and monitor costsharing 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 EProcurement 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 allocation
- Oversee university database used to project annual restricted spend allocation calculations notification to fund managers
- Maintain proper accounting for due to/due from unrestricted temporarily restricted and permanently restricted fund accounts
- Partner with Advancement to reconcile endowment balances between Raisers Edge and ERP systems and establish quarterly forecasts for new restricted and unrestricted endowments
- Create internal models and analytical tools aligned with universitys investment partner and OCIO to monitor portfolio performance
- Provide audit deliverables related to endowment funds timely and with precision
Grant accounting percentage of time 15 - Manage audit process for restricted government and endowed funds including single audits to ensure all deliverables and deadlines are met
- Prepare annual SEFA report
- Prepare footnotes calculation and disclosures for endowments
- Record journal entries to ensure proper accounting for restricted government and endowed funds and indirect costs
- Reconcile restricted government and endowed balance sheet accounts to subsidiary systems external statements and GL
- Maintain ERP chart of accounts for restricted government and endowed funds
- Maintain selfservice system for restricted government and endowed funds including creating roles and assign user access
Restricted 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 gifts
- Prepare periodic and final financial reporting for submission to donor agencies and support fund manager to compile information for agency inquiries
- Communicate financial data to stakeholders to develop effective forecasting and provide decision aides
Restricted Fund Administration percentage of time 20 - Monitor restricted account balances to ensure effective and timely utilization to alleviate financial pressures on operating results
- Collaborate with fund managers to plan and forecast spend ensuring donor mission is accomplished timely and effectively
- Analyze negative restricted fund balances correct errors and implement proper measures and controls to prevent spending in excess of available funding
- Serve 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 activities
- Assist fund manager in preparation of financial components of proposals and review budgets for compliance and reasonableness of spend timeline
- Create restricted fund accounts setup in ERP system
- 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 EProcurement system for compliance with donor restrictions and guidelines ensuring costs are reasonable necessary allocable and allowable within funding limits
Restricted 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 met
- Prepare footnotes calculation and disclosures for net assets
- Record journal entries to ensure proper accounting for restricted funds and indirect costs
- Reconcile restricted balance sheet accounts to subsidiary systems external statements and GL
- Maintain ERP chart of accounts for restricted funds
- Maintain selfservice system for restricted funds including creating roles assign user access and import fund budget annually
Reporting and Analysis percentage of time 5
Perform requested adhoc analysis and kpisusing 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: - Bachelors degree in accounting finance or relevant field with preference given to candidates with Masters degree
MINIMUM RELATED EXPERIENCE REQUIRED: - 5 years progressive experience with nonprofit fund accounting with preference given to candidates with higher education experience
- 3 years federal grant management and administrative experience preferred
REQUIRED LICENSES/CERTIFICATIONS: - Preference given to CGMS Certified Grants Management Specialist
SKILLS REQUIRED:
- Advanced Excel analysis modeling consolidation pivot Vlookup charting and related complex functions
- Experience with ERP systems data management manipulation and presentation
- Knowledge of federal and state funding regulations including Uniform Guidance
- Ability to provide leadership within a crossfunctional organization solve complex issues manage projects deliver results and meet deadlines with high precision
- Effective in a dynamic and collaborative environment in a positive and proactive manner
- Exhibit clear and concise communication effective in a hybrid work environment utilizing technology to ensure strong collaboration and timely accurate and efficient transfer of information
Carlow University is Devoted to.... - A culture of integrity dignity and respect for all
- A strong commitment to social justice
- Ethical forwardthinking leadership
- Comprehensive medical dental vision life & disability benefits package
- Tuition benefits for undergraduate and graduate programs
- Health Savings Account and Flexible Spending Account options
- Wellness and Employee Assistance Program
- Complimentary use of Carlows fitness center and amenities
Successful candidates must be committed to envisioning the future of liberal arts and professional education in a rapidly changing environment; have experience working with diverse populations; actively support Carlows commitment to equity inclusion and community; and be able to articulate how they will contribute to Carlow Universitys Catholic Mercy mission and values through their teaching scholarship and service. Carlow 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 diverse community in a process of lifelong learning scholarship research and service. Degrees are offered at the baccalaureate masters and doctoral levels. Carlow University aims to provide transformational educational opportunities rooted in social justice for a diverse 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 Universitys 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.
|