Financial Analyst

Columbia University Irving Medical Center; New York (NY); On-site; USD 70,000 - 75,000; Full time

Job summary

Columbia University Irving Medical Center is seeking a Financial Analyst to support the financial management of the Pediatrics department. This role involves processing journal entries, assisting with budget preparations, and managing accounts receivable.

The ideal candidate will have a Bachelor’s degree and at least three years of related experience, preferably in a higher education setting. Proficiency in Microsoft Excel and strong analytical skills are essential for success in this position.

Qualifications

• Bachelor's degree or equivalent in education and experience required.
• Three years of related experience required.
• Experience in higher education or other large, complex institutions is desirable.

Responsibilities

• Process journal entries for monthly, quarterly, and year-end close.
• Assist with all aspects of budget preparation and reconciliations.
• Manage and process the Pediatrics Department deposits from external sources.

Skills

Microsoft Excel

Analytical skills

Problem-solving skills

Interpersonal skills

Communication skills

Organizational skills

Education

Bachelor’s degree or equivalent

Tools

Accounting at Columbia (ARC) system

Job description

Grade 104

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $70,000-$75,000

Position Summary

Reporting to the Finance Managers, the Financial Analyst will support the financial management of the department. The position will work closely with the Pediatrics Finance team members and the Divisional Administrators. Responsible for supporting all financial reporting needs of the department.

Responsibilities

• Process journal entries for monthly, quarterly, and year-end close.
• Assist with all aspects of budget preparation; monthly NYPH transfers, service agreements, fellow’s charges and reconciliations.
• Assist with analyzing account balances, overdrafts, track payments and expenditures.
• Responsible for accurately tracking and managing accounts receivable for MSAs, NYPH Special funds, and other outside organizations.
• Monitors past due payments and work with outside organizations to collect and keep receipts current.
• Manage and process the Pediatrics Department deposits from external sources. Maintain the deposit database and ensure appropriate coding for COB reporting.
• Assist with monthly calculations and charge back of AIM-HI, FPO, and departmental assessments and funds flow.
• Assist with annual budget submission by updating and creating Divisional templates and submission to the budget tool.
• Responsible for the creation and maintenance of chartfields for accurate accounting of expenses and revenue.
• Works with the Pediatrics Finance managers and the CUIMC controller's office to prepare quarterly/annual accruals for more accurate and time-sensitive reporting.
• Assist with PAC payroll salary distributions and cost transfers under the direction of the Senior Payroll manager and Director.
• Perform other related duties and responsibilities as assigned/requested.

Minimum Qualifications

• Bachelor’s degree or equivalent in education and experience required; plus three years of related experience.

Other Requirements

• Employment is contingent upon successful completion of pre-offer and post-offer background checks in accordance with NYC’s Fair Chance Act. Depending on the position, a drug screening and other verifications may be required. (University Policies)
• Must successfully complete applicable compliance and systems training requirements.
• HIPAA Privacy and Security Essentials Training

Preferred Qualifications

• Experience in higher education or other large, complex institutions is desirable. Familiarity with Columbia financial systems, particularly the Accounting at Columbia (ARC) system, is also highly desirable, along with experience with running financial reports for project reconciliation, and budgeting in the University Budget Tool.
• Must have excellent interpersonal, communication, and organizational skills. Advanced knowledge of Microsoft Excel. Strong attention to detail and accuracy. Analytical and problem-solving skills.

Equal Opportunity Employer / Disability / Veteran