Summary of Position

Collects, analyzes, and reports data across academic and administrative areas. Develops and delivers regular and ad hoc reports to meet external reporting requirements and internal data needs. Designs interactive dashboards to support institutional planning, decision-making, and process improvement.

Position Information:

Essential Functions and Responsibilities: Completes Integrated Postsecondary Education Data System (IPEDS) and Higher Information System (HEI) reporting for the state of Ohio, Student-Right-to Know, and other required submissions.

Designs and develops dashboards and reports in Power BI for internal and external stakeholders. Utilizes advanced SQL (PL/SQL, Oracle) skills to query large datasets, join relational tables, and extract meaningful insights.

Builds and maintains workflow automation solutions to streamline repetitive tasks such as ETL processes, report generation, and dashboard updates.

Establishes data governance and collection methodologies; validates, cleans, and integrates data from multiple sources to ensure accuracy, consistency, and security.

Supports continuous quality improvement initiatives for reporting, analytics, and data integrity.

Develops, implements, maintains, and executes routine standardized and ad hoc reports and common data sets.

Collaborates with department to implement data governance best practices.

Documents data procedures, reporting protocols, and process standards to ensure consistency and transparency.

Other Functions and Responsibilities: Assists with training new hires.

Performs other duties as assigned and/or required that are within the level of responsibility for this classification at the discretion of the supervisor.

Minimum Qualifications: At least a bachelor's degree in a related field such as data analytics, data science, statistics, math, or computer science; and one or more years of relevant experience in data analysis.

Preferred Qualifications: Master’s degree. Experience with compliance reporting and surveys for higher education (IPEDS, HEI, CDS, etc.). Experience working in institutional research. Experience with Ellucian Banner and Ellucian Operational Data Store (ODS). Ability to extract, integrate, and model data from these systems. Experience in developing dashboards and reports in Power BI. Strong understanding of data analysis and business intelligence (BI) tools (e.g., Excel, Power BI), as well as statistical and programming tools such as SPSS, SAS, R, Python, and SQL. Excellent analytical and critical thinking skills with the ability to interpret data and communicate insights effectively. Experience working in higher education.