Edtech.com's Summary

Columbia University is hiring a Senior BI Analyst to join the Data Analytics and Reporting group within Facilities and Operations. The Senior BI Analyst interprets and analyzes complex data sets, develops reports and dashboards, and provides data-driven recommendations to improve operational efficiency across campus facilities and services.

Highlights

Analyze large-scale, complex data from multiple systems using Excel, SQL, SSAS, and Power BI.
Serve as an internal consultant for workforce, purchasing, capital projects, and financial reporting.
Prepare financial analyses and ad hoc reports for internal clients.
Create quality control tools and monitor data integrity within procurement systems.
Identify and recommend improvements for operational processes and reporting efficiency.
Develop and maintain dashboards tracking financials and performance metrics.
Conduct research to benchmark best practices within higher education and industry.
Support management with report and presentation design and external communications.
Bachelor's degree or equivalent experience with 3-5 years in related analytics roles required.
Strong skills in Excel, Word, PowerPoint, SQL, data visualization tools, and effective communication essential.
Salary range: $100,000 - $110,000 per year.

Senior BI Analyst Full Description

Job Type: Officer of Administration
Regular/Temporary: Regular
Hours Per Week: 35
Salary Range: $100,000 - $110,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 Analyst reports to the Associate 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.

Responsibilities

Interpret and analyze complicated large-scale data sets from disparate systems. The Senior BI 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.
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.
Conduct data analyses, prepare financial information, and provide ad hoc reporting for a wide variety of internal clients.
Under the direction of the Associate Director, the Senior BI 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 BI Analyst identifies operational, procedural, and organizational recommendations to deliver service improvements to clients and drive efficiency in reporting/analytics. They maintain a strong working knowledge of, and relationships with, stakeholders in multiple units of the University.
The Senior BI 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 BI Analyst performs research to identify best practices and benchmarking data at peer institutions and within the industry.
Provide support to the Associate 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 its equivalent experience required. 3-5 years of related experience.
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, 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.
SSAS experience a plus.

Equal Opportunity Employer / Disability / Veteran

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

Original Job Description

Job Type: Officer of Administration
Regular/Temporary: Regular
Hours Per Week: 35
Salary Range: $100,000 - $110,000

Position Summary

Responsibilities

Interpret and analyze complicated large-scale data sets from disparate systems. The Senior BI 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.
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.
Conduct data analyses, prepare financial information, and provide ad hoc reporting for a wide variety of internal clients.
Under the direction of the Associate Director, the Senior BI 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 BI Analyst identifies operational, procedural, and organizational recommendations to deliver service improvements to clients and drive efficiency in reporting/analytics. They maintain a strong working knowledge of, and relationships with, stakeholders in multiple units of the University.
The Senior BI 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 BI Analyst performs research to identify best practices and benchmarking data at peer institutions and within the industry.
Provide support to the Associate 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 its equivalent experience required. 3-5 years of related experience.
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, 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.
SSAS experience a plus.

Equal Opportunity Employer / Disability / Veteran

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

Let me find your next job.

Thanks - you're signed up.

Senior BI Analyst

Edtech.com's Summary

Senior BI Analyst Full Description

Accounting Support Senior Specialist

Finance Director

Finance Analyst

Finance Director

Chief of Staff to the Senior Vice President for Financial Affairs and Treasurer