Reporting to the Associate Director of Business Processes Management, the Senior Analyst is responsible for the data collection process, data integrity, accuracy, and reporting analytics for the Columbia University Facilities and Operations (CUF&O) Minority, Woman and Local (MWL) program related to the Manhattanville Campus construction projects and other CUFO spending.
He/She is responsible for reviewing all MWL reports and analyzing the results for consistency and completeness.
He/She monitors compliance with the University's Manhattanville MWL reporting commitments with New York State.
Working largely independently on a day-to-day basis, the Senior Analyst supervises one Analyst and will work closely with the Associate Director to review, revise, and develop required MWL reporting procedures and workflow processes to maintain the integrity and accuracy of MWL data.
The Senior Analyst works closely with the Construction Business Services and Communications group and interfaces with construction managers, contractors, and CUF&O project managers on matters related to MWL data gathering and reporting.
He/She will train CUF&O project managers and contractors on MWL reporting policies and procedures.
The Senior Analyst is responsible for the design and implementation of improvements to existing MWL related systems and reporting, as well as playing a key role in the design development of new databases and reporting platforms.
In addition to MWL duties, the Senior Analyst provides other forms of support to the Associate Director as necessary.
This includes collection of data and reporting from numerous University and departmental systems via front-end interfaces, reporting sites, and custom SQL queries against the CUF&O data warehouse, communications with managers and vendors, and interaction with other University departments regarding data feeds, systems, and reporting.
The Senior Analyst performs related duties and responsibilities as assigned.
Bachelor's degree and/or its equivalent required.
Must have a minimum of 3-5 years of relevant experience.
Must possess strong organizational skills, critical thinking, and practical problem-solving abilities.
Outstanding Excel skills are absolutely necessary; experience creating, organizing and presenting data in Excel is essential.
Excellent communication, written, presentation, quantitative and interpersonal skills required.
Computer technology skills required.
Knowledge of Windows, Excel, Word, PowerPoint and database applications required.
Ability to work as a member of a collaborative team while exercising independent judgment and initiative is essential.
Must possess discretion and be able to handle multiple concurrent assignments.
Experience with large reporting datasets and/or construction projects preferred.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 499469
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.