The Vagelos College of Physicians and Surgeons (VP&S) Development office (OOD), a part of the Columbia University Irving Medical Center (CUIMC), is dedicated to facilitating relationships that support the vision and mission of CUIMC and VP&S: to advance medical education, achieve scientific breakthroughs, and provide the best possible patient care across a range of specialized departments, centers and programs.
The Business Intelligence (BI) Reporting Analyst will work in a small reporting team and will be responsible for developing dashboard and reporting solutions, that will sometimes require the build out of new data structures and models to achieve performance characteristics, and assist in training department staff in knowledge and use of data reporting tools. The incumbent will work directly with Gift Officers, and other members of the fundraising team, to review reporting priorities, manage and coordinate reporting projects, and streamline delivery of reporting of fundraising data.
The BI Reporting Analyst will require strong interpersonal and analytical skills and a desire to solve user requests and be technically proficient in using Microsoft Reporting Services (SSRS), Excel, and PowerPoint, PL/SQL and T-SQL to write Oracle and SQL Server database queries. Also, the incumbent will conduct analysis into reported errors found in department reports by finding and documenting the root cause(s), and proposing appropriate actions and solutions to mitigate bugs.
Furthermore, the BI Reporting Analyst will work with the OOD staff and the CUIMC IT department to maintain the OOD SharePoint (Online) site and oversee its design, simplifying staff needs to find and consume relevant content in SharePoint easily while leveraging best practices as needed. To that effect, the incumbent will serve as the department's primary support contact for SharePoint.
Create, maintain, and distribute reports and dashboards for department, provide user support and training, and document business requirements and objectives - 70%
Manage and coordinate department reporting projects, and ensure that standard project management documentation is developed and maintained - 20%
Maintain the OOD SharePoint site, oversee its design, organize its contents, and provide necessary training to OOD staff - 10%
Requires a bachelor's degree or equivalent in education and experience, plus three years of related experience.
Experience with and proficiency of SQL Server Analysis Services (SSAS), PowerBI, and Microsoft Project.
Excellent interpersonal, written and oral communication, and creative problem-solving skills
Highly self-motivated and directed and adept at working in a team environment
Proven experience with report writing and technical requirements analysis, methodology development, and proficiency with Microsoft SQL Server Reporting Services (SSRS), Oracle PL/SQL, Microsoft T-SQL, and Microsoft SharePoint, Excel, Word, and PowerPoint
Have experience managing reporting projects, with first hand report development, and data manipulation using Excel
Communicates incidents/problems, reporting changes, enhancements, and modifications to appropriate parties in a timely manner, with strong customer service skills
Monitors and optimizes the reporting environment to ensure it operates smoothly without issues automating any manual tasks
Builds strong relationships with fellow technology team members, pro-actively sharing relevant information, and improvement ideas to benefit the whole team
Have experience in thoroughly documenting business requirements, and objectives, and maintaining project documentation
Proven ability to adjust quickly to shifting priorities, multiple demands and rapid change
The incumbent must demonstrate sound judgment and discretion in handling confidential matters
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 502695
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.