Data Management and Reporting Analyst - EXTENDED

SUMMARY DESCRIPTION

Under the direction of an appropriate level manager, the Data Management and Reporting Analyst supports data management, reporting, and analytical functions aligned with the district’s transition to and ongoing operation of the ERP system and associated modules. This position plays a critical role in ensuring data quality, enabling effective reporting, and supporting institutional decision-making. This position is responsible for ensuring data integrity, facilitating efficient data migration, and developing standardized and ad hoc reports to support institutional decision-making.

REPRESENTATIVE DUTIES

The following duties are typical for this position. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.

Collaborate with stakeholders across functional areas (student services, instruction, finance, HR, etc.) to define and meet data and reporting needs during and after the implementation of the ERP system and related modules.

Develop and maintain reports, dashboards, and data extracts using ERP tools and business intelligence platforms (e.g., Insights, SQL Server Reporting Services, Tableau).

Assist in planning and executing data migration and validation efforts related to the implementation of the ERP system and associated modules and future additional modules that may be purchased or locally developed.

Support ongoing data governance efforts to ensure data consistency, reliability, and compliance with internal standards and external reporting requirements.

Analyze data workflows and recommend improvements to streamline processes and enhance reporting capabilities.

Monitor scheduled reporting processes and troubleshoot issues as needed.

Translate end-user requirements into technical specifications for reports, dashboards, and data extracts.

Create and maintain documentation of data definitions, reporting procedures, and training materials.

Serve as a liaison between IT, Institutional Research offices, and administrative/academic departments on data and reporting initiatives.

Ensure compliance with FERPA and all applicable data privacy regulations.

Participate in workgroups, task forces, and committees related to the ERP implementation and ongoing operations, institutional effectiveness, and reporting.

Performs other duties as assigned that support the overall objective of the position.

QUALIFICATIONS

The following generally describes the knowledge and ability required to enter the job and/or be learned within a short period of time in order to successfully perform the assigned duties.

Knowledge of:

Commercial ERPs (e.g., Banner and associated third party modules) data structure, reporting environments, and reporting, particularly in a SaaS environment.

Institutional research in a college environment, accreditation reporting (e.g., ACCJC), and compliance frameworks (e.g., MIS, IPEDS).

Report development tools for operational and analytical reporting.

Programming and scripting languages used in data management including structured query language (SQL).

Database concepts, data warehousing technologies, and data visualization tools.

Programming languages used by the district to support the ERP, or others currently in industry use.

Agile software development methodologies.

Object-oriented software development techniques and tools.

Job scheduling and management automation tools.

Software development collaboration tools.

Technical writing skills to document applications and instructional content.

Problem solving and analytical skills.

Communications techniques to facilitate group processes, conduct training and provide technical support.

Ability to:

Perform all of the relevant duties of the position.

Work with users to gather requirements, analyze, design, develop, test and deploy reporting and analytics solutions for users.

Employ programming, scripting and reporting languages to develop and maintain reports and analytics.

Utilize relational database management systems (SQL query development, etc.) and data warehouse environments.

Work independently and collaboratively in a diverse, equity-minded environment.