Advertised Summary Job Description: The Director of Business Intelligence, Analysis and Reporting will lead the Office of Development (OOD) data management functions including leadership of the department's BI/Database Team. This professional will work closely with the Development, Alumni Relations, Special Events and Stewardship teams to support their fundraising, relationship development, events, board engagement and related work. The incumbent will be responsible for analyzing, reporting and developing recommendations on data and information related to the department's fundraising goals. They will also be integrally involved in the management of automated data flow, analysis and recommendations of HIPAA compliant Grateful Patient data.
Specific responsibilities include the production of ad hoc reports from the Grateful Patient database and Advance for internal and external constituents; the ability to analyze, evaluate, and prioritize original report specifications received from development and alumni relations staff throughout Columbia University Medical Center, create and execute original PL/SQL code, Crystal Reports and Tableau for queries against the Grateful Patient and Advance fundraising databases. The Director of Business Intelligence, Analysis and Reporting will be required to program with PL/SQL Developer in an integrated development environment for developing, testing, debugging and optimizing Oracle PL/SQL queries.
The Director will also manage the department's Research Analyst including the Analyst's updates, creation and maintenance of educational materials for department use.
Additional responsibilities include some training of Development staff on the operation of the interface for the fundraising databases and assisting the Directors of Development in managing portfolios and programs by developing custom reports as needed.
General Minimum Qualifications: Requires a bachelor's degree or equivalent in education and experience, plus four years of related experience.
Additional Specific Minimum Qualifications: Minimum Qualifications: - Requires a Bachelor's degree in Business Intelligence, Health Information Technology, Mathematics, Computer Science, Statistics, or related areas. Master's degree strongly preferred. - Four years of related work experience with seven years or more in fundraising and higher education. Healthcare experience strongly preferred. - Experience managing analysts and programmers with the ability to recruit, employ, train, supervise and evaluate staff an staff. - Advance knowledge of Microsoft Office Suite of Products (Word, Excel, PowerPoint, Outlook, and SharePoint). - Proficient in Oracle-based PL/ SQL inquiries and programming, and some proficiency with creating scripts for Microsoft Office. - Excellent interpersonal skills, written and oral communications and organization skills necessary, with the ability to work effectively with a wide range of constituencies in a diverse community. - Must work well independently and as a member of the team. - Ability to set priorities and work in a fast paced environment, maintain professionalism and high level of confidentiality. - Skilled in handling multiple deadline driven assignments with the ability to initiate, supervise and complete projects and assignments with minimal supervision.
Preferred Qualifications: Preferred Qualification: - Experience with Advance. - Knowledge of data visualizations tools (Tableau and Qlik). - Exposure to Informatica Power Center (ETL Tool). - Experience with statistical software (SAS and SPSS). - Proficient in Crystal Reports 10. - Knowledge of SharePoint
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
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.