Business Intelligence Analyst

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Salary Range: $70,650 - $88,950

Position Summary

The Business Intelligence Analyst reports to the Senior Business Intelligence Analyst as part of the Data Analytics and Reporting group within Columbia University's Facilities and Operations (CUFO), which handles a wide array of projects related to data reporting, analytics, and process improvement. 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 Business Intelligence Analyst provides reporting and analysis to CUFO stakeholders and acts as an in-house consultant on a wide array of projects. They conduct data analyses, prepares financial information, and provides ad hoc reporting for a wide variety of internal clients. The Business Intelligence Analyst assists in developing a new suite of financial and operational reports.

Under the direction of the Senior Business Intelligence Analyst, the Business Intelligence Analyst authors quality control tools to maintain the integrity and accuracy of data, review procedures, and identify appropriate workflow processes. The Business Intelligence Analyst identifies operational, procedural, and organizational recommendations to deliver service improvements to clients and drive efficiency in reporting/analytics. The Business Intelligence Analyst maintains a strong working knowledge of and relationships with stakeholders in multiple departments. The Business Intelligence Analyst assists with the maintenance and development of compelling reports and dashboards to track financials, identify trends, monitor business operations, and be used as future predictors.

The Business Intelligence Analyst performs research to identify best practices and benchmarking data at peer institutions and industry.
The Business Intelligence Analyst provides support to the Senior Business Intelligence Analyst and team as necessary, such as report and presentation design and external representation. Performs other related duties as assigned

Minimum Qualifications

• Bachelor's degree and/or its equivalent, plus a minimum of 2-4 years related experience required.     
• 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.
• Exposure to data visualization tools (PowerBI, Tableau, etc.) 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

• Experience with SQL and SSAS desired

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.