Senior Business Intelligence Analyst

4 days ago

Morningside, Canada Job Details Full time $75,950 - $999,600 per year
  • 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

  • SSAS experience a plus

Equal Opportunity Employer / Disability / Veteran

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

  • Business Intelligence Analyst

    4 days ago

    Morningside, Canada Job Details Full time $70,650 - $88,950 per year

    Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: RegularEnd Date if Temporary:Hours Per Week: 35Salary 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...

  • Financial Analyst, Budget and Planning

    4 days ago

    Morningside, Canada Job Details Full time US$61,500 - US$73,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Salary Range: $61,500 - $73,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...

  • Senior Associate Provost for Institutional Research

    2 weeks ago

    Morningside, Canada Job Details Full time US$180,000 - US$220,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Building: Low LibrarySalary Range: $180,000-$220,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...

  • Deputy Senior Director of Research

    1 week ago

    Morningside, Canada Job Details Full time US$170,000 - US$200,000 per year

    Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: RegularEnd Date if Temporary:Hours Per Week: 35Salary Range: $170,000-$200,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...

  • Senior Associate Athletics Director/ Chief Financial Officer

    1 week ago

    Morningside, Canada Job Details Full time US$130,000 - US$160,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Standard Work Schedule: M-F (may vary pending need)Salary Range: $130,000-$160,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,...

  • Project Coordinator

    1 week ago

    Morningside, Canada Job Details Full time US$60,000 - US$120,000 per year

    Position SummaryReporting to the Senior Associate Provost for Academic Programs, the Project Coordinator will assist  the Vice Provost in the Office of the Vice Provost for Academic Programs (OVPAP) in managing the day-to-day and overall operations, project management, and data analysis for OVPAP initiatives. Responsibilities include, but are not limited...

  • Variable Hours Officer-Special Assistant

    2 weeks ago

    Morningside, Canada Job Details Full time US$60,000 per year

    Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: TemporaryEnd Date if Temporary:Hours Per Week: 20Standard Work Schedule:Building:Salary Range: $60 - $60 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,...

  • Senior Associate Director of Administration and Planning

    2 weeks ago

    Morningside, Canada Job Details Full time US$66,000 - US$85,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Salary Range: $66,000 - $85,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...

  • Director, Data Management

    1 week ago

    Morningside, Canada Job Details Full time US$110,000 - US$130,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Building: Low LibrarySalary Range: $110,000-$130,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...

  • Director, Direct Services

    4 days ago

    Morningside, Canada Job Details Full time $98,000 - $125,000 per year

    Job Type: Officer of AdministrationRegular/Temporary: RegularHours Per Week: 35Salary Range: $98,000 - $125,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...