Advertised Summary Job Description: Reporting to the Director, Marketing, for Columbia College Development and with oversight from the Deputy Director of Data Science in the Office of Alumni and Development, the Associate Director, Data Science provides routine and ad hoc reports and data analyses for all units within Columbia College's Office of Alumni Affairs and Development (CCAAD). The Associate Director develops models and reports to support short- and long-term planning, including giving trend analyses, and the ongoing work of the development and alumni relations teams. The Associate Director monitors data accuracy in the University's alumni databases, proposes, implements improvements and modifications to facilitate accurate reporting on College donor populations. The incumbent gathers and formats data for the Columbia College Annual Report and for all stewardship activities for College donors.
-Data and reporting: Create ad-hoc reports for CCAAD staff using PL/SQL Developer and Microsoft SSRS. Work with leadership to develop reports to support the fundraising and alumni relations efforts of CCAAD. Manage and maintain multiple data-driven processes and applications; including segmentation, mailing file data, and data integrity. Use experience and skill to approach work with large data sets strategically. Understand gift sources to effectively perform analysis, assessment, and reporting.
-Strategic Reporting/Modeling and analysis: Develop models and reports to support short- and long-term planning, including giving trend analyses, ROI and cost-benefit analysis of direct marketing projects, and the identification of new donors and/or those with increased giving potential.
-Data integrity: Monitor data in University's alumni databases to ensure accurate reporting. Partner with the Office of Alumni and Development's Reporting team to identify and implement strategies to continually update alumni data.
-System/database documentation: Write and maintain documentation for SQL reports (table/field description, data map, template director, business rules, etc.) Prepare documentation on criteria used to generate data for the College Annual Report.
General Minimum Qualifications: Bachelor's degree and/or it's equivalent required. Three (3) to five (5) years of work experience is required, with a minimum of two (2) years of work related to data analysis.
Additional Specific Minimum Qualifications: -Demonstrated proficiency in SQL is required, preferably in an Oracle (PL/SQL) environment.
-Proficiency in one or more of the following data analysis applications (R, SPSS, SAS, Python, MATLAB) and/or business intelligence and data visualization platforms (Microsoft SSRS, MS Power BI, Tableau).
-Proficiency with the Microsoft Office Suite (advanced Excel) and other common computer applications required
-Excellent oral and interpersonal skills and strong project management and problem-solving skills.
-Ability to work both independently and as part of a team in a demanding environment.
-This position requires strong attention to detail and the ability to maintain confidentiality and handle sensitive information. Strong customer service skills and an exemplary attitude are required.
-The successful candidate must be a strategic thinker, effective in moving strategic agendas, politically savvy, flexible in nature, and have a sound judgment with a collaborative style that fosters teamwork and cooperation beyond the immediate team to the broader organization. Must have a passion for excellent customer service, commitment to exceptional quality, and an ability to inspire colleagues toward accomplishing common objectives and goals.
**Applications must be submitted with a resume and cover letter to be considered**
Preferred Qualifications: -Substantial coursework in Statistics, Computer Science, Data Science, -Economics, Business, or a related discipline strongly preferred.
-Familiarity with fundraising database applications highly desirable.
-Knowledge of fundraising CRMs and back-end data structures highly desirable.
-Knowledge of common practices in the fields of fundraising, alumni relations, development, and prospect development preferred.
-Ability to conceptualize and develop proactive prospecting methodologies to support organizational goals, including data mining, sophisticated constituent database queries, etc. preferred.
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.
Internal Number: 126_174650
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.