Columbia University Facilities & Operations · 5 days ago

Senior Financial Analyst

New York, NY

Full-time

Onsite

Senior Level

$85K/yr - $98K/yr

4+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Higher Education

Insider Connection @Columbia University Facilities & Operations

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

The Sr. Financial Analyst is responsible for updating data warehouse SQL-related spreadsheets to ensure the accuracy of all financial reports. Generate complex SQL queries and scripts to transform and aggregate data. Utilizing a wide array of University and departmental systems, the Senior Financial Analyst gathers data, prepares reports, and performs proactive audits to identify discrepancies and variances.

In collaboration with senior management in Facilities & Operations and other University departments, the Sr. Financial Analyst will resolve inconsistencies pass on updates, and rectify processing issues.

The Senior Financial Analyst maintains the accuracy of various financial analyses and reports used to forecast building utility usage and rates, staff payroll, service contract expenses, and other financial activities. They will process standard and other recurrent financial transactions in accordance with University and departmental accounting standards and procedures, develop and review incremental utility expenses based on proposed capital projects using benchmarking data.

The Senior Financial Analyst works independently on research projects and is responsible for completing reconciliations and reports to meet departmental and University finance deadlines, including those associated with monthly, quarterly, and fiscal year-end close.

Develop and provide reports as required and assist in the implementation and of internal financial policies, programs, and practices.

The Senior Analyst will take the lead in preparing complex and intricate carbon emissions reports and analyses to ensure compliance with the University’s commitments i.e. NYC Mayor’s Carbon Challenge & The Climate Registry. Utilize web-based tracking software “Energy CAP” for benchmarking and reporting of energy data as necessary or required for compliance with Federal, State, and Local Laws.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

AccountingBudgetingSQLData MiningExcelProblem-SolvingCommunicationOrganizationalAdvanced Degree

Required

Bachelor’s Degree required

Minimum of 4-6 years of accounting/reporting/budgeting experience is required

Strong technical skills including familiarity with SQL queries and other data mining methods, extensive reporting and data analysis experience, and advanced Excel proficiency

Ability to work independently and manage multiple tasks while meeting tight deadlines is necessary

Excellent analytical, communication, and organizational skills are essential