Primary Function:

Ensures that office data is organized correctly and optimized into information systems to help achieve the office’s critical objectives. Analyzes and translates office business needs into long-term, sustainable data models across various University data subject areas including admissions and financial aid; campus life; diversity, equity, and inclusion; finance, human resources, and student success by transforming various applications data sources into a centralized data platform.

Typical Duties & Responsibilities:

• Designs and maintains an office system that transforms, organizes, and warehouses data and information into comprehensible data models. Maps data from new sources to the central warehouse to support the creation of new or the extension of existing reports and dashboards. Develops and executes queries and procedures to extract, transform, and load data.

• Supports Toad Data Point and Tableau platforms through building data pipelines to facilitate the growth of dashboards and incorporate new and diversified data sources.

• Manages all technical aspects of the office’s business intelligence environment, including data transformation and governance, performance monitoring, and identification and support of analytics tools.

• Conducts regular reviews of data architecture, security, management, and permissions to enable proper data access and management to sources.

• Uses analysis and query techniques to develop reports and data analytics solutions from external sources such as the College Board and IPEDS. 

• Collaborates with academic units and business departments to audit operational and application data sources in order to troubleshoot data discrepancies, correct and enhance business processes, and systematically cleanse inaccurate data sets.

• Identifies, collects, and curates datasets to effectively support the publishing of key performance indicators and other effectiveness metrics for the University’s Strategic Planning efforts, accreditation activities, and mandatory compliance endeavors.

• Manages tables and data views within various databases (MySQL, Oracle, and SQL Server).

• Handles complex data issues with minimal supervision, while escalating critical issues to management using sound judgment.

• Enforces data quality, knowledge retention, and process consistency through the curation and expansion of the office’s data dictionary and catalog.

• Develops detailed technical specifications, data mapping, and data flow documentations for major data analytics projects.

• Assumes additional responsibilities as assigned.