Senior Business Intelligence Analyst
- Requisition no: 535278
- Work type: Full Time
- Location: Morningside
- School/Department: Finance and Administration
- Grade: Grade 12
- Categories: Facilities/Maint/Trades/RealEs, Other
- Job Type: Officer of Administration
- Bargaining Unit:
- Regular/Temporary: Regular
- End Date if Temporary:
- Hours Per Week: 35
- Salary Range: $75,950 - $99,600
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 Senior Business Intelligence Analyst reports to the 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 Business Intelligence 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.
Responsibilities
- 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 Director, the Senior Business Intelligence 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 Business Intelligence 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 Business Intelligence 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 Business Intelligence Analyst performs research to identify best practices and benchmarking data at peer institutions and within the industry.
- He/she will provide support to the Director 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 equivalent, plus a minimum of 3 - 5 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.
- 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
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.