Sponsored Projects Accountant Position Available In Allegheny, Pennsylvania

Sponsored Projects Accountant Carlow University

• 4.

5

Pittsburgh, PA Job Details Estimated:

$63.1K

• $77.

4K a year 21 hours ago Benefits Health savings account Health insurance Dental insurance Flexible spending account Tuition reimbursement Employee assistance program Vision insurance Qualifications Microsoft Excel Raiser’s Edge 5 years ERP systems Finance Master’s degree Administrative experience Analysis skills Bachelor’s degree Data management Accounting Senior level Leadership Accounting Data manipulation Full Job Description 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 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 Raiser’s Edge and ERP systems and establish quarterly forecasts for new restricted and unrestricted endowments Create internal models and analytical tools, aligned with university’s 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 self-service 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 set-up 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 E-Procurement 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 self-service system for restricted funds including creating roles, assign user access, and import fund budget annually Reporting 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 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, V-lookup, 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 cross-functional 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 forward-thinking 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 Carlow’s 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 Carlow’s commitment to equity, inclusion, and community; and be able to articulate how they will contribute to Carlow University’s 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 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 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 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.