Associate Director, Data and Analytics Contract

Position Summary

The
Associate Director, Data and Analytics develops, manages, and maintains various data-driven processes and applications for reporting and
analysis related to academic and curricular reporting for Columbia College. The Associate 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 Associate Director will assist the Senior
Director, Data and Analytics in overseeing the Data Group’s project portfolio and task management.

This position works closely with
Academic Planning and Administration, the Committee on Instruction, and the Center for the Core Curriculum.

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.
• Create and provide ad-hoc reports and datasets in response to requests from
  various departments.
• Assist the Senior Director, Data and Analytics with portfolio and task management, overseeing projects,
  requests, and workflows handled by the Data Group.
• 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.
• 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.
• Oversee student pre-registration data load via batch, with the assistance of the Core Curriculum staff, of Core courses
  into the University’s student information system.
• Coordinate with partner offices and relevant stakeholders to ensure accurate data
  for this pre-registration process.
• Develop and maintain the enrollment model used for registration and resource planning within the
  Core office.
• Collate and analyze evaluation data to support data-informed decision making by Core administrators and course
  chairs.
• Create longitudinal analyses on enrollment behavior for College administrators.
• Generate analyses for the
  Committee on Instruction (COI) to support academic policy and decision making.
• Work on special projects as deemed relevant and be
  available as needed for technical and other support during critical periods.

Minimum Qualifications

• Bachelor’s
  degree or equivalent required.
• 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.

**Applications without a resume and cover letter will not be considered**

Preferred Qualifications

• Experience with SQL Server Reporting Services (SSRS), Tableau, or other enterprise-level reporting
  tool is preferred.
• Knowledge of a programming language such as Python or R.
• Experience with both qualitative and
  quantitative statistical methods in survey design, research, or assessments is preferred.
• 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.