The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Position Summary
The Institutional Research Analyst provides reliable and accurate information in support of transparent, evidence-based planning and decision-making for the Columbia Engineering Dean???s Office.
The Institutional Research Analyst is responsible for developing, managing and maintaining reports and data-driven processes and applications for analysis within Columbia Engineering. This includes projects related to Academic Programs, Graduate Admissions, CVN, Finance, Human Resources, Faculty Affairs, and Sponsored Projects. The incumbent will use varied data sources to retrieve data, perform analysis and assessment, and report on that data.
The IR Analyst will report to the Associate Director of Institutional Research and Analysis as well as working closely with the Chief Financial and Administrative Officer of Columbia Engineering and the Assistant Dean of Engineering Student Affairs.
Responsibilities
(30%) Provide data and reports for both regularly required data as well as ad-hoc requests for data from various stakeholders. Respond quickly to user requests and provide ad-hoc reports and datasets in response to requests from various departments. Develop and automate student enrollment, student funding, and financial reports. Assist with tracking financial activity across the School against commitments.
(25%) Extract data from Student Information System and other university managed data systems using SQL and Python for various requests for information. Quickly assess user needs and translate into clear and concise data requirements to ensure data and reports are provided in a timely fashion. Maintain documentation in the form of code and solutions for transmission to other data users.
(15%) Develop quality control systems to proactively determine risks, identify database discrepancies and work with various datasets to execute reconciliation with data and provide accurate and detailed reports. Supports new initiatives to create and maintain robust accountability systems including the development of assessment tools.
(10%) Maintain various survey processes which includes distributing the instruments, making regular updates at the request of academics, ensuring proper documentation for any changes, maintaining consistency between survey tool and database, producing reports and ad hoc data requests based upon various data, and seeking ways to streamline the processes already in place. Administer regularly scheduled and ad hoc surveys/participant research and report results. Develop a level of expertise with qualitative data collection and analysis.
(10%) Prepare reports and presentations for various different audiences using data collected and analyzed. Prepare and present data to various audiences using tables, charts, and narrative reports in a way that stakeholders can easily understand. 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, optimize operational processes and improve efficiency.
(5%) Participate in evaluating new technologies so as to ensure the advancement of best practices and business intelligence needs. Assist with planning, development, and implementation of strategic initiatives for the Academic Programs office as required.
(5%) Performs other tasks, duties, and responsibilities as required
Minimum Qualifications
2-4 years related experience.
Bachelor???s degree in statistics, data science, social sciences, or a related field required (Master???s preferred).
Demonstrated data management skills including the ability to manage large data sets. Relational database management system (RDBMS) experience is a plus.
Competency with SQL (joins, aggregate functions, subqueries) and Python along with advanced proficiency in Excel/GoogleSheets. Some experience with statistical software (such as SPSS, STATA, SAS, or R) is desirable.
Skill and experience with descriptive statistics, large data sets, and quantitative research methods.
Advanced knowledge of data visualization for presentation (e.g., Tableau, PowerPoint, Google Slides, Canva).
Strong attention to detail, flexibility, and ability to work well independently.
Experience in higher education, particularly in an institutional research office, is also desirable.
Proficiency in organizing and reporting data with strong attention to detail and accuracy and ability to solve complex research methodology. Experience in interpreting and evaluating research results.
Excellent analytical and problem-solving skills with prior experience in variance analysis and financial modeling preferred.
Positive, mission-oriented, forward-thinking attitude and sense of humor a must.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
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.