Business Intelligence Analyst
- Requisition no: 534616
- Work type: Full Time
- Location: Morningside
- School/Department: Finance and Administration
- Grade: Grade 11
- Categories: Facilities/Maint/Trades/RealEs
- Job Type: Officer of Administration
- Bargaining Unit:
- Regular/Temporary: Regular
- End Date if Temporary:
- Hours Per Week: 35
- Salary Range: $70,650 - $88,950
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
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.