Financial Analyst

rfcuny; New York (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

Research Foundation of The City University of New York (RFCUNY) seeks a Financial Analyst to support the procurement lifecycle and ensure timely, accurate procurement and accounts payable transactions.

The role creates, reviews, and analyzes procurement data and reports, including complex analytics. It reports to the Manager of Procurement and Accounts Payable and requires strong finance knowledge and integrity.

Qualifications

• Bachelor's degree in Business Administration, Accounting, Finance, Data Science, Supply Chain Management, or related field, and 2+ years of relevant experience.

Responsibilities

• Analyze procurement and accounts payable data.
• Develop and execute complex regular and ad-hoc financial reports containing confidential data.
• Analyze financial transactions, workflows, and identify and troubleshoot issues.
• Perform trend analysis and forecasting.
• Perform detailed spend analytics by supplier, category, department, grant or funding source.
• Identify duplicate payments, duplicate suppliers, and pricing inconsistencies through analytical reviews
• Utilize RFCUNY's systems and available software (including but not limited to Excel) to generate relevant reports and metrics for end-users, suppliers, and internal use.
• Analyze historical purchases, payments, and records.
• Assist with year-end closing and reporting activities and audits.
• Perform other related duties as assigned.

Skills

Advanced Excel

Data analysis

Financial reporting

Procurement knowledge

Workday/Jaggaer

Education

Bachelor's degree in related field

Master's degree preferred

Tools

Power BI

Excel

Job description

Thank you for considering a career with the Research Foundation of The City University of New York (RFCUNY).

The team at RFCUNY is made up of dedicated, talented professionals committed to providing the services that allow CUNY researchers, faculty, and staff to focus on their intellectual curiosity and scientific discoveries.

We are pleased that you are interested in exploring opportunities to join RFCUNY.

Primary Location

RESEARCH FOUNDATION OF C.U.N.Y.

Bargaining Unit

No

Summary

The Financial Analyst position supports the procurement lifecycle and helps ensure timely, accurate procurement and accounts payable transactions. The incumbent creates, reviews, and analyzes procurement data and reports, including custom reports; analyzes procurement and accounts payable requests and transactions; and identifies and troubleshoots issues. The incumbent communicates with internal and external stakeholders and customers as needed. This position reports to the Manager of Procurement and Accounts Payable. The incumbent must be highly proficient in financial analysis and reporting, have a strong understanding of procurement and general accounting principles, exercise substantial independent judgment in fulfilling duties and responsibilities, demonstrate high personal integrity and ethical standards in handling financial transactions, and ensure compliance with all relevant regulations and policies. The incumbent must perform assigned tasks and projects in a timely and accurate manner and contribute to the organization's customer service excellence and overall financial performance. The ability to handle confidential data is required. The incumbent may supervise assigned temporary employees, student workers, or interns.

The Department processes approximately 75,000 transactions annually, representing approximately $200M in non-payroll accounts payable and procurement activity for sponsored programs of the City University of New York. The Department has 25 staff members.

DUTIES AND RESPONSIBILITIES

include, but are not limited to :

Financial Reporting and Data Analysis

• Analyze procurement and accounts payable data.
• Develop and execute complex regular and ad-hoc financial reports containing confidential data.
• Analyze financial transactions, workflows, and identify and troubleshoot issues.
• Perform trend analysis and forecasting.
• Perform detailed spend analytics by supplier, category, department, grant or funding source.
• Identify duplicate payments, duplicate suppliers, and pricing inconsistencies through analytical reviews
• Utilize RFCUNY's systems and available software (including but not limited to Excel) to generate relevant reports and metrics for end-users, suppliers, and internal use.
• Analyze historical purchases, payments, and records.
• Assist with year-end closing and reporting activities and audits.
• Perform other related duties as assigned.

Procurement Duties

• Analyze spend patterns and trends, and identify opportunities for savings and efficiency improvements
• Perform supplier setup, maintain supplier records and assist in supplier onboarding.
• Work with existing and prospective external suppliers, analyze pricing, and add suppliers and/or goods to procurement catalog.
• Provide administrative and analytical support for large procurement projects, Requests for Proposals (RFPs), Requests for Bid (RFBs).
• Ensure confidential handling of RFCUNY and supplier information.
• Review, verify, prepare, and process requests for procurement of goods and services, including purchase requisitions, purchase orders, procurement card transactions, expense reimbursements, supplier contracts, construction contracts, leases, and travel services, as assigned.
• Ensure compliance with the RFCUNY procurement policy and procedures; applicable federal and state regulations, policies, and procedures; and sponsor requirements.
• Consult and coordinate with internal departments including Grants & Contracts, Legal, and Finance, as well as CUNY offices, as needed.
• Research and respond to inquiries; troubleshoot and solve problems.

Qualifications

• Bachelor's degree in Business Administration, Accounting, Finance, Data Science, Supply Chain Management, or related field, and 2+ years of relevant experience.
• Master's degree preferred.
• Advanced proficiency in financial reporting and data analysis.
• Strong understanding of procurement and general accounting principles.
• Familiarity with ERP or procurement systems, such as Workday or Jaggaer, preferred.
• Competence in coding, advanced data analysis techniques, and Artificial Intelligence applications.
• Supplier relationship management and contract management experience preferred.

Skills

• Attention to detail and a high level of accuracy.
• Strong positive customer relationship skills
• Analytical and quantitative skills
• Expert level Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, etc.) required. Competence in other analytical software and tools (e.g. Power BI) preferred.
• Teamwork
• Customer focus
• Problem-solvin