Jobs for People with MS: National MS Society

• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Salary Range: $85,000 - $110,000

Position Summary

NOTE: This role requires an on-campus presence each week. Please include salary requirements along with a cover letter and resume when applying.

The Office of Planning and Institutional Research (OPIR), part of the Office of the Provost, supports Columbia's senior leadership through the collection, analysis, and reporting of data on issues of institutional importance. The Associate Director of Data Management and Reporting is an integral member of the OPIR team and will help realize the office's goals of fostering a healthy data culture, securing data integrity, and formalizing data governance. The Associate Director will work closely with the OPIR team and stakeholders across the institution to identify and prioritize needs, manage related projects, and coordinate data and reporting efforts across the University.

The position will collaborate with OPIR leadership to facilitate mandatory federal and state reporting, compile and make available data for university decision-making, and oversee external reporting needs of schools. The Associate Director will have the experience and skills needed to extract and manipulate complex data sets, and organize data into meaningful reports that can be acted upon by internal and external constituencies. The Associate Director will be expected to contribute domain knowledge to the application of effective data management, security, stewardship, and governance processes.

The work involves accessing and extracting data from the university's administrative data systems, including enrollment, employee, salary, tuition, finance, financial aid, research, facilities, and space and preparing these data in an appropriate format for reporting or analysis.

More generally, the Associate Director will support and advance the office's core activity of capturing, analyzing, and interpreting data on faculty, students, staff, and other critical institutional information used in managing the university and in making decisions about policies and goals for the university. The Associate Director will support efforts to implement best practices promoting data integrity, governance and security, and ensure that system performance supports timely and accurate reporting.

Responsibilities

Data Management, Integrity and Security

• Incumbent will contribute to design, development, maintenance, and oversight of databases, as directed by leadership. Will construct processes to leverage data extracts as needed, including ETL, ELT, and stored procedures in MS SQL Server.
• Develop and maintain processes that adhere to data governance principles in the management of the OPIR database, including data security and quality control procedures for extracting queries and for storing data.
• Monitor and update reporting definitions and rules necessary for the technical design, building, and testing of database tables.
• Maintain documentation of data sources and comprehensive data dictionaries for the OPIR data warehouse.
• Work with the OPIR team to formalize data governance used in reporting.
• Collaborate with other university offices such as CUIT, Human Resources, and Finance, as needed.

Reporting

• Maintain data needed for completion of Federal and state reporting for which OPIR is responsible.
• Contribute to publicly available data reports such as the Statistical Abstract, Columbia FACTS, and the Common Data Sets annually.
• Build and evaluate complex data sets.
• Establish data requirements and develop, produce, and maintain queries and reports to support OPIR reporting and data analysis needs. Develop new analytics BI solutions; support and maintain and improve existing solutions.
• Work to automate OPIR reports and their distribution.
• Generate ad hoc reports in response to requests for information about the university and its schools from internal and external sources.
• Present information in a clear, concise, and understandable format.
• Manage maintenance and updates for OPIR website. Help coordinate semi-regular reviews of the website.

Strategic Planning

• Keep current with trends in higher education and practices, particularly on best practices regarding knowledge management in colleges and universities, including building data warehouses, developing institutional reporting strategies, and providing decision support.
• Recommend standardized practices in developing data solutions.
• Explore techniques and technologies in BI to generate insightful analytics.
• Serve as an effective liaison with important stakeholders, including Schools and CUIT.
• Support other team members through organized training and ongoing knowledge transfer.

Other related duties, as required.

Minimum Qualifications

• Bachelor's and/or its equivalent Degree in social science, information or data science, statistics, computer science, business analytics, or related discipline.
• Four to six years of relevant experience in business intelligence, data management and reporting.
• Demonstrated success navigating a complex work environment in higher education.
• Demonstrated knowledge of and experience with relational database concepts, MS SQL Server, SQL, data modeling, and data warehousing techniques. Proven ability to ensure data security.
• Data visualization and reporting tools experience (PowerBI, Tableau, Oracle Analytics Cloud, or similar) as well as the ability to manipulate, transform, or merge datasets using tools such as Excel, R, or python is necessary.
• Ability to prioritize and manage multiple tasks and projects under short and changing deadlines, while ensuring accuracy.
• Must show a willingness to work independently, demonstrate creativity and initiative, have excellent organization skills, attention to detail, and a sense of humor.
• Must be able to communicate complex technical matters effectively to diverse audiences.
• Must be able to exercise sound judgment, strategic thinking, discretion, and tact in a highly confidential and professional setting.

Preferred Qualifications

• Higher education experience is strongly preferred.
• Familiarity with enterprise-level reporting tools is an asset.

Notes: Finalists will be expected to demonstrate MS SQL Server proficiency.

A resume and cover letter must be submitted to be considered for the position.

Hybrid work possible.