Class specifications are intended to present a descriptive list of the range of duties performed by employees in the position. Specifications are not intended to reflect all duties performed within the job.
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.
Communicate clearly and concisely, both orally and in writing.
Establish and maintain effective working relationships with colleagues.
Adapt to changing organizational technology needs.
Manage complex projects and collaborate effectively with cross-functional teams.
Employ strong analytical, organizational, and problem-solving skills.
Be detail-oriented with a commitment to data accuracy and quality.
Maintain currency with rapidly changing technology.
Communicate technical and complex information to ‘non-technical’ users.
Provide training to users on reporting and analytics solutions.
Adapt to tight deadlines and evolving priorities.
Effectively acknowledge and take corrective action from assigned supervisor or designee.
Report to work on a regular and consistent basis, as scheduled, to assigned job.
EDUCATION AND EXPERIENCE GUIDELINES
Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:
Education/Training:
Bachelor’s degree from an accredited college or university with major course work in Computer Science, Data Science, Software Engineering, Business, Information Technology, IT Management, Information Systems, or related field.
Experience:
At least four years of experience in Computer Science, Data Science, Software Engineering, Business, Information Technology, IT Management, Information Systems, or related field.
Licenses, Certificates, and/or Other Requirements:
A valid California driver’s license may be required.
WORK ENVIRONMENT AND PHYSICAL DEMANDS
The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.
Work Environment
Duties are performed primarily in an office environment at a desk or computer workstation. Incumbents are subject to frequent contact in person and on the telephone with administrative, management, supervisory, academic, and classified staff. Work may require travel to other offices or locations to attend conferences, meetings, or conduct work.
Physical Demands
Typically, must sit for long periods, use hands and fingers to operate a computer keyboard, remember key information, and concentrate for prolonged periods. Must see to read all printed materials, including fine print, computer screens, and electronic displays. Must hear and understand voices to conduct face-to-face and telephone conversations. Must speak in an understandable voice with sufficient volume to be heard within a normal conversational distance, on the telephone, and when addressing groups. Must be able to transport oneself to places necessary to perform job duties. May need to lift, carry, and/or move objects weighing up to 10 pounds.