Job Location : New York,NY, USA
Position Summary
Reporting to the Director for Financial Services, the Senior Financial Analyst will facilitate the monitoring, analysis and reporting of the financial activity related to the utility budget. S/He will be accountable in maintaining the accuracy and integrity of the Facilities and Operations' web-based tracking software Energy Management System “Energy CAP”.
Responsibilities
Responsible for updating data warehouse SQL related spreadsheets to ensure 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.
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 activity. 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.
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 of internal financial policies, programs, and practices.
Lead in preparing complex and intricate carbon emissions reports and analysis 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 to Federal, State and Local Laws.
Minimum Qualifications
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
#J-18808-Ljbffr