Data Analyst

A renowned University is seeking a Data Analyst. The Data Analyst is an integral part of a cross-functional team that supports the department. The objective is to support data-driven planning and decision-making and to support continuous improvement efforts across the organization.

This role will focus on areas related to Budget, Financial reporting, and Sponsored Projects. The Data Analyst will also work closely with the members of the Budget and Finance team to develop, test, and maintain data assets (e.g., reports).

Job Responsibilities:

• 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. - 35%
• Extract data from 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. - 30%
• Work with the Director to prepare reports and presentations for various audiences using data collected and analyzed. Prepare and present data to various audiences using data visualizations 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. - 20%
• 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%
• Performs other tasks, duties, and responsibilities as required - 15%

Requirements:

• 2-4 years of related experience in higher education-related organizations.
• 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 and experience leveraging relational database management systems (RDBMS).
• Proficiency with SQL (e.g., joins, aggregate functions, subqueries) and Python, along with advanced proficiency in Excel.
• Competency with Google scripting is a plus.
• Skill and experience with descriptive statistics, large data sets, and quantitative research methods.
• Creativity for displaying data based on the audience and knowledge of data visualization techniques and tools (e.g., Power BI).
• Strong attention to detail, flexibility, and ability to work well independently and as part of a team.
• 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 the 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.
• A positive, mission-oriented, forward-thinking attitude and sense of humor is a must.

Compensation: $35-$40/ Hour

Salary is based on a range of factors that include relevant experience, knowledge, skills, other job-related qualifications.