Campus Pride Jobs

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

Position Summary

Reporting to the Senior Strategic Initiatives Manager, the Senior Budget Analyst's primary responsibility is to manage ICAP's consolidated operating budget process and annual 990 filing. The consolidated operating budget process includes the annual budget submission as well as quarterly updates and variance analysis. The Sr Budget Analyst will manage ICAP's consolidated budget revenue and expense projections including direct responsibility for submission of ICAP's budget projections to and collaborations with MSPH, Columbia University Irving Medical Center (CUIMC), and Columbia University (CU). The Sr Budget Analyst will provide analytic support and be a problem solver. S/he will utilize thorough knowledge of Columbia University's financial systems, reports, and tools to produce in-depth analysis of programs and services.

The position is contingent upon grant funding.

Subject to business needs, we may support flexible and hybrid work arrangements. Options will be discussed during the interview process.

Responsibilities

Consolidated Operating Budget (70%)

• Work with all ICAP NY departments and ICAP country offices to gather and analyze budget data, including programmatic activity data, at project/program, country, and ICAP NY levels. Prepare and submit ICAP's consolidated operating budget (COB) figures and analyses for ICAP, MSPH, CUIMC senior leadership's review.
• Work closely with ICAP Strategy and Partnerships and country office teams to compile and analyze data on grant proposals and new awards.
• Ensure that projects and unrestricted funds COB figures and information are continually updated.
• Participate actively in monthly pipeline review and award meetings. Provide relevant budget data, analyses, forecast adjustment recommendations to country offices and ICAP NY teams, and follow up on their implementation.
• Advise and assist in the development unrestricted funds budgets
• Manage budget tool uploads. Ensure annual and quarterly budget tool updates and adjustments are accurate and submitted on time.
• Identify financial trends and potential areas of opportunity/risk.

Annual 990 Filing (15%)

• Prepare and submit the annual 990 filing

Other Operations and Project Management Support (10%)

• Assist in coordination of various audit and compliance review responses
• Provides project management support as needed for the initiation and implementation of ICAP Finance projects

Other (5%)

Performs other duties as assigned

Minimum Qualifications

• Bachelor's degree in business management, Finance, Accounting, or Computer Information Systems or related fields or equivalent in education, training and/or experince.
• 4 years of experience in budgeting and financial analysis
• Demonstrated experience analyzing financial data and presenting findings, trends, and recommendations
• Excellent interpersonal and communication skills with demonstrated experience operating in highly complex business environments involving matrixed relationships. Demonstrated experience in interacting with and effectively dealing directly with members of senior management
• Demonstrated knowledge of US Government (USG) regulations that govern the financial management of USG grants and contracts and generally accepted accounting principles (GAAP)
• Strong, proven advanced Excel skills, including, but not limited to, development of pivot tables, complex formulas, macros, and imports and exports from and to various data sources/management tools
• Demonstrated acute attention to detail, critical thinking, and good judgment
• Proven ability to manage time sensitive projects and meet critical deadlines, strong organizational skills and ability to work independently

Preferred Qualifications

• Master's Degree in Business Management, Finance, Accounting, or Computer Information Systems or related fields
• Minimum of 5 years of experience in budgeting and financial analysis
• Experience working with Power BI
• Experience working with Smartsheet
• Demonstrated experience working with international protocols, non-profit organizations, or academic institutions
• Knowledge of Columbia University accounting and financial systems
• Fluency in any of the following languages would be a plus: French, Portuguese, Spanish, and Russian

Other Requirements

• International travel of 1-2 trips per year may be required