The Data Analyst reports to the Financial Manager as part of the Capital Finance group within Columbia University's Facilities and Operations (CUFO), which handles a wide array of tasks related to the reporting and controls for all capital projects. The Analyst utilizes excel, SQL and data visualization tools (PowerBI, Tableau, ect...) to interpret and analyze complicated large-scale data sets from disparate systems and provide reporting and analysis to CUFO stakeholders. They conduct data analyses, prepare financial information, and provides ad hoc reporting for all capital projects. The Analyst works closely with CUFO staff to maintain project information for accurate reporting, including the maintenance and development of compelling reports and dashboards to track financials, identify trends, monitor business operations, and be used as future predictors. The Analyst performs research to identify best practices and benchmarking data at peer institutions and industry. The Analyst assists with identifying and implementing data integrity improvements among the various systems.
Under the direction of the Financial Manager the Analyst creates cash flow models to generate expense projections for reporting to the Office of Management and Budget for all capital projects. The Analyst provides support to the Financial Manager and team as necessary, such as report and presentation design and external representation.
Additional responsibilities will include:
Work independently with project managers to close out capital projects from a financial perspective
Assist with the tracking of all client funded capital project funding authorization documents
Reconciliation of capital expenses to ensure data integrity
Assist the creation and assignment of all client funded capital projects
Report the break down by component by project to management for depreciation purposes
Assist with updating financial reports on an on-going and ad-hoc basis as requested by management
Provide final approval of financial transactions
Perform related duties & responsibilities as assigned
Bachelor's degree, plus a minimum of 2-4 years related experience required including experience or major in finance, budgeting and/or accounting with advanced Excel and statistical analysis skills.
Excellent communication, writing, presentation, quantitative, and interpersonal skills required. Advanced knowledge of Excel, Word, Windows, Visio, PowerPoint and data applications required.
Experience with SQL and exposure to data visualization tools (PowerBI, Tableau, ect) desired.
Strong research skills needed.
Ability to work as a member of a collaborative team while exercising independent judgment is essential.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 505923
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.