• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $85,000 - $90,000 Annually

Position Summary

The Assistant Director, Data and Analytics develops, manages, and maintains various data-driven processes and applications for reporting and analysis related to the administrative functions of Columbia College. The Assistant Director supports data integrity and data security, while working with large data sets and performing various processes utilizing ETL. The incumbent will work with various data sources to perform analysis, assessment, and reporting. As an integral member of the team, the Assistant Director will assist the Senior Director, Data and Analytics in overseeing the Data Group?s project portfolio and task management.

Responsibilities

• Work with the Senior Director, Data and Analytics and the Executive Director of Information Technology and Strategic Analytics to deliver data analysis, data visualization and business intelligence to the Office of the Dean, Senior Staff of the College and other critical partners to provide insight and inform decision making. Produce dashboards and reports that visualize data, making them easily translatable and useful for business decisions. Facilitate processes that translate data into actionable insights in order to solve problems, provide insight, and optimize operational processes and improve efficiency. Identify, analyze, and interpret trends or patterns in complex data sets using statistical techniques. Participate in evaluating new technologies so as to ensure the advancement of best practices and business intelligence needs for the College
• Create, maintain, and document innovative, user-friendly front-end reporting tools and platforms that provide point-and-click ability to produce reports for operational and analysis needs.  Build and maintain databases and automate data processes, including ETL, SQL, stored procedures, SSRS, SSIS, Tableau, etc., for in-house and third-party databases. Develop and provide ad-hoc reports and datasets in response to requests from various departments
• Provide quantitative and qualitative analysis and feedback for research, surveys, and assessments; help facilitate design, execution, and reporting on research findings for use in strategic planning and policy development/implementation. Create frameworks for forecasting and modeling projects
• Participate in planning short and long-term projects with the Senior Director, Data and Analytics; the Executive Director of Information Technology and Strategic Analytics; and other team members, and participate in implementing strategic initiatives around research, forecasting, analysis, and reporting
• Assist Senior Director, Data and Analytics with project portfolio and task management, overseeing projects, requirements and workflows managed by the Data Group
• Research and evaluate available sources of data to extract, clean, and manipulate datasets for use. Facilitate processes that translate data into actionable insights in order to solve problems, provide insight, and optimize operational processes and improve efficiency
• Produce longitudinal analyses on enrollment behavior for College administrators. Generate analyses for the Committee on Instruction (COI) to support academic policy and decision making
• Provide technical mentoring to junior staff and student interns
• Work on special projects as deemed relevant and be available as needed for technical and other support during critical periods
• Other related duties as assigned

Minimum Qualifications

• Bachelor?s degree or equivalent
• A minimum of 3 to 5 years of experience, or combination of education and experience
• The ability to work with a high degree of independence and accountability as a member of a cohesive team
• Excellent verbal and written communications skills
• Proficiency in SQL and query and reporting analysis tools including ETL, cubes, and reporting services
• Familiarity with relational database design. Proficiency with the Microsoft Office Suite, especially Excel
• Ability to prioritize and manage multiple tasks under short and changing deadlines, while ensuring timely and accurate execution
• Proven ability to create project plans and successfully complete projects
• Excellent analytical, organizational, and interpersonal skills required; ability to analyze and interpret complex data sets, make findings relevant, and explain data and technology to a general (non-technical) audience
• Act as an analytical thinker with the ability to work collaboratively and independently
• Must have the ability to exercise sound judgment, discretion and tact in a highly confidential professional setting

Preferred Qualifications

• Experience with Tableau, Power BI, or other enterprise-level reporting tool 
• Knowledge of a programming language such as Python or R
• Experience using student information systems (SIS) and/or high-level enterprise resource planning (ERP) systems

Equal Opportunity Employer / Disability / Veteran

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

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.

Connections working at Columbia University