Advertised Summary Job Description: The School of General Studies (GS) is seeking an individual to join their team. Reporting to the Executive Director of Operations and Information Systems, overseeing the Assistant Director of Planning and Analytics, and working collaboratively with other members of the School, the Associate Director will support the strategic goals of the School of General Studies through quantitative analysis & research. The Associate Director will lead the analytical function for the school by providing substantive analysis of complex information to support key enrollment objectives and goals; meet with deans and directors to discuss their data needs; synthesize data for presentation to deans and directors to facilitate decision-making; develop and produce reports, graphics, statistical analyses and concise narratives.
Serve as the data steward for the school by assisting with decisions regarding the design, adaptation and expansion of enterprise database systems. Manage data collection to quantify processes; prepare reports and analyses to present current processes and alternatives. Design and configure data collection tools and processes; develop, construct and maintain programs to extract, summarize, and format data; run data integrity checks; work with school, departmental and central university personnel to improve data quality. Complete other analysis, reporting, and projects as instructed.
Perform research and analysis within and across different parts of the school including, but not limited to: Enrollment Management, Communications, Office of Admissions, the Dean of Students office, Educational Financing, and Operations.
Extract data from multiple University systems, local databases and non-University sources across different platforms.
Work with ED to institute policies and processes to ensure efficient reporting request processes for end users Stay abreast on the latest data analysis tools and software to make implementation recommendations when relevant
Cultivate collaborative relationships with central IT resources departments and peer departments to leverage institutional knowledge
Forge strong relationships with end-users to improve the analysis-as-a-service experience
Organize enterprise reporting interface to maximize utility across a wide variety of user profiles.
Educate end users on reporting tools and capabilities to foster a culture data-driven decision-making
Create documentation to support users data needs
Create and manage processes for tracking and completing reporting and data requests
Attend on-going training and professional development events
Create and optimize report delivery cycles to support and correspond with cyclical operational activities
Create process for evaluating performance in a variety of areas related to organizational operations (ie. balanced scorecard)
Identify appropriate disparate data sources to include into analysis
Create and leverage predictive models to support decision-making for enrollment management and retention
General Minimum Qualifications: Bachelor's degree required. Four to six years of professional experience as a business analyst, database administrator, or serving in an analytical or information specialist role within an academic, nonprofit, corporate or consulting setting.
Additional Specific Minimum Qualifications: Qualifications Experience with database and reporting systems, analysis and reporting required. Must be extremely competent with Excel, as well as, possess the ability to mine data via SQL and perform database scripting. Familiarity with or willingness to learn SIS as well as other systems, applications and software used by the University and the School required. Exceptional interpersonal, organizational, and oral and written communication skills required. Must have the initiative and ability to start and complete projects with minimum direction as well as the ability to work as part of a team. Experience in designing business intelligence solutions through use of data visualization software required (Tableau preferred). Aptitudes toward bringing together the art and science of data visualization in order to uncover trends, realize insights, explore sources, and tell stories. Analytical acumen necessary to interpret and manage data. Experience with statistical programs, data mining, and comprehensive analysis required.
Preferred Qualifications: Advanced degree in a related field of study. Knowledge of and commitment to the values and mission of the Columbia University School of General Studies. Experience in a customer relationship management environment 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.
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.