Senior Business Intelligence Analyst
-
Finance and Administration
- Job Type: Officer of Administration
- Bargaining Unit:
- Regular/Temporary: Regular
- End Date if Temporary:
- Hours Per Week: 35
- Standard Work Schedule:
- Building:
- Salary Range: $105,000 - $115,000
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.
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, Power BI, and Microsoft Fabric, increasingly enhanced by AI tools such as Copilot and Data Agents.
The Senior Business Intelligence Analyst acts 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. The Senior Analyst conducts data analyses, prepares financial information, and provides ad hoc reporting for a wide variety of internal clients.
Responsibilities
- Collects data and prepares reports from numerous University and departmental systems via front-end interfaces, reporting sites, and (most commonly) custom SQL queries against the CUFO data warehouse. Communicates with Procurement stakeholders regarding data feeds, systems, and reporting. Identifies operational, procedural, and organizational recommendations to deliver service improvements to clients
- Designs and deploys Power BI solutions through SSAS Tabular Model design or any other data model that is suitable for purpose. Is conjunction with Director, works with CUFO liaisons to determine their Business Intelligence needs, define KPIs and measures, and test Power BI reports and dashboard before deployment
- Leverages existing report paradigms against new areas of reporting interest. At stakeholders' request, assists in reviewing, identifying, and streamlining business workflows. Researches data trends against existing CUFO history and comparable institution benchmarks
- Independently evaluates complex operational, financial, procurement, and workforce data to identify significant trends, operational risks, procedural deficiencies, and opportunities for improvement. Provides consultation and expert analytical recommendations to the Director and other University stakeholders to support management decisions and improve the effectiveness of CUFO operations
- Evaluates existing operational procedures, reporting practices, internal controls, and data governance processes across assigned functional areas. Identifies opportunities to improve operating practices, develops recommendations for procedural changes, and advises management on the potential operational, financial, and organizational implications of proposed improvements. Supports the development and implementation of approved changes
- Leads assigned business intelligence and analytical initiatives supporting significant CUFO operational functions. Independently determines appropriate analytical approaches, evaluates alternative solutions, identifies issues requiring management attention, and develops recommendations to address operational challenges. Assesses the potential impact of findings and recommendations on procurement, financial reporting, workforce management, capital project operations, and other University business functions
- Designs quality control and data integrity tools to proactively improve efficiency and accuracy within multiple CUFO systems including ARC, Maximo, and Unifier. Works with client managers to identify areas of improvement for data entry teams and provides feedback on interaction between systems and users. Confirms report integrity, data warehouse accuracy, and success of quality control initiatives
- Performs related duties and responsibilities as assigned/requested
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
- 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 exposure to data visualization tools (PowerBI, Tableau, ect) desired
- SSAS, Microsoft Fabric, Copilot, and AI Data Agents experience a plus
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.