Advertised Summary Job Description: The Senior Analyst reports to the Associate Director as part of the Data Analytics and Reporting group within Columbia University's Facilities and Operations (CUFO). CUFO comprises all operations and capital project management for both Morningside Campus Facilities, Manhattanville Campus Facilities, and Campus Services.
Interpreting and analyzing complicated large-scale data sets from disparate systems, the Senior Analyst will handle a wide array of projects related to data reporting, analytics, business intelligence, and process improvement. Most solutions utilize a combination of Excel, SQL, SSAS, and Power BI.
He/she will act as an in-house consultant on a wide array of projects across a suite of systems relating to workforce, purchasing, capital projects, effort reporting, and financial statements.
He/she will conduct data analyses, prepare financial information, and provide ad hoc reporting for a wide variety of internal clients.
Under the direction of the Associate Director, the Senior Analyst authors quality control tools to maintain the integrity and accuracy of data within procurement related systems, review procedures, and identify procedure compliance.
The Senior Analyst identifies operational, procedural, and organizational recommendations to deliver service improvements to clients and drive efficiency in reporting/analytics. Maintain a strong working knowledge of, and relationships with, stakeholders in multiple units of the University.
The Senior Analyst assists with the maintenance and development of compelling reports and dashboards to track financials, identify trends, monitor business operations, and identify performance predictors. The Senior Analyst performs research to identify best practices and benchmarking data at peer institutions and within the industry.
He/she will provide support to the Associate Director and team as necessary, such as report and presentation design and external representation. Performs other related duties as assigned.
General Minimum Qualifications: Bachelor's degree and/or equivalent, plus a minimum of 3 - 5 years related experience required.
Additional Specific Minimum Qualifications: Must possess strong technical skills, analytical skills, critical thinking and practical problem solving abilities. 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. Must possess discretion and be able to handle multiple concurrent projects.
Preferred Qualifications: SSAS experience a plus.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
Internal Number: 126_168594
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.